Data Warehouse Fundamentals for Beginners

Download Now


Files Included :

1 - Welcome.mp4 (85.17 MB)
MP4
2 - About This Course.mp4 (88.24 MB)
MP4
3 - Reflection The Value of Data Warehousing.mp4 (36.08 MB)
MP4
67 - Thank you for taking the course.mp4 (8.22 MB)
MP4
10 - Summarize Data Warehousing Concepts.mp4 (3.86 MB)
MP4
4 - Introduction to Data Warehousing Concepts.mp4 (25.08 MB)
MP4
5 - What is a Data Warehouse.mp4 (32.48 MB)
MP4
6 - Reasons for You to Build a Data Warehouse.mp4 (16.58 MB)
MP4
7 - Compare a Data Warehouse to a Data lake.mp4 (43.01 MB)
MP4
8 - Compare a Data Warehouse to Data Virtualization.mp4 (21.74 MB)
MP4
9 - Look at a Simple EndtoEnd Data Warehousing Environment.mp4 (19.92 MB)
MP4
11 - Introduction to Data Warehousing Architecture.mp4 (10.75 MB)
MP4
12 - Build a Centralized Data Warehouse.mp4 (16.24 MB)
MP4
13 - Compare a Data Warehouse to a Data Mart.mp4 (55.94 MB)
MP4
14 - Decide Which ComponentBased Architecture is Your Best Fit.mp4 (66.83 MB)
MP4
15 - Include Cubes in Your Data Warehousing Environment.mp4 (14.97 MB)
MP4
16 - Include Operational Data Stores in Your Data Warehousing Environment.mp4 (23.26 MB)
MP4
17 - Explore the Role of the Staging Layer Inside a Data Warehouse.mp4 (31.42 MB)
MP4
18 - Compare the Two Types of Staging Layers.mp4 (48.43 MB)
MP4
19 - Summarize Data Warehousing Architecture.mp4 (5.59 MB)
MP4
20 - Introduction to ETL and Data Movement for Data Warehousing.mp4 (6.87 MB)
MP4
21 - Compare ETL to ELT.mp4 (49.88 MB)
MP4
22 - Design the Initial Load ETL.mp4 (19.26 MB)
MP4
23 - Compare Different Models for Incremental ETL.mp4 (21.66 MB)
MP4
24 - Explore the Role of Data Transformation.mp4 (63.87 MB)
MP4
25 - More Common Transformations Within ETL.mp4 (27.49 MB)
MP4
26 - Implement MixandMatch Incremental ETL.mp4 (21.08 MB)
MP4
27 - Summarize ETL Concepts and Models.mp4 (3.05 MB)
MP4
28 - Data Warehousing Structure Fundamentals.mp4 (8.99 MB)
MP4
29 - Deciding What Your Data Warehouse Will Be Used For.mp4 (11.01 MB)
MP4
30 - The Basic Principles of Dimensionality.mp4 (51.5 MB)
MP4
31 - Compare Facts Fact Tables Dimensions and Dimension Tables.mp4 (26.35 MB)
MP4
32 - Compare Different Forms of Additivity in Facts.mp4 (23.49 MB)
MP4
33 - Compare a Star Schema to a Snowflake Schema.mp4 (64.71 MB)
MP4
34 - Database Keys for Data Warehousing.mp4 (29.75 MB)
MP4
35 - Summarize Data Warehousing Structure.mp4 (6.8 MB)
MP4
36 - Introduction to Dimensional Modeling.mp4 (4.77 MB)
MP4
37 - Design Dimension Tables for Star Schemas and Snowflake Schemas.mp4 (63.91 MB)
MP4
38 - The Four Main Types of Data Warehousing Fact Tables.mp4 (14.31 MB)
MP4
39 - The Role of Transaction Fact Tables.mp4 (33.74 MB)
MP4
40 - The Rules Governing Facts and Transaction Fact Tables.mp4 (37.25 MB)
MP4
41 - Primary and Foreign Keys for Fact Tables.mp4 (40.83 MB)
MP4
42 - The Role of Periodic Snapshot Fact Tables.mp4 (39 MB)
MP4
43 - Periodic Snapshots and SemiAdditive Facts.mp4 (64.99 MB)
MP4
44 - The Role of Accumulating Snapshot Fact Tables.mp4 (47.44 MB)
MP4
45 - Accumulating Snapshot Fact Table Example.mp4 (35.77 MB)
MP4
46 - Why a Factless Fact Table isnt a Contradiction in Terms.mp4 (49.18 MB)
MP4
47 - Compare the Structure of Fact Tables in Star Schemas vs Snowflake Schemas.mp4 (21 MB)
MP4
48 - SQL for Dimension and Fact Tables.mp4 (40.53 MB)
MP4
49 - Summarize Fact and Dimension Tables.mp4 (5.65 MB)
MP4
50 - Introduction to Slowly Changing Dimensions.mp4 (4.23 MB)
MP4
51 - Slowly Changing Dimensions SCDs and Data Warehouse History.mp4 (21.94 MB)
MP4
52 - Design a Type 1 SCD.mp4 (17.24 MB)
MP4
53 - Design a Type 2 SCD.mp4 (40.19 MB)
MP4
54 - Maintain Correct Data Order with Type 2 SCDs.mp4 (59.43 MB)
MP4
55 - Design a Type 3 SCD.mp4 (23.57 MB)
MP4
56 - Summarize SCD concepts and implementations.mp4 (6.31 MB)
MP4
57 - Introduction to ETL Design.mp4 (6.7 MB)
MP4
58 - Build your ETL Design from your ETL Architecture.mp4 (29.23 MB)
MP4
59 - Dimension Table ETL.mp4 (21.21 MB)
MP4
60 - Process SCD Type 1 Changes to a Dimension Table.mp4 (32.58 MB)
MP4
61 - Process SCD Type 2 Changes to a Dimension Table.mp4 (16.68 MB)
MP4
62 - Design ETL for Fact Tables.mp4 (41.55 MB)
MP4
63 - Summarize ETL Design.mp4 (4.9 MB)
MP4
64 - Introduction to Data Warehousing Environments.mp4 (4.63 MB)
MP4
65 - Decide Between Cloud and OnPremises Settings for Your Data Warehouse.mp4 (20.12 MB)
MP4
66 - Architecture and Design Implications for Your Selected Platform.mp4 (29.39 MB)
MP4