Phase 1

Learn the Basics

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

Topics

Live

0 / 3

Completed

1. What are Relational Databases?Available 2. RDBMS Benefits and LimitationsAvailable 3. SQL vs NoSQL DatabasesAvailable

Phase 2

Basic SQL Syntax

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

Topics

Live

0 / 7

Completed

1. SQL KeywordsAvailable 2. Data TypesAvailable 3. OperatorsAvailable 4. SELECT StatementAvailable 5. INSERT StatementAvailable 6. DELETE StatementAvailable 7. UPDATE StatementAvailable

Phase 3

Data Definition Language — DDL

Learn how to create, modify and remove database structures.

Topics

Live

0 / 5

Completed

1. What is DDL?Available 2. CREATE TABLEAvailable 3. ALTER TABLEAvailable 4. TRUNCATE TABLEAvailable 5. DROP TABLEAvailable

Phase 4

Data Manipulation Language — DML

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

Topics

Live

0 / 10

Completed

1. What is DML?Available 2. SELECT with FROMAvailable 3. WHERE CLAUSEAvailable 4. JOINs in SELECTAvailable 5. GROUP BYAvailable 6. ORDER BYAvailable 7. HAVINGAvailable 8. INSERTAvailable 9. UPDATEAvailable 10. DELETEAvailable

Phase 5

Aggregate Queries

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

Topics

Live

0 / 0

Completed

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

Live

0 / 0

Completed

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

Live

0 / 0

Completed

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

Live

0 / 0

Completed

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

Live

0 / 0

Completed

1. What are SQL Functions?Soon

2. CONCATSoon

3. LENGTH / LENSoon

4. SUBSTRINGSoon

5. REPLACESoon

6. UPPERSoon

7. LOWERSoon

8. FLOORSoon

9. ABSSoon

10. MODSoon

11. ROUNDSoon

12. CEILINGSoon

13. CASESoon

14. NULLIFSoon

15. COALESCESoon

16. DATESoon

17. TIMESoon

18. TIMESTAMP / DATETIMESoon

19. DATEPARTSoon

20. DATEADDSoon

Phase 10

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

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

Topics

Live

0 / 0

Completed

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

Loading Data Driven Insights

Preparing your learning content.

Phase 1

Learn the Basics

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

Topics

Live

0 / 3

Completed

1. What are Relational Databases?Available 2. RDBMS Benefits and LimitationsAvailable 3. SQL vs NoSQL DatabasesAvailable

Phase 2

Basic SQL Syntax

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

Topics

Live

0 / 7

Completed

1. SQL KeywordsAvailable 2. Data TypesAvailable 3. OperatorsAvailable 4. SELECT StatementAvailable 5. INSERT StatementAvailable 6. DELETE StatementAvailable 7. UPDATE StatementAvailable

Phase 3

Data Definition Language — DDL

Learn how to create, modify and remove database structures.

Topics

Live

0 / 5

Completed

1. What is DDL?Available 2. CREATE TABLEAvailable 3. ALTER TABLEAvailable 4. TRUNCATE TABLEAvailable 5. DROP TABLEAvailable

Phase 4

Data Manipulation Language — DML

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

Topics

Live

0 / 10

Completed

Phase 5

Aggregate Queries

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

Topics

Live

0 / 0

Completed

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

Live

0 / 0

Completed

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

Live

0 / 0

Completed

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

Live

0 / 0

Completed

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

Live

0 / 0

Completed

1. What are SQL Functions?Soon

2. CONCATSoon

3. LENGTH / LENSoon

4. SUBSTRINGSoon

5. REPLACESoon

6. UPPERSoon

7. LOWERSoon

8. FLOORSoon

9. ABSSoon

10. MODSoon

11. ROUNDSoon

12. CEILINGSoon

13. CASESoon

14. NULLIFSoon

15. COALESCESoon

16. DATESoon

17. TIMESoon

18. TIMESTAMP / DATETIMESoon

19. DATEPARTSoon

20. DATEADDSoon

Phase 10

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

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

Topics

Live

0 / 0

Completed

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