Velamuvi AIAcademy
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. 1

    Concepts

    4 lessons
    1. 1What Is a Data Warehouse?Soon
    2. 2OLTP vs OLAPSoon
    3. 3Star and Snowflake SchemasSoon
    4. 4Fact and Dimension TablesSoon
  2. 2

    Practice

    4 lessons
    1. 5Slowly Changing DimensionsSoon
    2. 6Modern Cloud WarehousesSoon
    3. 7Modelling With dbtSoon
    4. 8Warehouse CostsSoon

Recommended next