Advanced
- 1.Database Design and Normalisation
- 2.INNER JOIN and LEFT JOIN
- 3.RIGHT JOIN, CROSS JOIN, Self-Joins, and Multi-Table Joins
- 4.Subqueries
- 5.Common Table Expressions (CTEs)
- 6.Window Functions
- 7.Views
- 8.Stored Procedures and Functions
- 9.Triggers and Scheduled Events
- 10.Query Optimisation
PDF Downloads