Chapter 30: Star vs Snowflake Schema
Before a single query runs against a data warehouse, someone has to decide how the data is organized. That decision, the schema design, determines how fast analysts can query it, how much storage it consumes, and how hard it is to maintain as the business changes. Two patterns dominate warehouse design: the star schema and the snowflake schema. Understanding both, and knowing when to use which, is one of the most practical skills a data engineer brings to the table.
Chapter 31: Slowly Changing Dimensions (SCD)
Slowly Changing Dimensions
Chapter 32: Advanced Snowflake
Performance tuning, clustering, tasks, streams, sharing, and governance.