• Course Introduction Free
  • Meet the Instructor Free
  • Course Outline Free
  • Setting Expectations Free
  • AE 101 Recap: Overview Free
  • AE 101 Recap: Data Terms Free

  • Section Intro Free
  • Data Models Free
  • Data Modeling Terms Free
  • OLTP Data Models Free
  • OLAP Data Models Free
  • Dimensional Modeling Free
  • QUIZ: Data Modeling Overview Pro

  • Section Intro Pro
  • Table Fundamentals Pro
  • Grain (Level of Detail) Pro
  • Grain FAQs Pro
  • Primary Keys Pro
  • Natural vs Surrogate Keys Pro
  • Foreign Keys Pro
  • Table Design FAQs Pro
  • QUIZ: Table Fundamentals Pro

  • Section Intro Pro
  • Fact vs Dimension Tables Pro
  • Fact Tables Pro
  • Transaction vs Fact Tables Pro
  • Dimension Tables Pro
  • Fact and Dimension Tables Together Pro
  • QUIZ: Fact & Dimension Tables Pro

  • Section Intro Pro
  • Schema Designs Pro
  • Normalization Pro
  • Transactional Schema Pro
  • Star Schema Pro
  • Snowflake Schema Pro
  • Schema Design FAQs Pro
  • QUIZ: Schema Designs Pro

  • Section Intro Pro
  • Handling Data Changes Pro
  • Slowly Changing Dimensions Pro
  • Fact Table Changes Pro
  • Source Data Changes Pro
  • Handling Data Changes FAQs Pro
  • QUIZ: Handling Data Changes Pro

  • Section Intro Pro
  • Modern Data Workflow Pro
  • Data Analyst Role Pro
  • Data Engineer Role Pro
  • Analytics Engineer Role Pro
  • QUIZ: Modern Data Workflow Pro

  • Section Intro Pro
  • Data Modeling Process Overview Pro
  • Data Modeling Process Steps Pro
  • Project Introduction Pro
  • Step 1: Gather Requirements Pro
  • Step 2: Design Fact Table Pro
  • Step 3: Design Dimension Tables Pro
  • Step 4: Add Surrogate Keys Pro
  • Step 5: Decide on Columns Pro
  • Step 6: Handle Data Changes Pro
  • Final Project Summary Pro
  • QUIZ: Data Modeling Process Pro

  • Section Intro Pro
  • Theoretical Key Takeaways Pro
  • Practical Key Takeaways Pro

  • Course Feedback Survey Pro
  • Share the Love! Pro
  • Next Steps Pro