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
Isuru Alagiyawanna
Lead Instructor & Head of AI Engineering
Isuru leads Zuu Crew AI'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.
University of MoratuwaRobert Gordon University, UKHead of AI Eng, Veracity GroupAWS ML EngineerTensorFlow Certified