Module 8
SQL and Database Usage
Query and modify the database you have designed.
Beginner 480 min 0 of 20 lessons published
Lessons
-
1
Introduction to SQL Beginner Coming soon
-
2
DDL, DML, DQL, DCL and TCL Beginner Coming soon
-
3
CREATE TABLE Beginner Coming soon
-
4
INSERT Beginner Coming soon
-
5
UPDATE Beginner Coming soon
-
6
DELETE Beginner Coming soon
-
7
SELECT Beginner Coming soon
-
8
WHERE Beginner Coming soon
-
9
ORDER BY Beginner Coming soon
-
10
DISTINCT Beginner Coming soon
-
11
INNER JOIN Beginner Coming soon
-
12
LEFT JOIN and RIGHT JOIN Beginner Coming soon
-
13
Aggregate Functions Beginner Coming soon
-
14
GROUP BY and HAVING Beginner Coming soon
-
15
Subqueries Beginner Coming soon
-
16
EXISTS Beginner Coming soon
-
17
Views Beginner Coming soon
-
18
Transactions: COMMIT and ROLLBACK Beginner Coming soon
-
19
Introduction to SQL Optimisation Beginner Coming soon
-
20
Final Exercise Beginner Coming soon