Data Warehouse Design Fundamentals

What You Will Learn

• Write solid SQL and apply relational concepts in PostgreSQL with schemas, indexes, and joins.
• Design bronze, silver, and gold layers and dimensional models including slowly changing dimensions.
• Build tested, documented analytics models in dbt with clear lineage.
• Operate cloud warehouses on Snowflake and BigQuery for real analytics workloads.
• Deliver a designed and built warehouse with end-to-end review.

Full Curriculum

1. 01SQL Foundations & Relational Database Concepts
2. 02PostgreSQL Deep Dive: Schemas, Indexes & Joins
3. 03Data Warehousing & Medallion Architecture (Bronze / Silver / Gold)
4. 04Dimensional Modeling: Star Schemas & Slowly Changing Dimensions
5. 05Analytics Engineering with dbt: Models, Tests & Lineage
6. 06Cloud Warehouses: Snowflake & BigQuery in Action
7. 07Capstone Project Part 1: Designing & Building the WarehouseProject
8. 08Capstone Project Part 2: End-to-End Delivery & ReviewProject

Instructor

Isuru Alagiyawanna

Lead Instructor & Head of AI Engineering

Isuru leads Zuu Crew's technical direction and curriculum design. He has trained students and professionals across practical machine learning, MLOps, and AI engineering systems with a strong emphasis on shipping production-grade work.