[ FreeCourseWeb.com ] Udemy - Data Warehouse - The Ultimate Guide

File Name

Size

Get Bonus Downloads Here.url

183 B

~Get Your Files Here !/01 - Intro/001 Welcome!.mp4

39 MB

~Get Your Files Here !/01 - Intro/001 Welcome!_en.vtt

2.9 kB

~Get Your Files Here !/01 - Intro/002 How this course works.mp4

30 MB

~Get Your Files Here !/01 - Intro/002 How this course works_en.vtt

5.3 kB

~Get Your Files Here !/01 - Intro/003 What do you learn in this course.mp4

21 MB

~Get Your Files Here !/01 - Intro/003 What do you learn in this course_en.vtt

3.4 kB

~Get Your Files Here !/02 - Data Warehouse Basics/001 Why a data warehouse.mp4

30 MB

~Get Your Files Here !/02 - Data Warehouse Basics/001 Why a data warehouse_en.vtt

4.6 kB

~Get Your Files Here !/02 - Data Warehouse Basics/002 What is a data warehouse.mp4

26 MB

~Get Your Files Here !/02 - Data Warehouse Basics/002 What is a data warehouse_en.vtt

4.3 kB

~Get Your Files Here !/02 - Data Warehouse Basics/003 What is Business Intelligence.mp4

18 MB

~Get Your Files Here !/02 - Data Warehouse Basics/003 What is Business Intelligence_en.vtt

2.6 kB

~Get Your Files Here !/02 - Data Warehouse Basics/004 Data Lake or Data Warehouse.mp4

34 MB

~Get Your Files Here !/02 - Data Warehouse Basics/004 Data Lake or Data Warehouse_en.vtt

6.5 kB

~Get Your Files Here !/02 - Data Warehouse Basics/005 Demos & Hands-on.mp4

14 MB

~Get Your Files Here !/02 - Data Warehouse Basics/005 Demos & Hands-on_en.vtt

2.7 kB

~Get Your Files Here !/02 - Data Warehouse Basics/006 Setting up Pentaho (ETL tool).mp4

30 MB

~Get Your Files Here !/02 - Data Warehouse Basics/006 Setting up Pentaho (ETL tool)_en.vtt

4.2 kB

~Get Your Files Here !/02 - Data Warehouse Basics/007 Setting up PostgreSQL (Database system).mp4

39 MB

~Get Your Files Here !/02 - Data Warehouse Basics/007 Setting up PostgreSQL (Database system)_en.vtt

6.9 kB

~Get Your Files Here !/03 - Data Warehouse Architecture/001 3 Layers of a Data Warehouse.mp4

42 MB

~Get Your Files Here !/03 - Data Warehouse Architecture/001 3 Layers of a Data Warehouse_en.vtt

6.6 kB

~Get Your Files Here !/03 - Data Warehouse Architecture/002 Staging area.mp4

49 MB

~Get Your Files Here !/03 - Data Warehouse Architecture/002 Staging area_en.vtt

7.9 kB

~Get Your Files Here !/03 - Data Warehouse Architecture/003 Demo Setting up the staging area.mp4

22 MB

~Get Your Files Here !/03 - Data Warehouse Architecture/003 Demo Setting up the staging area_en.vtt

3.9 kB

~Get Your Files Here !/03 - Data Warehouse Architecture/004 Data Marts.mp4

40 MB

~Get Your Files Here !/03 - Data Warehouse Architecture/004 Data Marts_en.vtt

7.0 kB

~Get Your Files Here !/03 - Data Warehouse Architecture/005 Relational databases.mp4

38 MB

~Get Your Files Here !/03 - Data Warehouse Architecture/005 Relational databases_en.vtt

6.5 kB

~Get Your Files Here !/03 - Data Warehouse Architecture/006 In-Memory databases.mp4

37 MB

~Get Your Files Here !/03 - Data Warehouse Architecture/006 In-Memory databases_en.vtt

7.0 kB

~Get Your Files Here !/03 - Data Warehouse Architecture/007 Cubes.mp4

44 MB

~Get Your Files Here !/03 - Data Warehouse Architecture/007 Cubes_en.vtt

8.1 kB

~Get Your Files Here !/03 - Data Warehouse Architecture/008 Operational Data Storage.mp4

44 MB

~Get Your Files Here !/03 - Data Warehouse Architecture/008 Operational Data Storage_en.vtt

8.0 kB

~Get Your Files Here !/03 - Data Warehouse Architecture/009 Summary.mp4

28 MB

~Get Your Files Here !/03 - Data Warehouse Architecture/009 Summary_en.vtt

4.5 kB

~Get Your Files Here !/04 - Dimensional Modeling/001 What is dimensional modeling.mp4

19 MB

~Get Your Files Here !/04 - Dimensional Modeling/001 What is dimensional modeling_en.vtt

3.4 kB

~Get Your Files Here !/04 - Dimensional Modeling/002 Why dimensional modeling.mp4

29 MB

~Get Your Files Here !/04 - Dimensional Modeling/002 Why dimensional modeling_en.vtt

4.7 kB

~Get Your Files Here !/04 - Dimensional Modeling/003 Facts.mp4

28 MB

~Get Your Files Here !/04 - Dimensional Modeling/003 Facts_en.vtt

4.9 kB

~Get Your Files Here !/04 - Dimensional Modeling/004 Dimensions.mp4

25 MB

~Get Your Files Here !/04 - Dimensional Modeling/004 Dimensions_en.vtt

4.7 kB

~Get Your Files Here !/04 - Dimensional Modeling/005 Star schema.mp4

51 MB

~Get Your Files Here !/04 - Dimensional Modeling/005 Star schema_en.vtt

8.2 kB

~Get Your Files Here !/04 - Dimensional Modeling/006 Snowflake schema.mp4

34 MB

~Get Your Files Here !/04 - Dimensional Modeling/006 Snowflake schema_en.vtt

5.2 kB

~Get Your Files Here !/04 - Dimensional Modeling/007 Demo Product & Category dimension (snowflaked).mp4

73 MB

~Get Your Files Here !/04 - Dimensional Modeling/007 Demo Product & Category dimension (snowflaked)_en.vtt

11 kB

~Get Your Files Here !/05 - Facts/001 Additivity.mp4

62 MB

~Get Your Files Here !/05 - Facts/001 Additivity_en.vtt

8.6 kB

~Get Your Files Here !/05 - Facts/002 Nulls in facts.mp4

25 MB

~Get Your Files Here !/05 - Facts/002 Nulls in facts_en.vtt

4.1 kB

~Get Your Files Here !/05 - Facts/003 03-Year-to-Date-facts.mp4

8.6 MB

~Get Your Files Here !/05 - Facts/003 Year-to-Date facts.mp4

19 MB

~Get Your Files Here !/05 - Facts/003 Year-to-Date facts_en.vtt

3.7 kB

~Get Your Files Here !/05 - Facts/004 Types of fact tables.mp4

2.5 MB

~Get Your Files Here !/05 - Facts/004 Types of fact tables_en.vtt

575 B

~Get Your Files Here !/05 - Facts/005 Transactional fact tables.mp4

25 MB

~Get Your Files Here !/05 - Facts/005 Transactional fact tables_en.vtt

3.7 kB

~Get Your Files Here !/05 - Facts/006 Periodic fact tables.mp4

26 MB

~Get Your Files Here !/05 - Facts/006 Periodic fact tables_en.vtt

3.9 kB

~Get Your Files Here !/05 - Facts/007 Accumulating snapshots.mp4

31 MB

~Get Your Files Here !/05 - Facts/007 Accumulating snapshots_en.vtt

3.7 kB

~Get Your Files Here !/05 - Facts/008 Comparing fact table types.mp4

18 MB

~Get Your Files Here !/05 - Facts/008 Comparing fact table types_en.vtt

3.9 kB

~Get Your Files Here !/05 - Facts/009 Factless fact tables.mp4

25 MB

~Get Your Files Here !/05 - Facts/009 Factless fact tables_en.vtt

4.2 kB

~Get Your Files Here !/05 - Facts/010 Steps in designing fact tables.mp4

33 MB

~Get Your Files Here !/05 - Facts/010 Steps in designing fact tables_en.vtt

4.8 kB

~Get Your Files Here !/05 - Facts/011 Surrogate Keys.mp4

37 MB

~Get Your Files Here !/05 - Facts/011 Surrogate Keys_en.vtt

6.5 kB

~Get Your Files Here !/05 - Facts/012 Case Study The Project.mp4

31 MB

~Get Your Files Here !/05 - Facts/012 Case Study The Project_en.vtt

4.7 kB

~Get Your Files Here !/05 - Facts/013 Case Study Identify the business process.mp4

12 MB

~Get Your Files Here !/05 - Facts/013 Case Study Identify the business process_en.vtt

2.1 kB

~Get Your Files Here !/05 - Facts/014 Case Study Define the grain.mp4

24 MB

~Get Your Files Here !/05 - Facts/014 Case Study Define the grain_en.vtt

2.8 kB

~Get Your Files Here !/05 - Facts/015 Case Study Identify the dimensions.mp4

29 MB

~Get Your Files Here !/05 - Facts/015 Case Study Identify the dimensions_en.vtt

3.8 kB

~Get Your Files Here !/05 - Facts/016 Case Study Identify the facts.mp4

44 MB

~Get Your Files Here !/05 - Facts/016 Case Study Identify the facts_en.vtt

5.7 kB

~Get Your Files Here !/06 - Dimensions/001 Dimension tables.mp4

49 MB

~Get Your Files Here !/06 - Dimensions/001 Dimension tables_en.vtt

6.7 kB

~Get Your Files Here !/06 - Dimensions/002 Date dimensions.mp4

49 MB

~Get Your Files Here !/06 - Dimensions/002 Date dimensions_en.vtt

7.6 kB

~Get Your Files Here !/06 - Dimensions/003 Nulls in dimensions.mp4

38 MB

~Get Your Files Here !/06 - Dimensions/003 Nulls in dimensions_en.vtt

4.8 kB

~Get Your Files Here !/06 - Dimensions/004 Hierarchies in dimensions.mp4

34 MB

~Get Your Files Here !/06 - Dimensions/004 Hierarchies in dimensions_en.vtt

5.1 kB

~Get Your Files Here !/06 - Dimensions/005 Conformed dimensions.mp4

24 MB

~Get Your Files Here !/06 - Dimensions/005 Conformed dimensions_en.vtt

3.8 kB

~Get Your Files Here !/06 - Dimensions/006 Degenerate dimensions.mp4

24 MB

~Get Your Files Here !/06 - Dimensions/006 Degenerate dimensions_en.vtt

3.8 kB

~Get Your Files Here !/06 - Dimensions/007 Junk dimension.mp4

47 MB

~Get Your Files Here !/06 - Dimensions/007 Junk dimension_en.vtt

8.7 kB

~Get Your Files Here !/06 - Dimensions/008 Role-playing dimension.mp4

37 MB

~Get Your Files Here !/06 - Dimensions/008 Role-playing dimension_en.vtt

6.3 kB

~Get Your Files Here !/06 - Dimensions/009 Case Study Date dimension.mp4

44 MB

~Get Your Files Here !/06 - Dimensions/009 Case Study Date dimension_en.vtt

6.1 kB

~Get Your Files Here !/07 - Slowly Changing Dimensions/001 What are slowly changing dimensions.mp4

18 MB

~Get Your Files Here !/07 - Slowly Changing Dimensions/001 What are slowly changing dimensions_en.vtt

3.4 kB

~Get Your Files Here !/07 - Slowly Changing Dimensions/002 Type 0 - Original.mp4

10 MB

~Get Your Files Here !/07 - Slowly Changing Dimensions/002 Type 0 - Original_en.vtt

2.2 kB

~Get Your Files Here !/07 - Slowly Changing Dimensions/003 Type 1 - Overwrite.mp4

27 MB

~Get Your Files Here !/07 - Slowly Changing Dimensions/003 Type 1 - Overwrite_en.vtt

3.9 kB

~Get Your Files Here !/07 - Slowly Changing Dimensions/004 Type 2 - Additional row.mp4

41 MB

~Get Your Files Here !/07 - Slowly Changing Dimensions/004 Type 2 - Additional row_en.vtt

5.8 kB

~Get Your Files Here !/07 - Slowly Changing Dimensions/005 Administrating Type 2 dimensions.mp4

43 MB

~Get Your Files Here !/07 - Slowly Changing Dimensions/005 Administrating Type 2 dimensions_en.vtt

6.1 kB

~Get Your Files Here !/07 - Slowly Changing Dimensions/006 Mixing Type 1 & Type 2.mp4

16 MB

~Get Your Files Here !/07 - Slowly Changing Dimensions/006 Mixing Type 1 & Type 2_en.vtt

2.8 kB

~Get Your Files Here !/07 - Slowly Changing Dimensions/007 Type 3 - Additional attribute.mp4

44 MB

~Get Your Files Here !/07 - Slowly Changing Dimensions/007 Type 3 - Additional attribute_en.vtt

6.6 kB

~Get Your Files Here !/08 - ETL process/001 Understanding the ETL process.mp4

41 MB

~Get Your Files Here !/08 - ETL process/001 Understanding the ETL process_en.vtt

7.2 kB

~Get Your Files Here !/08 - ETL process/002 Extract.mp4

16 MB

~Get Your Files Here !/08 - ETL process/002 Extract_en.vtt

3.2 kB

~Get Your Files Here !/08 - ETL process/003 Initial Load.mp4

18 MB

~Get Your Files Here !/08 - ETL process/003 Initial Load_en.vtt

3.6 kB

~Get Your Files Here !/08 - ETL process/004 Delta Load.mp4

42 MB

~Get Your Files Here !/08 - ETL process/004 Delta Load_en.vtt

7.5 kB

~Get Your Files Here !/08 - ETL process/005 Load Workflow.mp4

27 MB

~Get Your Files Here !/08 - ETL process/005 Load Workflow_en.vtt

4.5 kB

~Get Your Files Here !/08 - ETL process/006 Demo Quick Intro to Pentaho.mp4

58 MB

~Get Your Files Here !/08 - ETL process/006 Demo Quick Intro to Pentaho_en.vtt

9.9 kB

~Get Your Files Here !/08 - ETL process/007 Demo Setting up tables in SQL.mp4

29 MB

~Get Your Files Here !/08 - ETL process/007 Demo Setting up tables in SQL_en.vtt

5.1 kB

~Get Your Files Here !/08 - ETL process/008 Demo Initial Load example.mp4

64 MB

~Get Your Files Here !/08 - ETL process/008 Demo Initial Load example_en.vtt

11 kB

~Get Your Files Here !/08 - ETL process/009 Demo Delta Load example.mp4

72 MB

~Get Your Files Here !/08 - ETL process/009 Demo Delta Load example_en.vtt

13 kB

~Get Your Files Here !/08 - ETL process/010 Transforming data.mp4

29 MB

~Get Your Files Here !/08 - ETL process/010 Transforming data_en.vtt

5.0 kB

~Get Your Files Here !/08 - ETL process/011 Basic Transformations.mp4

44 MB

~Get Your Files Here !/08 - ETL process/011 Basic Transformations_en.vtt

6.4 kB

~Get Your Files Here !/08 - ETL process/012 Advanced Transformations.mp4

56 MB

~Get Your Files Here !/08 - ETL process/012 Advanced Transformations_en.vtt

7.5 kB

~Get Your Files Here !/08 - ETL process/013 Demo Planning next steps.mp4

32 MB

~Get Your Files Here !/08 - ETL process/013 Demo Planning next steps_en.vtt

5.7 kB

~Get Your Files Here !/08 - ETL process/014 Demo Table setup & Complete Staging.mp4

55 MB

~Get Your Files Here !/08 - ETL process/014 Demo Table setup & Complete Staging_en.vtt

9.4 kB

~Get Your Files Here !/08 - ETL process/015 Demo Transform.mp4

50 MB

~Get Your Files Here !/08 - ETL process/015 Demo Transform_en.vtt

7.5 kB

~Get Your Files Here !/08 - ETL process/015 SQL-Transform.txt

399 B

~Get Your Files Here !/08 - ETL process/016 Demo Load & Validate results.mp4

40 MB

~Get Your Files Here !/08 - ETL process/016 Demo Load & Validate results_en.vtt

5.7 kB

~Get Your Files Here !/08 - ETL process/017 Scheduling jobs.mp4

32 MB

~Get Your Files Here !/08 - ETL process/017 Scheduling jobs_en.vtt

6.2 kB

~Get Your Files Here !/09 - ETL tools/001 ETL tools.mp4

26 MB

~Get Your Files Here !/09 - ETL tools/001 ETL tools_en.vtt

5.2 kB

~Get Your Files Here !/09 - ETL tools/002 Choosing the right ETL tool.mp4

30 MB

~Get Your Files Here !/09 - ETL tools/002 Choosing the right ETL tool_en.vtt

6.7 kB

~Get Your Files Here !/10 - Case Study Creating a Data Warehouse/001 Plan of attack.mp4

12 MB

~Get Your Files Here !/10 - Case Study Creating a Data Warehouse/001 Plan of attack_en.vtt

2.6 kB

~Get Your Files Here !/10 - Case Study Creating a Data Warehouse/002 Create-public-sales.txt

418 B

~Get Your Files Here !/10 - Case Study Creating a Data Warehouse/002 Fact-Sales-1.csv

305 kB

~Get Your Files Here !/10 - Case Study Creating a Data Warehouse/002 Source data & table design.mp4

74 MB

~Get Your Files Here !/10 - Case Study Creating a Data Warehouse/002 Source data & table design_en.vtt

10 kB

~Get Your Files Here !/10 - Case Study Creating a Data Warehouse/003 Setting up the tables in database.mp4

20 MB

~Get Your Files Here !/10 - Case Study Creating a Data Warehouse/003 Setting up the tables in database_en.vtt

3.3 kB

~Get Your Files Here !/10 - Case Study Creating a Data Warehouse/004 Staging Sales Fact.mp4

47 MB

~Get Your Files Here !/10 - Case Study Creating a Data Warehouse/004 Staging Sales Fact_en.vtt

8.3 kB

~Get Your Files Here !/10 - Case Study Creating a Data Warehouse/005 Staging job & fixing problems.mp4

50 MB

~Get Your Files Here !/10 - Case Study Creating a Data Warehouse/005 Staging job & fixing problems_en.vtt

7.3 kB

~Get Your Files Here !/10 - Case Study Creating a Data Warehouse/006 Load Payment Dimension.mp4

33 MB

~Get Your Files Here !/10 - Case Study Creating a Data Warehouse/006 Load Payment Dimension_en.vtt

6.2 kB

~Get Your Files Here !/10 - Case Study Creating a Data Warehouse/007 Transform & Load Sales Fact.mp4

72 MB

~Get Your Files Here !/10 - Case Study Creating a Data Warehouse/007 Transform & Load Sales Fact_en.vtt

10 kB

~Get Your Files Here !/10 - Case Study Creating a Data Warehouse/007 Transform-Fact-sales.txt

579 B

~Get Your Files Here !/10 - Case Study Creating a Data Warehouse/008 Transform & Load job.mp4

24 MB

~Get Your Files Here !/10 - Case Study Creating a Data Warehouse/008 Transform & Load job_en.vtt

3.2 kB

~Get Your Files Here !/10 - Case Study Creating a Data Warehouse/009 Fact-Sales-2.csv

2.8 kB

~Get Your Files Here !/10 - Case Study Creating a Data Warehouse/009 Final ETL job & Incremental Load.mp4

53 MB

~Get Your Files Here !/10 - Case Study Creating a Data Warehouse/009 Final ETL job & Incremental Load_en.vtt

6.5 kB

~Get Your Files Here !/11 - ETL vs. ELT/001 What is an ELT.mp4

36 MB

~Get Your Files Here !/11 - ETL vs. ELT/001 What is an ELT_en.vtt

5.0 kB

~Get Your Files Here !/11 - ETL vs. ELT/002 ETL vs. ETL.mp4

27 MB

~Get Your Files Here !/11 - ETL vs. ELT/002 ETL vs. ETL_en.vtt

4.8 kB

~Get Your Files Here !/12 - Using a Data Warehouse/001 What are the common use cases.mp4

23 MB

~Get Your Files Here !/12 - Using a Data Warehouse/001 What are the common use cases_en.vtt

4.2 kB

~Get Your Files Here !/12 - Using a Data Warehouse/002 Connecting the DWH to Power BI.mp4

63 MB

~Get Your Files Here !/12 - Using a Data Warehouse/002 Connecting the DWH to Power BI_en.vtt

11 kB

~Get Your Files Here !/13 - Optimizing a Data Warehouse/001 Using indexes.mp4

28 MB

~Get Your Files Here !/13 - Optimizing a Data Warehouse/001 Using indexes_en.vtt

5.2 kB

~Get Your Files Here !/13 - Optimizing a Data Warehouse/002 B-tree indexes.mp4

16 MB

~Get Your Files Here !/13 - Optimizing a Data Warehouse/002 B-tree indexes_en.vtt

2.7 kB

~Get Your Files Here !/13 - Optimizing a Data Warehouse/003 Bitmap indexes.mp4

22 MB

~Get Your Files Here !/13 - Optimizing a Data Warehouse/003 Bitmap indexes_en.vtt

3.7 kB

~Get Your Files Here !/13 - Optimizing a Data Warehouse/004 Guidelines for indexes.mp4

41 MB

~Get Your Files Here !/13 - Optimizing a Data Warehouse/004 Guidelines for indexes_en.vtt

7.9 kB

~Get Your Files Here !/13 - Optimizing a Data Warehouse/005 Demo Setting indexes.mp4

28 MB

~Get Your Files Here !/13 - Optimizing a Data Warehouse/005 Demo Setting indexes_en.vtt

4.1 kB

~Get Your Files Here !/14 - The Modern Data Warehouses/001 Cloud vs. on-premise.mp4

16 MB

~Get Your Files Here !/14 - The Modern Data Warehouses/001 Cloud vs. on-premise_en.vtt

3.0 kB

~Get Your Files Here !/14 - The Modern Data Warehouses/002 Benefits cloud vs on-premise.mp4

36 MB

~Get Your Files Here !/14 - The Modern Data Warehouses/002 Benefits cloud vs on-premise_en.vtt

6.3 kB

~Get Your Files Here !/14 - The Modern Data Warehouses/003 Massive parallel processing.mp4

37 MB

~Get Your Files Here !/14 - The Modern Data Warehouses/003 Massive parallel processing_en.vtt

5.6 kB

~Get Your Files Here !/14 - The Modern Data Warehouses/004 Columnar storage.mp4

30 MB

~Get Your Files Here !/14 - The Modern Data Warehouses/004 Columnar storage_en.vtt

4.4 kB

~Get Your Files Here !/15 - Bonus/001 Bonus lecture.html

2.7 kB

~Get Your Files Here !/Bonus Resources.txt

386 B