Go from absolute syntax basics to advanced partitioning, database design, and real-time query tuning. Clean actual transactional datasets.
A granular breakdown of each learning module and weekly target.
Introduction to database models. Writing basic query blocks: SELECT, WHERE filters, ORDER BY sorting, and basic math operators. Creating tables and inserting test records.
Mastering aggregate functions: SUM, AVG, COUNT, MIN, MAX. Filtering grouped results using the HAVING clause. Categorizing records with CASE WHEN expressions.
Connecting multiple tables. Deep dive into INNER JOIN, LEFT OUTER JOIN, RIGHT JOIN, and FULL OUTER JOIN. Handling null constraints and combining sets with UNION/UNION ALL.
Writing nested queries. Understanding ROW_NUMBER, RANK, DENSE_RANK, and running aggregates. Calculating leads, lags, and rolling metrics across transactional periods.
Understanding database normalization (1NF, 2NF, 3NF). Creating primary and foreign keys. Building efficient transactional schemas and designing indexes to accelerate scans.
Analyzing database execution plans. Detecting index misses, table scans, and nested loops. Writing stored procedures and managing database transaction scopes.
