SQL Course Index – Dataplexa

SQL Course Index

Master SQL from fundamentals to advanced database engineering with 45 structured lessons covering queries, joins, subqueries, indexing, views, procedures, performance tuning and more.

Open SQL Course Back to Learning Hub

I. Beginner Level (15 Lessons)

1. Introduction to SQL 2. Installation & Setup 3. SQL Basics 4. SELECT Queries 5. WHERE Clause 6. AND, OR, NOT 7. ORDER BY 8. LIMIT 9. DISTINCT 10. Basic Functions 11. Aggregate Functions 12. GROUP BY 13. HAVING 14. IN, BETWEEN, LIKE 15. Basic SQL Project

II. Intermediate Level (15 Lessons)

16. Joins Overview 17. INNER JOIN 18. LEFT JOIN 19. RIGHT JOIN 20. FULL JOIN 21. CROSS JOIN 22. SELF JOIN 23. Subqueries 24. Views 25. UNION / UNION ALL 26. Indexes 27. Normalization 28. Constraints 29. Transactions 30. Intermediate SQL Project

III. Advanced Level (15 Lessons)

31. Stored Procedures 32. SQL Functions 33. Triggers 34. Cursors 35. Window Functions 36. Recursive Queries 37. Working with JSON in SQL 38. Dynamic SQL 39. Query Optimization 40. Index Tuning 41. Database Design 42. Data Warehouse Basics 43. ETL Basics 44. Advanced SQL Projects 45. Mini SQL Project