Data EngineerBeginnerRecording

Data Warehouse Design Fundamentals

From SQL and relational concepts through PostgreSQL, medallion architecture, star schemas, dbt, and cloud warehouses on Snowflake and BigQuery.

10 Weeks8 modules6 Modules + 2-Part Capstone

What you'll build5 outcomes

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

Full curriculum8 items · 2 projects

01SQL Foundations & Relational Database Concepts

02PostgreSQL Deep Dive : Schemas, Indexes & Joins

03Data Warehousing & Medallion Architecture (Bronze / Silver / Gold)

04Dimensional Modeling : Star Schemas & Slowly Changing Dimensions

05Analytics Engineering with dbt : Models, Tests & Lineage

06Cloud Warehouses : Snowflake & BigQuery in Action

07Capstone Project Part 1 : Designing & Building the Warehouse

Project

08Capstone Project Part 2 : End-to-End Delivery & Review

Project

Instructor

Dulanga Jayarathna

Instructor · Associate Tech Lead

Dulanga Jayarathna is an Associate Tech Lead at PickMe (Digital Mobility Solutions Lanka) and an associate instructor at Zuu Crew AI. He specialises in data engineering and analytics, with deep hands-on experience building scalable data systems.

MSc Big Data Analytics (Merit) : Robert Gordon University, UKBSc (Hons) Information Technology : University of MoratuwaAssociate Tech Lead : PickMe | Digital Mobility Solutions Lanka

Data Warehouse Design Fundamentals

See all our programsand free content.

See all our programs
and free content.