Chapter 9: Window Functions
Ranking, running totals, moving averages, partitioning, and ordered analytics.
Chapter 10: Pivots
Turning rows into columns, conditional aggregation, and reporting shapes.
Chapter 11: Data Modification and Schema Design
INSERT, UPDATE, DELETE, DDL, constraints, normalization, and modeling basics.
Chapter 12: Stored Procedures
Procedural SQL, parameters, operational routines, and maintainability concerns.