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

File Name

Size

0. Websites you may like/[CourseClub.Me].url

122 B

0. Websites you may like/[FreeCourseSite.com].url

127 B

0. Websites you may like/[GigaCourse.Com].url

49 B

1 - Intro/1 - Welcome English.srt

3.4 kB

1 - Intro/1 - Welcome.mp4

39 MB

1 - Intro/2 - How this course works English.srt

6.2 kB

1 - Intro/2 - How this course works.mp4

30 MB

1 - Intro/3 - What do you learn in this course English.srt

3.9 kB

1 - Intro/3 - What do you learn in this course.mp4

21 MB

1 - Intro/4 - Course slides.html

103 B

1 - Intro/4 - Course-slides-Data-Warehouse-The-Ultimate-Guide.pdf

5.6 MB

10 - Case Study Creating a Data Warehouse/0. Websites you may like/[CourseClub.Me].url

122 B

10 - Case Study Creating a Data Warehouse/0. Websites you may like/[FreeCourseSite.com].url

127 B

10 - Case Study Creating a Data Warehouse/0. Websites you may like/[GigaCourse.Com].url

49 B

10 - Case Study Creating a Data Warehouse/79 - Plan of attack English.srt

3.1 kB

10 - Case Study Creating a Data Warehouse/79 - Plan of attack.mp4

12 MB

10 - Case Study Creating a Data Warehouse/80 - Create-public-sales.txt

418 B

10 - Case Study Creating a Data Warehouse/80 - Fact-Sales-1.csv

320 kB

10 - Case Study Creating a Data Warehouse/80 - Source data & table design English.srt

12 kB

10 - Case Study Creating a Data Warehouse/80 - Source data & table design.mp4

74 MB

10 - Case Study Creating a Data Warehouse/81 - Create-dwh-tables.txt

1.1 kB

10 - Case Study Creating a Data Warehouse/81 - Setting up the tables in database English.srt

3.8 kB

10 - Case Study Creating a Data Warehouse/81 - Setting up the tables in database.mp4

20 MB

10 - Case Study Creating a Data Warehouse/82 - Staging Sales Fact English.srt

9.7 kB

10 - Case Study Creating a Data Warehouse/82 - Staging Sales Fact.mp4

47 MB

10 - Case Study Creating a Data Warehouse/83 - Staging job & fixing problems English.srt

8.7 kB

10 - Case Study Creating a Data Warehouse/83 - Staging job & fixing problems.mp4

50 MB

10 - Case Study Creating a Data Warehouse/84 - Load Payment Dimension English.srt

7.4 kB

10 - Case Study Creating a Data Warehouse/84 - Load Payment Dimension.mp4

33 MB

10 - Case Study Creating a Data Warehouse/85 - Transform & Load Sales Fact English.srt

12 kB

10 - Case Study Creating a Data Warehouse/85 - Transform & Load Sales Fact.mp4

72 MB

10 - Case Study Creating a Data Warehouse/85 - Transform-Fact-sales.txt

579 B

10 - Case Study Creating a Data Warehouse/86 - Transform & Load job English.srt

3.9 kB

10 - Case Study Creating a Data Warehouse/86 - Transform & Load job.mp4

24 MB

10 - Case Study Creating a Data Warehouse/87 - Fact-Sales-2.csv

2.8 kB

10 - Case Study Creating a Data Warehouse/87 - Final ETL job & Incremental Load English.srt

7.7 kB

10 - Case Study Creating a Data Warehouse/87 - Final ETL job & Incremental Load.mp4

53 MB

11 - ETL vs ELT/88 - What is an ELT English.srt

5.8 kB

11 - ETL vs ELT/88 - What is an ELT.mp4

36 MB

11 - ETL vs ELT/89 - ETL vs ETL English.srt

5.6 kB

11 - ETL vs ELT/89 - ETL vs ETL.mp4

27 MB

12 - Using a Data Warehouse/90 - What are the common use cases English.srt

4.8 kB

12 - Using a Data Warehouse/90 - What are the common use cases.mp4

23 MB

12 - Using a Data Warehouse/91 - Connecting the DWH to Power BI English.srt

12 kB

12 - Using a Data Warehouse/91 - Connecting the DWH to Power BI.mp4

63 MB

13 - Optimizing a Data Warehouse/92 - Using indexes English.srt

6.0 kB

13 - Optimizing a Data Warehouse/92 - Using indexes.mp4

28 MB

13 - Optimizing a Data Warehouse/93 - Btree indexes English.srt

3.1 kB

13 - Optimizing a Data Warehouse/93 - Btree indexes.mp4

16 MB

13 - Optimizing a Data Warehouse/94 - Bitmap indexes English.srt

4.3 kB

13 - Optimizing a Data Warehouse/94 - Bitmap indexes.mp4

22 MB

13 - Optimizing a Data Warehouse/95 - Guidelines for indexes English.srt

9.2 kB

13 - Optimizing a Data Warehouse/95 - Guidelines for indexes.mp4

41 MB

13 - Optimizing a Data Warehouse/96 - Demo Setting indexes English.srt

4.7 kB

13 - Optimizing a Data Warehouse/96 - Demo Setting indexes.mp4

28 MB

14 - The Modern Data Warehouses/100 - Columnar storage English.srt

5.1 kB

14 - The Modern Data Warehouses/100 - Columnar storage.mp4

30 MB

14 - The Modern Data Warehouses/97 - Cloud vs onpremise English.srt

3.5 kB

14 - The Modern Data Warehouses/97 - Cloud vs onpremise.mp4

16 MB

14 - The Modern Data Warehouses/98 - Benefits cloud vs onpremise English.srt

7.4 kB

14 - The Modern Data Warehouses/98 - Benefits cloud vs onpremise.mp4

36 MB

14 - The Modern Data Warehouses/99 - Massive parallel processing English.srt

6.5 kB

14 - The Modern Data Warehouses/99 - Massive parallel processing.mp4

37 MB

15 - Bonus/101 - Bonus lecture.html

3.1 kB

2 - Data Warehouse Basics/10 - Setting up Pentaho ETL tool English.srt

4.9 kB

2 - Data Warehouse Basics/10 - Setting up Pentaho ETL tool.mp4

30 MB

2 - Data Warehouse Basics/11 - Setting up PostgreSQL Database system English.srt

8.0 kB

2 - Data Warehouse Basics/11 - Setting up PostgreSQL Database system.mp4

39 MB

2 - Data Warehouse Basics/5 - Why a data warehouse English.srt

5.3 kB

2 - Data Warehouse Basics/5 - Why a data warehouse.mp4

30 MB

2 - Data Warehouse Basics/6 - What is a data warehouse English.srt

5.1 kB

2 - Data Warehouse Basics/6 - What is a data warehouse.mp4

26 MB

2 - Data Warehouse Basics/7 - What is Business Intelligence English.srt

3.0 kB

2 - Data Warehouse Basics/7 - What is Business Intelligence.mp4

18 MB

2 - Data Warehouse Basics/8 - Data Lake or Data Warehouse English.srt

7.6 kB

2 - Data Warehouse Basics/8 - Data Lake or Data Warehouse.mp4

34 MB

2 - Data Warehouse Basics/9 - Demos & Handson English.srt

3.2 kB

2 - Data Warehouse Basics/9 - Demos & Handson.mp4

14 MB

3 - Data Warehouse Architecture/12 - 3 Layers of a Data Warehouse English.srt

7.7 kB

3 - Data Warehouse Architecture/12 - 3 Layers of a Data Warehouse.mp4

42 MB

3 - Data Warehouse Architecture/13 - Staging area English.srt

9.2 kB

3 - Data Warehouse Architecture/13 - Staging area.mp4

49 MB

3 - Data Warehouse Architecture/14 - Demo Setting up the staging area English.srt

4.6 kB

3 - Data Warehouse Architecture/14 - Demo Setting up the staging area.mp4

22 MB

3 - Data Warehouse Architecture/15 - Data Marts English.srt

8.1 kB

3 - Data Warehouse Architecture/15 - Data Marts.mp4

40 MB

3 - Data Warehouse Architecture/16 - Relational databases English.srt

7.6 kB

3 - Data Warehouse Architecture/16 - Relational databases.mp4

38 MB

3 - Data Warehouse Architecture/17 - InMemory databases English.srt

8.1 kB

3 - Data Warehouse Architecture/17 - InMemory databases.mp4

37 MB

3 - Data Warehouse Architecture/18 - Cubes English.srt

9.4 kB

3 - Data Warehouse Architecture/18 - Cubes.mp4

44 MB

3 - Data Warehouse Architecture/19 - Operational Data Storage English.srt

9.3 kB

3 - Data Warehouse Architecture/19 - Operational Data Storage.mp4

44 MB

3 - Data Warehouse Architecture/20 - Summary English.srt

5.2 kB

3 - Data Warehouse Architecture/20 - Summary.mp4

28 MB

4 - Dimensional Modeling/21 - What is dimensional modeling English.srt

4.0 kB

4 - Dimensional Modeling/21 - What is dimensional modeling.mp4

19 MB

4 - Dimensional Modeling/22 - Why dimensional modeling English.srt

5.5 kB

4 - Dimensional Modeling/22 - Why dimensional modeling.mp4

29 MB

4 - Dimensional Modeling/23 - Facts English.srt

5.7 kB

4 - Dimensional Modeling/23 - Facts.mp4

28 MB

4 - Dimensional Modeling/24 - Dimensions English.srt

5.4 kB

4 - Dimensional Modeling/24 - Dimensions.mp4

25 MB

4 - Dimensional Modeling/25 - Star schema English.srt

9.6 kB

4 - Dimensional Modeling/25 - Star schema.mp4

51 MB

4 - Dimensional Modeling/26 - Snowflake schema English.srt

6.0 kB

4 - Dimensional Modeling/26 - Snowflake schema.mp4

34 MB

4 - Dimensional Modeling/27 - Demo Product & Category dimension snowflaked English.srt

13 kB

4 - Dimensional Modeling/27 - Demo Product & Category dimension snowflaked.mp4

73 MB

4 - Dimensional Modeling/27 - SQL-Script-DM-Example.txt

761 B

4 - Dimensional Modeling/27 - products.csv

57 kB

5 - Facts/28 - Additivity English.srt

10 kB

5 - Facts/28 - Additivity.mp4

62 MB

5 - Facts/29 - Nulls in facts English.srt

4.7 kB

5 - Facts/29 - Nulls in facts.mp4

25 MB

5 - Facts/30 - YeartoDate facts English.srt

4.3 kB

5 - Facts/30 - YeartoDate facts.mp4

19 MB

5 - Facts/31 - Types of fact tables English.srt

661 B

5 - Facts/31 - Types of fact tables.mp4

2.5 MB

5 - Facts/32 - Transactional fact tables English.srt

4.3 kB

5 - Facts/32 - Transactional fact tables.mp4

25 MB

5 - Facts/33 - Periodic fact tables English.srt

4.6 kB

5 - Facts/33 - Periodic fact tables.mp4

26 MB

5 - Facts/34 - Accumulating snapshots English.srt

4.3 kB

5 - Facts/34 - Accumulating snapshots.mp4

31 MB

5 - Facts/35 - Comparing fact table types English.srt

4.6 kB

5 - Facts/35 - Comparing fact table types.mp4

18 MB

5 - Facts/36 - Factless fact tables English.srt

4.8 kB

5 - Facts/36 - Factless fact tables.mp4

25 MB

5 - Facts/37 - Steps in designing fact tables English.srt

5.6 kB

5 - Facts/37 - Steps in designing fact tables.mp4

33 MB

5 - Facts/38 - Surrogate Keys English.srt

7.7 kB

5 - Facts/38 - Surrogate Keys.mp4

37 MB

5 - Facts/39 - Case Study The Project English.srt

5.4 kB

5 - Facts/39 - Case Study The Project.mp4

31 MB

5 - Facts/40 - Case Study Identify the business process English.srt

2.4 kB

5 - Facts/40 - Case Study Identify the business process.mp4

12 MB

5 - Facts/41 - Case Study Define the grain English.srt

3.3 kB

5 - Facts/41 - Case Study Define the grain.mp4

24 MB

5 - Facts/42 - Case Study Identify the dimensions English.srt

4.5 kB

5 - Facts/42 - Case Study Identify the dimensions.mp4

29 MB

5 - Facts/43 - Case Study Identify the facts English.srt

6.6 kB

5 - Facts/43 - Case Study Identify the facts.mp4

44 MB

6 - Dimensions/44 - Dimension tables English.srt

7.8 kB

6 - Dimensions/44 - Dimension tables.mp4

49 MB

6 - Dimensions/45 - Date dimensions English.srt

8.8 kB

6 - Dimensions/45 - Date dimensions.mp4

49 MB

6 - Dimensions/45 - Date-Table-SQL.txt

2.1 kB

6 - Dimensions/46 - Nulls in dimensions English.srt

5.6 kB

6 - Dimensions/46 - Nulls in dimensions.mp4

38 MB

6 - Dimensions/47 - Hierarchies in dimensions English.srt

6.0 kB

6 - Dimensions/47 - Hierarchies in dimensions.mp4

34 MB

6 - Dimensions/48 - Conformed dimensions English.srt

6.8 kB

6 - Dimensions/48 - Conformed dimensions.mp4

36 MB

6 - Dimensions/49 - Degenerate dimensions English.srt

4.4 kB

6 - Dimensions/49 - Degenerate dimensions.mp4

24 MB

6 - Dimensions/50 - Junk dimension English.srt

10 kB

6 - Dimensions/50 - Junk dimension.mp4

47 MB

6 - Dimensions/51 - Roleplaying dimension English.srt

7.4 kB

6 - Dimensions/51 - Roleplaying dimension.mp4

37 MB

6 - Dimensions/52 - Case Study Date dimension English.srt

7.1 kB

6 - Dimensions/52 - Case Study Date dimension.mp4

44 MB

7 - Slowly Changing Dimensions/53 - What are slowly changing dimensions English.srt

3.9 kB

7 - Slowly Changing Dimensions/53 - What are slowly changing dimensions.mp4

18 MB

7 - Slowly Changing Dimensions/54 - Type 0 Original English.srt

2.5 kB

7 - Slowly Changing Dimensions/54 - Type 0 Original.mp4

10 MB

7 - Slowly Changing Dimensions/55 - Type 1 Overwrite English.srt

4.5 kB

7 - Slowly Changing Dimensions/55 - Type 1 Overwrite.mp4

27 MB

7 - Slowly Changing Dimensions/56 - Type 2 Additional row English.srt

6.8 kB

7 - Slowly Changing Dimensions/56 - Type 2 Additional row.mp4

41 MB

7 - Slowly Changing Dimensions/57 - Administrating Type 2 dimensions English.srt

7.1 kB

7 - Slowly Changing Dimensions/57 - Administrating Type 2 dimensions.mp4

43 MB

7 - Slowly Changing Dimensions/58 - Mixing Type 1 & Type 2 English.srt

3.2 kB

7 - Slowly Changing Dimensions/58 - Mixing Type 1 & Type 2.mp4

16 MB

7 - Slowly Changing Dimensions/59 - Type 3 Additional attribute English.srt

7.6 kB

7 - Slowly Changing Dimensions/59 - Type 3 Additional attribute.mp4

44 MB

8 - ETL process/60 - Understanding the ETL process English.srt

8.4 kB

8 - ETL process/60 - Understanding the ETL process.mp4

41 MB

8 - ETL process/61 - Extract English.srt

3.7 kB

8 - ETL process/61 - Extract.mp4

16 MB

8 - ETL process/62 - Initial Load English.srt

4.2 kB

8 - ETL process/62 - Initial Load.mp4

18 MB

8 - ETL process/63 - Delta Load English.srt

8.7 kB

8 - ETL process/63 - Delta Load.mp4

42 MB

8 - ETL process/64 - Load Workflow English.srt

5.3 kB

8 - ETL process/64 - Load Workflow.mp4

27 MB

8 - ETL process/65 - Demo Quick Intro to Pentaho English.srt

12 kB

8 - ETL process/65 - Demo Quick Intro to Pentaho.mp4

58 MB

8 - ETL process/66 - Create-dwh-tables.txt

1.1 kB

8 - ETL process/66 - Demo Setting up tables in SQL English.srt

6.0 kB

8 - ETL process/66 - Demo Setting up tables in SQL.mp4

29 MB

8 - ETL process/67 - Demo Initial Load example English.srt

12 kB

8 - ETL process/67 - Demo Initial Load example.mp4

64 MB

8 - ETL process/68 - Demo Delta Load example English.srt

16 kB

8 - ETL process/68 - Demo Delta Load example.mp4

72 MB

8 - ETL process/69 - Transforming data English.srt

5.8 kB

8 - ETL process/69 - Transforming data.mp4

29 MB

8 - ETL process/70 - Basic Transformations English.srt

7.5 kB

8 - ETL process/70 - Basic Transformations.mp4

44 MB

8 - ETL process/71 - Advanced Transformations English.srt

8.8 kB

8 - ETL process/71 - Advanced Transformations.mp4

56 MB

8 - ETL process/72 - Demo Planning next steps English.srt

6.6 kB

8 - ETL process/72 - Demo Planning next steps.mp4

32 MB

8 - ETL process/73 - Demo Table setup & Complete Staging English.srt

11 kB

8 - ETL process/73 - Demo Table setup & Complete Staging.mp4

55 MB

8 - ETL process/74 - Demo Transform English.srt

8.9 kB

8 - ETL process/74 - Demo Transform.mp4

50 MB

8 - ETL process/74 - SQL-Transform.txt

399 B

8 - ETL process/75 - Demo Load & Validate results English.srt

6.8 kB

8 - ETL process/75 - Demo Load & Validate results.mp4

40 MB

8 - ETL process/76 - Scheduling jobs English.srt

7.3 kB

8 - ETL process/76 - Scheduling jobs.mp4

32 MB

9 - ETL tools/77 - ETL tools English.srt

6.1 kB

9 - ETL tools/77 - ETL tools.mp4

26 MB

9 - ETL tools/78 - Choosing the right ETL tool English.srt

7.9 kB

9 - ETL tools/78 - Choosing the right ETL tool.mp4

30 MB