Data Driven Insights

← Back to roadmaps

Phase 1

Learn the Basics

Understand what relational databases are and how SQL fits into data storage.

Topics

1. What are Relational Databases?Read →2. RDBMS Benefits and LimitationsRead →3. SQL vs NoSQL DatabasesSoon

Phase 2

Basic SQL Syntax

Learn the core SQL statements and basic building blocks used in queries.

Topics

1. SQL KeywordsSoon 2. Data TypesSoon 3. OperatorsSoon 4. SELECT StatementSoon 5. INSERT StatementSoon 6. DELETE StatementSoon 7. UPDATE StatementSoon

Phase 3

Data Definition Language — DDL

Learn how to create, modify and remove database structures.

Topics

1. What is DDL?Soon 2. CREATE TABLESoon 3. ALTER TABLESoon 4. TRUNCATE TABLESoon 5. DROP TABLESoon

Phase 4

Data Manipulation Language — DML

Learn how to retrieve, insert, update and delete data from tables.

Topics

1. What is DML?Soon 2. SELECT with FROMSoon 3. WHERESoon 4. JOINs in SELECTSoon 5. GROUP BYSoon 6. ORDER BYSoon 7. HAVINGSoon 8. INSERTSoon 9. UPDATESoon 10. DELETESoon

Phase 5

Aggregate Queries

Learn how to summarise data using aggregate functions and grouped results.

Topics

1. What are Aggregate Queries?Soon 2. SUMSoon 3. COUNTSoon 4. AVGSoon 5. MINSoon 6. MAXSoon 7. GROUP BY with AggregatesSoon 8. HAVING with AggregatesSoon

Phase 6

Data Constraints

Learn how constraints protect data quality and maintain database integrity.

Topics

1. What are Data Constraints?Soon 2. Primary KeySoon 3. Foreign KeySoon 4. UNIQUESoon 5. NOT NULLSoon 6. CHECKSoon

Phase 7

JOIN Queries

Learn how to combine data from multiple tables using different join types.

Topics

1. What are JOIN Queries?Soon 2. INNER JOINSoon 3. LEFT JOINSoon 4. RIGHT JOINSoon 5. FULL OUTER JOINSoon 6. SELF JOINSoon 7. CROSS JOINSoon

Phase 8

Subqueries

Learn how to use queries inside other queries for more flexible logic.

Topics

1. What are Subqueries?Soon 2. Scalar SubquerySoon 3. Column SubquerySoon 4. Row SubquerySoon 5. Table SubquerySoon 6. Nested SubqueriesSoon 7. Correlated SubqueriesSoon

Phase 9

Advanced Functions

Learn useful SQL functions for text, numbers, null handling, conditions and dates.

Topics

Phase 10

Views, Indexes, Transactions, Security, Performance and Advanced SQL

Move into production-level SQL topics including optimisation, transactions and advanced query patterns.

Topics

1. What are Views?Soon 2. Creating ViewsSoon 3. Modifying ViewsSoon 4. Dropping ViewsSoon 5. What are Indexes?Soon 6. Managing IndexesSoon 7. Query Optimization with IndexesSoon 8. What are Transactions?Soon 9. BEGINSoon 10. COMMITSoon 11. ROLLBACKSoon 12. SAVEPOINTSoon 13. ACIDSoon 14. Transaction Isolation LevelsSoon 15. Data Integrity ConstraintsSoon 16. GRANT and REVOKESoon 17. Database Security Best PracticesSoon 18. Stored ProceduresSoon 19. FunctionsSoon 20. Performance OptimizationSoon 21. Query Analysis TechniquesSoon 22. Using IndexesSoon 23. Optimizing JoinsSoon 24. Reducing SubqueriesSoon 25. Selective ProjectionSoon 26. Query Optimization TechniquesSoon 27. Advanced SQL OverviewSoon 28. Recursive QueriesSoon 29. Pivot OperationsSoon 30. Unpivot OperationsSoon 31. Common Table ExpressionsSoon 32. Dynamic SQLSoon 33. Window FunctionsSoon 34. ROW_NUMBERSoon 35. RANKSoon 36. DENSE_RANKSoon 37. LEADSoon 38. LAGSoon