Section 1: Introduction to the Course
Section 2: Data Warehousing
-
Section Introduction
-
What is a Data Warehouse? (1:40)
-
Why should you have a Data Warehouse? (1:40)
-
Is Data Warehouse still relevant in the age of big data? (1:45)
-
Data Warehouse Characteristics (4:35)
-
The Basic Data Warehouse Diagram (2:03)
-
Data Warehouse and SlicingDice (1:29)
-
How a Data Warehouse works in Practice (14:24)
-
Quiz
Section 3: Introduction to SQL
Section 4: Introduction to Business Intelligence (BI)
Section 5: Data Warehouse Architecture
Section 6: Introduction to Operational Data Store
Section 7: OLAP (Online Analytical Processing)
Section 8: Data Marts
Section 9: Data Modeling
Section 10: Modeling your data on SlicingDice
Section 11: Metadata
Section 12: Entity Relational Data Model
Section 13: Dimensional Data Model
Section 14: Introduction to Indexes
Section 15: ETL (Extract, Load & Transfrom)
Section 16: BI, DW and ETL approach
Section 17: Conclusion
