Section 1 : Welcome

Lecture 1 Welcome 3:53
Lecture 2 About This Course 3:59
Lecture 3 Reflection_ The Value of Data Warehousing 1:49

Section 2 : Data Warehousing Concepts

Lecture 4 Introduction to Data Warehousing Concepts 1:8
Lecture 5 What is a Data Warehouse_ 3:42
Lecture 6 Reasons for You to Build a Data Warehouse 2:40
Lecture 7 Compare a Data Warehouse to a Data lake 3:9
Lecture 8 Compare a Data Warehouse to Data Virtualization 4:10
Lecture 9 Look at a Simple End-to-End Data Warehousing Environment 1:59
Lecture 10 Summarize Data Warehousing Concepts 0:41

Section 3 : Data Warehousing Architecture

Lecture 11 Introduction to Data Warehousing Architecture 1:55
Lecture 12 Build a Centralized Data Warehouse 3:40
Lecture 13 Compare a Data Warehouse to a Data Mart 5:30
Lecture 14 Decide Which Component-Based Architecture is Your Best Fit 11:25
Lecture 15 Include Cubes in Your Data Warehousing Environment 3:51
Lecture 16 Include Operational Data Stores in Your Data Warehousing Environment 4:44
Lecture 17 Explore the Role of the Staging Layer Inside a Data Warehouse 7:18
Lecture 18 Compare the Two Types of Staging Layers 6:58
Lecture 19 Summarize Data Warehousing Architecture 0:59

Section 4 : Bring Data Into Your Data Warehouse

Lecture 20 Introduction to ETL and Data Movement for Data Warehousing 1:14
Lecture 21 Compare ETL to ELT
Lecture 22 Design the Initial Load ETL 3:47
Lecture 23 Compare Different Models for Incremental ETL 6:10
Lecture 24 Explore the Role of Data Transformation 7:28
Lecture 25 More Common Transformations Within ETL
Lecture 26 Implement Mix-and-Match Incremental ETL 2:55
Lecture 27 Summarize ETL Concepts and Models 0:33

Section 5 : Data Warehousing Design_ Building Blocks

Lecture 28 Data Warehousing Structure Fundamentals 1:36
Lecture 29 Deciding What Your Data Warehouse Will Be Used For 2:14
Lecture 30 The Basic Principles of Dimensionality 9:4
Lecture 31 Compare Facts, Fact Tables, Dimensions, and Dimension Tables
Lecture 32 Compare Different Forms of Additivity in Facts 6:4
Lecture 33 Compare a Star Schema to a Snowflake Schema 7:28
Lecture 34 Database Keys for Data Warehousing
Lecture 35 Summarize Data Warehousing Structure 1:12

Section 6 : Design Facts, Fact Tables, Dimensions, and Dimension Tables

Lecture 36 Introduction to Dimensional Modeling 0:51
Lecture 37 Design Dimension Tables for Star Schemas and Snowflake Schemas 12:3
Lecture 38 The Four Main Types of Data Warehousing Fact Tables 2:13
Lecture 39 The Role of Transaction Fact Tables 4:32
Lecture 40 The Rules Governing Facts and Transaction Fact Tables 6:19
Lecture 41 Primary and Foreign Keys for Fact Tables 5:11
Lecture 42 The Role of Periodic Snapshot Fact Tables 7:58
Lecture 43 Periodic Snapshots and Semi-Additive Facts 6:2
Lecture 44 The Role of Accumulating Snapshot Fact Tables
Lecture 45 Accumulating Snapshot Fact Table Example 6:42
Lecture 46 Why a Factless Fact Table isn't a Contradiction in Terms 9:49
Lecture 47 Compare the Structure of Fact Tables in Star Schemas vs 4:9
Lecture 48 SQL for Dimension and Fact Tables 9:4
Lecture 49 Summarize Fact and Dimension Tables 1:0

Section 7 : Managing Data Warehouse History Through Slowly Changing Dimensions

Lecture 50 Introduction to Slowly Changing Dimensions 0:45
Lecture 51 Slowly Changing Dimensions (SCDs) and Data Warehouse History 5:2
Lecture 52 Design a Type 1 SCD 3:47
Lecture 53 Design a Type 2 SCD 8:29
Lecture 54 Maintain Correct Data Order with Type 2 SCDs 5:38
Lecture 55 Design a Type 3 SCD 7:2
Lecture 56 Summarize SCD concepts and implementations 1:7

Section 8 : Designing Your ETL

Lecture 57 Introduction to ETL Design 1:11
Lecture 58 Build your ETL Design from your ETL Architecture 5:53
Lecture 59 Dimension Table ETL 6:45
Lecture 60 Process SCD Type 1 Changes to a Dimension Table 4:27
Lecture 61 Process SCD Type 2 Changes to a Dimension Table 2:31
Lecture 62 Design ETL for Fact Tables 9:7
Lecture 63 Summarize ETL Design 0:52

Section 9 : Selecting Your Data Warehouse Environment

Lecture 64 Introduction to Data Warehousing Environments 0:49
Lecture 65 Decide Between Cloud and On-Premises Settings for Your Data Warehouse 5:5
Lecture 66 Architecture and Design Implications for Your Selected Platform 5:30

Section 10 : 10 Conclusion

Lecture 67 Thank you for taking the course! 1:27