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