34 comprehensive modules, 300 practice exercises, 5 real-world systems, 150 interview questions, and a unified enterprise sandbox.
| Learning Track | Recommended Modules | Objective |
|---|---|---|
| Foundations (Days 1–7) | 01 through 10 | Master DDL, DML, Data Types, Constraints, 3VL Filtering, and Aggregations |
| Relational & Queries (Days 8–15) | 11 through 14 | Complex multi-table JOINs, Set operations, Subqueries, and CTEs |
| Architecture & Internals (Days 16–25) | 15 through 25 | Schema design, 1NF–BCNF normalization, B+ Trees, Transactions, and Optimizer tuning |
| Career & Projects (Days 26–30) | 26 through 33 | 5 complete projects, 300 exercises, 150 interview questions, and production cheat sheets |
-- Connect to the unified sandbox:
USE sql_mastery;
SELECT
d.department_name,
COUNT(e.employee_id) AS total_headcount,
ROUND(AVG(e.salary), 2) AS avg_department_salary
FROM departments d
JOIN employees e ON d.department_id = e.department_id
GROUP BY d.department_id, d.department_name
ORDER BY avg_department_salary DESC;