1.1 Script for Classic Models.txt
1. Download MySQL Workbench and Classic Models Database - Windows
2.1 Script for Classic Models.txt
2. Download MySQL Workbench and Classic Models Database - MacOS
3.1 MySQL-Sample-Database-Diagram-PDF-A4.pdf
3. What is SQL And a Relational Database
4.1 Select, From, Where.pdf
4. Select, From And Where Statement
5.1 Select Statement Exercise.pdf
5. Select Statement Q And A
6.1 Upper And Lower.pdf
6. Upper And Lower
7.1 In And Not In.pdf
7. In And Not In
8.1 Distinct, Like, Order By.pdf
8. Distinct, Like And Order By
9.1 Inner Join.pdf
9. Inner Join
10.1 Left And Right Join.pdf
10. Left And Right Join
11.1 Join Exercises.pdf
11. Joins Q And A
12.1 Union And Union All.pdf
12. Union And Union All
13.1 Sum, Round, Group by, Having.pdf
13. Sum, Round, Group by And Having
14.1 Count, Max, Min, Avg.pdf
14. Count, Max, Min, Avg
15.1 Aggregate Functions Exercise.pdf
15. Aggregate Functions Q And A
16.1 Subquery.pdf
16. Subquery
17.1 CTE.pdf
17. Common Table Expression (CTE)
18.1 Case Statement.pdf
18. Case statement
19.1 Flag using Case statement.pdf
19. Create a Flag using Case Statement
20.1 Row Number.pdf
20. Row Number
21.1 Lead And Lag.pdf
21. Lead And Lag
22.1 Row Number Exercise.pdf
22. Row Number Q And A
23.1 Date Functions.pdf
23. Date Functions
24.1 String Functions.pdf
24. String Functions
