1. Selection Commands and Operators (Theory)
2. Selection Commands and Operators (Practical Class)
3. Limit and Distinct (Practical Class)
4. Operators Arithmetic, Logical, Comparison, is (Theory)
5. Operators Arithmetic, Logical, Comparison, is (Practical Class)
6. Aliases AS (Theory)
7. Aliases AS (Practical Class)
8. Restriction Commands WHERE (Theory)
9. Restriction Commands WHERE (Practical Class)
10. Conditional Commands IF, CASE, COALESCE (Theory)
11. Conditional Commands IF, CASE, COALESCE (Practical Class)
12. Grouping and Sorting Commands GROUP BY, ORDER BY (Theory)
13. Grouping and Sorting Commands GROUP BY, ORDER BY (Practical Class)
14. Aggregation Functions COUNT, MAX, MIN, SUM, AVG (Theory)
15. Aggregation Functions I (Practical Class)
16. Aggregation Functions II (Practical Class)
17. Table Relationships Definition (Theory)
18. Tables Summary and Upload
19. Table Relationships INNER JOIN (Theory)
20. Table Relationships INNER JOIN (Practical Class)
21. Table Relationships LEFT JOIN (Theory)
22. Table Relationships LEFT JOIN (Practical Class)
23. Table Relationships RIGHT JOIN (Theory)
24. Table Relationships RIGHT JOIN (Practical Class)
25. Table Relationships FULL JOIN (Theory)
26. Table Relationships FULL JOIN (Practical Class)
27. Exercises
Files.zip
