1. Introduction to Databases & SQL

✅ Basic DB concepts, tables, keys (30 min)

✅ Covers RDBMS models, normalization (4 hours)

✅ Covers RDBMS models, normalization (4 hours)

2. SELECT Statements

✅ Basic syntax - Filtering, Aliasing, Expressions

✅ syntax, SELECT variants

✅ Elaborate syntax, SELECT variants

3. WHERE, ORDER BY, LIMIT

✅ Focused on business queries

✅ Covered, with examples

✅ Covered, with examples

4. Functions (String, Numeric, Date)

✅ Commonly used functions

✅ Many functions, including rarely used ones

✅ Many functions, including rarely used ones

5. JOINs (INNER, LEFT, RIGHT, FULL)

✅ Business use cases for joining data

✅ Theory + Execution plan analysis

✅ Theory + Execution plan analysis

6. GROUP BY & Aggregations

✅ SUM, AVG, COUNT – Context: real dashboards

✅ Advanced groupings (GROUPING SETS, CUBE)

✅ Advanced groupings (GROUPING SETS, CUBE)

7. Subqueries

✅ Subqureries for analysis

✅ Nested subqueries

✅ Advanced nested subqueries

8. CASE Statements

✅ Data categorization for dashboards

✅ Included, with conditional logic

✅ Included, with conditional logic

9. Window Functions

✅ ROW_NUMBER, RANK for analysis

✅ Same + NTILE, FIRST_VALUE, LAST_VALUE

✅ Same + NTILE, FIRST_VALUE, LAST_VALUE

10. CTEs (Common Table Expressions)

✅ Modular analysis logic

✅ Recursive CTEs and hierarchical queries

✅ Recursive CTEs and hierarchical queries

11. Data Cleaning & Transformation

✅ Handling NULLs, data formatting (60min)

✅ More depth ETL-type transformations (4 hours)

✅ More depth ETL-type transformations (4 hours)

12. Indexes & Performance Tuning

❌

✅ Indexing

✅ Indexing, EXPLAIN plans

13. DDL – CREATE, ALTER, DROP

❌ Just the Basics

✅ Full schema design, constraints

✅ Full schema design, constraints

14. DML – INSERT, UPDATE, DELETE

❌ Just the Basics

✅ Full CRUD operations

✅ Full CRUD operations and bulk ops

15. Views & Materialized Views

✅ Creating reusable query logic

✅ Performance and refresh strategies

✅ Performance and refresh strategies

16. Data Modeling Concepts

✅ Star, Snowflake (basic overview)

✅ Basic modeling and normalization

✅ Detailed modeling and normalization

17. Working with Large Datasets

✅ Efficient query structuring

✅ Query optimization

✅ Query optimization, partitioning

18. Data Security & Access

❌ Usually handled by admins

❌ Usually handled by admins

❌ Usually handled by admins

19. Real-World Case Studies / Projects

✅ Business dashboard-focused

✅ Includes data manipulation + admin

✅ Includes data manipulation + admin

20. SQL + BI Tools (e.g., Tableau/Power BI)

✅ Integration and query building

❌ Not a focus

❌ Not a focus