Lesson 1 of 21 • 70 upvotes • 11:09mins
21 lessons • 3h 46m
Learn the Basics.
11:09mins
Creating Databases and Tables
15:00mins
TABLES - ALTER, RENAME, TRUNCATE, DROP
10:15mins
INSERT TO, DELETE FROM
12:57mins
UPDATE in SQL
9:31mins
SELECT query , WHERE clause
13:32mins
SELECT TOP, ORDER BY clause
15:00mins
INSERT INTO SELECT
8:11mins
COUNT, SUM, AVG
8:20mins
IN, BETWEEN, MIN, MAX
9:11mins
INNER JOIN
11:38mins
LEFT JOIN
11:47mins
RIGHT JOIN
9:13mins
FULL JOIN
10:47mins
SELF JOIN
11:24mins
UNION
8:43mins
EXISTS, NOT EXISTS
9:22mins
GROUP BY
10:37mins
HAVING
8:16mins
ANY,ALL
11:03mins
LIKE and Wildcard Operators.
10:11mins