[TutsNode.com] - Data Warehouse Fundamentals for Beginners

  01 Welcome

   001 Welcome.en.srt

   002 About This Course.en.srt

   003 Reflection_ The Value of Data Warehousing.mp4

  02 Data Warehousing Concepts

   004 Introduction to Data Warehousing Concepts.mp4

   005 What is a Data Warehouse_.mp4

   006 Reasons for You to Build a Data Warehouse.mp4

   007 Compare a Data Warehouse to a Data lake.mp4

   008 Compare a Data Warehouse to Data Virtualization.mp4

   009 Look at a Simple End-to-End Data Warehousing Environment.mp4

   010 Summarize Data Warehousing Concepts.mp4

  03 Data Warehousing Architecture

   011 Introduction to Data Warehousing Architecture.mp4

   012 Build a Centralized Data Warehouse.mp4

   013 Compare a Data Warehouse to a Data Mart.mp4

   014 Decide Which Component-Based Architecture is Your Best Fit.mp4

   015 Include Cubes in Your Data Warehousing Environment.mp4

   016 Include Operational Data Stores in Your Data Warehousing Environment.mp4

   017 Explore the Role of the Staging Layer Inside a Data Warehouse.mp4

   018 Compare the Two Types of Staging Layers.mp4

   019 Summarize Data Warehousing Architecture.mp4

  04 Bring Data Into Your Data Warehouse

   020 Introduction to ETL and Data Movement for Data Warehousing.mp4

   021 Compare ETL to ELT.mp4

   022 Design the Initial Load ETL.mp4

   023 Compare Different Models for Incremental ETL.mp4

   024 Explore the Role of Data Transformation.mp4

   025 More Common Transformations Within ETL.mp4

   026 Implement Mix-and-Match Incremental ETL.mp4

   027 Summarize ETL Concepts and Models.mp4

  05 Data Warehousing Design_ Building Blocks

   028 Data Warehousing Structure Fundamentals.mp4

   029 Deciding What Your Data Warehouse Will Be Used For.mp4

   030 The Basic Principles of Dimensionality.mp4

   031 Compare Facts, Fact Tables, Dimensions, and Dimension Tables.mp4

   032 Compare Different Forms of Additivity in Facts.mp4

   033 Compare a Star Schema to a Snowflake Schema.mp4

   034 Database Keys for Data Warehousing.mp4

   035 Summarize Data Warehousing Structure.mp4

  06 Design Facts, Fact Tables, Dimensions, and Dimension Tables

   036 Introduction to Dimensional Modeling.mp4

   037 Design Dimension Tables for Star Schemas and Snowflake Schemas.mp4

   038 The Four Main Types of Data Warehousing Fact Tables.mp4

   039 The Role of Transaction Fact Tables.mp4

   040 The Rules Governing Facts and Transaction Fact Tables.mp4

   041 Primary and Foreign Keys for Fact Tables.mp4

   042 The Role of Periodic Snapshot Fact Tables.mp4

   043 Periodic Snapshots and Semi-Additive Facts.mp4

   044 The Role of Accumulating Snapshot Fact Tables.mp4

   045 Accumulating Snapshot Fact Table Example.mp4

   046 Why a Factless Fact Table isn't a Contradiction in Terms.mp4

   047 Compare the Structure of Fact Tables in Star Schemas vs. Snowflake Schemas.mp4

   048 SQL for Dimension and Fact Tables.mp4

   049 Summarize Fact and Dimension Tables.mp4

  07 Managing Data Warehouse History Through Slowly Changing Dimensions

   050 Introduction to Slowly Changing Dimensions.mp4

   051 Slowly Changing Dimensions (SCDs) and Data Warehouse History.mp4

   052 Design a Type 1 SCD.mp4

   053 Design a Type 2 SCD.mp4

   054 Maintain Correct Data Order with Type 2 SCDs.mp4

   055 Design a Type 3 SCD.mp4

   056 Summarize SCD concepts and implementations.mp4

  08 Designing Your ETL

   057 Introduction to ETL Design.mp4

   058 Build your ETL Design from your ETL Architecture.mp4

   059 Dimension Table ETL.mp4

   060 Process SCD Type 1 Changes to a Dimension Table.mp4

   061 Process SCD Type 2 Changes to a Dimension Table.mp4

   062 Design ETL for Fact Tables.mp4

   063 Summarize ETL Design.mp4

  09 Selecting Your Data Warehouse Environment

   064 Introduction to Data Warehousing Environments.mp4

   065 Decide Between Cloud and On-Premises Settings for Your Data Warehouse.mp4

   066 Architecture and Design Implications for Your Selected Platform.mp4

  10 Conclusion

   067 Thank you for taking the course!.mp4

 TutsNode.com.txt