1. Introduction to SQL and its applications in data analysis.html
2. What is MySQL.html
3. MySQL Installation (Windows)
4. MySQL Installation (Mac)
5. What is MySQL Workbench
6. Installing MySQL Workbench ( Mac)
7. Database Concepts
8. What is a Schema
9. What is a Database Schema
10. MySQL Data Types
11. Exploring Basic SQL Commands
12. Showing existing databases
13. Showing lists of tables
14. Create a table
15. Displaying table structure
16. Changing table structure
17. Creating MySQL Database
18.1 table+create+script.zip
18. Creating MySQL Table
19. Setting a default database
20. Primary Keys
21. Foreign Keys
22. SQL & MySQL SELECT Statement
23.1 insert+data+into+tables.zip
23. SQL & MySQL INSERT Statement
24. SQL & MySQL UPDATE Statement
25. SQL & MySQL DELETE Statement
26. Introduction to Joins.html
27. INNER JOIN
28. LEFT JOIN
29. RIGHT JOIN
30. SELF JOIN
31. What is sub query
32. Nested sub query
33. Filtering data with WHERE Clause
34. Sorting data with ORDER BY Clause
35. Grouping data with GROUP BY Clause
36. What are aggregate functions
37. AVG Aggregate Function
38. COUNT Aggregate Function
39. SUM Aggregate Function
40. MIN Aggregate Function
41. MAX Aggregate Function
