Section 1 : Welcome
Lecture 1 Welcome 00:03:53 Duration
Lecture 2 About This Course 00:03:59 Duration
Lecture 3 Reflection_ The Value of Data Warehousing 00:01:49 Duration

Section 2 : Data Warehousing Concepts
Lecture 1 Introduction to Data Warehousing Concepts 00:01:08 Duration
Lecture 2 What is a Data Warehouse_ 00:03:42 Duration
Lecture 3 Reasons for You to Build a Data Warehouse 00:02:40 Duration
Lecture 4 Compare a Data Warehouse to a Data lake 00:03:09 Duration
Lecture 5 Compare a Data Warehouse to Data Virtualization 00:04:10 Duration
Lecture 6 Look at a Simple End-to-End Data Warehousing Environment 00:01:59 Duration
Lecture 7 Summarize Data Warehousing Concepts 00:00:41 Duration

Section 3 : Data Warehousing Architecture
Lecture 1 Introduction to Data Warehousing Architecture 00:01:55 Duration
Lecture 2 Build a Centralized Data Warehouse 00:03:40 Duration
Lecture 3 Compare a Data Warehouse to a Data Mart 00:05:30 Duration
Lecture 4 Decide Which Component-Based Architecture is Your Best Fit 00:11:25 Duration
Lecture 5 Include Cubes in Your Data Warehousing Environment 00:03:51 Duration
Lecture 6 Include Operational Data Stores in Your Data Warehousing Environment 00:04:44 Duration
Lecture 7 Explore the Role of the Staging Layer Inside a Data Warehouse 00:07:18 Duration
Lecture 8 Compare the Two Types of Staging Layers 00:06:58 Duration
Lecture 9 Summarize Data Warehousing Architecture 00:00:59 Duration

Section 4 : Bring Data Into Your Data Warehouse
Lecture 1 Introduction to ETL and Data Movement for Data Warehousing 00:01:14 Duration
Lecture 2 Compare ETL to ELT
Lecture 3 Design the Initial Load ETL 00:03:47 Duration
Lecture 4 Compare Different Models for Incremental ETL 00:06:10 Duration
Lecture 5 Explore the Role of Data Transformation 00:07:28 Duration
Lecture 6 More Common Transformations Within ETL
Lecture 7 Implement Mix-and-Match Incremental ETL 00:02:55 Duration
Lecture 8 Summarize ETL Concepts and Models 00:00:33 Duration

Section 5 : Data Warehousing Design_ Building Blocks
Lecture 1 Data Warehousing Structure Fundamentals 00:01:36 Duration
Lecture 2 Deciding What Your Data Warehouse Will Be Used For 00:02:14 Duration
Lecture 3 The Basic Principles of Dimensionality 00:09:04 Duration
Lecture 4 Compare Facts, Fact Tables, Dimensions, and Dimension Tables
Lecture 5 Compare Different Forms of Additivity in Facts 00:06:04 Duration
Lecture 6 Compare a Star Schema to a Snowflake Schema 00:07:28 Duration
Lecture 7 Database Keys for Data Warehousing
Lecture 8 Summarize Data Warehousing Structure 00:01:12 Duration

Section 6 : Design Facts, Fact Tables, Dimensions, and Dimension Tables
Lecture 1 Introduction to Dimensional Modeling 00:00:51 Duration
Lecture 2 Design Dimension Tables for Star Schemas and Snowflake Schemas 00:12:03 Duration
Lecture 3 The Four Main Types of Data Warehousing Fact Tables 00:02:13 Duration
Lecture 4 The Role of Transaction Fact Tables 00:04:32 Duration
Lecture 5 The Rules Governing Facts and Transaction Fact Tables 00:06:19 Duration
Lecture 6 Primary and Foreign Keys for Fact Tables 00:05:11 Duration
Lecture 7 The Role of Periodic Snapshot Fact Tables 00:07:58 Duration
Lecture 8 Periodic Snapshots and Semi-Additive Facts 00:06:02 Duration
Lecture 9 The Role of Accumulating Snapshot Fact Tables
Lecture 10 Accumulating Snapshot Fact Table Example 00:06:42 Duration
Lecture 11 Why a Factless Fact Table isn't a Contradiction in Terms 00:09:49 Duration
Lecture 12 Compare the Structure of Fact Tables in Star Schemas vs 00:04:09 Duration
Lecture 13 SQL for Dimension and Fact Tables 00:09:04 Duration
Lecture 14 Summarize Fact and Dimension Tables 00:01:00 Duration

Section 7 : Managing Data Warehouse History Through Slowly Changing Dimensions
Lecture 1 Introduction to Slowly Changing Dimensions 00:00:45 Duration
Lecture 2 Slowly Changing Dimensions (SCDs) and Data Warehouse History 00:05:02 Duration
Lecture 3 Design a Type 1 SCD 00:03:47 Duration
Lecture 4 Design a Type 2 SCD 00:08:29 Duration
Lecture 5 Maintain Correct Data Order with Type 2 SCDs 00:05:38 Duration
Lecture 6 Design a Type 3 SCD 00:07:02 Duration
Lecture 7 Summarize SCD concepts and implementations 00:01:07 Duration

Section 8 : Designing Your ETL
Lecture 1 Introduction to ETL Design 00:01:11 Duration
Lecture 2 Build your ETL Design from your ETL Architecture 00:05:53 Duration
Lecture 3 Dimension Table ETL 00:06:45 Duration
Lecture 4 Process SCD Type 1 Changes to a Dimension Table 00:04:27 Duration
Lecture 5 Process SCD Type 2 Changes to a Dimension Table 00:02:31 Duration
Lecture 6 Design ETL for Fact Tables 00:09:07 Duration
Lecture 7 Summarize ETL Design 00:00:52 Duration

Section 9 : Selecting Your Data Warehouse Environment
Lecture 1 Introduction to Data Warehousing Environments 00:00:49 Duration
Lecture 2 Decide Between Cloud and On-Premises Settings for Your Data Warehouse 00:05:05 Duration
Lecture 3 Architecture and Design Implications for Your Selected Platform 00:05:30 Duration

Section 10 : 10 Conclusion
Lecture 1 Thank you for taking the course! 00:01:27 Duration