Data Science & Engineering
Data Warehousing
Design storage built for analysis: star schemas, fact and dimension tables and modern cloud warehouses.
- Intermediate
- About 7 hours
- 2 modules
- 8 lessons
- Free
This course is not released yet. We publish courses one at a time, each one complete. The full syllabus is below.
What you will learn
- ConceptsWhat Is a Data Warehouse?, OLTP vs OLAP, Star and Snowflake Schemas and more
- PracticeSlowly Changing Dimensions, Modern Cloud Warehouses, Modelling With dbt and more
Course syllabus
Not released yet · full syllabus below
- 1
Concepts
4 lessons- 1What Is a Data Warehouse?Soon
- 2OLTP vs OLAPSoon
- 3Star and Snowflake SchemasSoon
- 4Fact and Dimension TablesSoon
- 2
Practice
4 lessons- 5Slowly Changing DimensionsSoon
- 6Modern Cloud WarehousesSoon
- 7Modelling With dbtSoon
- 8Warehouse CostsSoon