Completed
Star Schema-Key Points
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Dimensional Modeling
Automatically move to the next video in the Classroom when playback concludes
- 1 Dimensional Modeling The Heart of the Data Warehouse
- 2 Bryan Cafferky
- 3 What's Ahead?
- 4 Why a Data Warehouse?
- 5 When is it Not Appropriate?
- 6 Where do you start to design a data warehouse?
- 7 Transactional Database Design (OLTP)
- 8 What is Dimensional Modeling?
- 9 What's a Dimension?
- 10 What's a Fact?
- 11 The Star Schema
- 12 Star Schema-Key Points
- 13 The Snowflake Schema The Snowflake Schema
- 14 Why Surrogate Keys?
- 15 Steps of Dimensional Modeling Review
- 16 The Bus Matrix
- 17 The Seven W's of Data Warehouse Design - User Story
- 18 Seven W's of Data Warehouse Design and the User Story
- 19 Slowly Changing Dimensions
- 20 Slowly Changing Dimension-Type 3
- 21 Some Additional Thoughts...