Udemy - Data Warehouse - The Ultimate Guide

Files:

• [CourseClub.Me].url (0.1 KB)
• [FreeCourseSite.com].url (0.1 KB)
• [GigaCourse.Com].url (0.0 KB)

• 1 - Welcome English.srt (3.4 KB)
• 1 - Welcome.mp4 (39.3 MB)
• 2 - How this course works English.srt (6.2 KB)
• 2 - How this course works.mp4 (30.4 MB)
• 3 - What do you learn in this course English.srt (3.9 KB)
• 3 - What do you learn in this course.mp4 (21.1 MB)
• 4 - Course slides.html (0.1 KB)
• 4 - Course-slides-Data-Warehouse-The-Ultimate-Guide.pdf (5.6 MB)

• [CourseClub.Me].url (0.1 KB)
• [FreeCourseSite.com].url (0.1 KB)
• [GigaCourse.Com].url (0.0 KB)

• 79 - Plan of attack English.srt (3.1 KB)
• 79 - Plan of attack.mp4 (12.1 MB)
• 80 - Create-public-sales.txt (0.4 KB)
• 80 - Fact-Sales-1.csv (319.9 KB)
• 80 - Source data & table design English.srt (11.8 KB)
• 80 - Source data & table design.mp4 (74.3 MB)
• 81 - Create-dwh-tables.txt (1.1 KB)
• 81 - Setting up the tables in database English.srt (3.8 KB)
• 81 - Setting up the tables in database.mp4 (19.5 MB)
• 82 - Staging Sales Fact English.srt (9.7 KB)
• 82 - Staging Sales Fact.mp4 (47.0 MB)
• 83 - Staging job & fixing problems English.srt (8.7 KB)
• 83 - Staging job & fixing problems.mp4 (50.1 MB)
• 84 - Load Payment Dimension English.srt (7.4 KB)
• 84 - Load Payment Dimension.mp4 (33.3 MB)
• 85 - Transform & Load Sales Fact English.srt (11.8 KB)
• 85 - Transform & Load Sales Fact.mp4 (72.4 MB)
• 85 - Transform-Fact-sales.txt (0.6 KB)
• 86 - Transform & Load job English.srt (3.9 KB)
• 86 - Transform & Load job.mp4 (23.6 MB)
• 87 - Fact-Sales-2.csv (2.8 KB)
• 87 - Final ETL job & Incremental Load English.srt (7.7 KB)
• 87 - Final ETL job & Incremental Load.mp4 (53.0 MB)
11 - ETL vs ELT
• 88 - What is an ELT English.srt (5.8 KB)
• 88 - What is an ELT.mp4 (36.4 MB)
• 89 - ETL vs ETL English.srt (5.6 KB)
• 89 - ETL vs ETL.mp4 (27.1 MB)
12 - Using a Data Warehouse
• 90 - What are the common use cases English.srt (4.8 KB)
• 90 - What are the common use cases.mp4 (23.3 MB)
• 91 - Connecting the DWH to Power BI English.srt (12.5 KB)
• 91 - Connecting the DWH to Power BI.mp4 (62.6 MB)
13 - Optimizing a Data Warehouse
• 92 - Using indexes English.srt (6.0 KB)
• 92 - Using indexes.mp4 (28.5 MB)
• 93 - Btree indexes English.srt (3.1 KB)
• 93 - Btree indexes.mp4 (16.4 MB)
• 94 - Bitmap indexes English.srt (4.3 KB)
• 94 - Bitmap indexes.mp4 (22.5 MB)
• 95 - Guidelines for indexes English.srt (9.2 KB)
• 95 - Guidelines for indexes.mp4 (41.1 MB)
• 96 - Demo Setting indexes English.srt (4.7 KB)
• 96 - Demo Setting indexes.mp4 (28.2 MB)
14 - The Modern Data Warehouses
• 100 - Columnar storage English.srt (5.1 KB)
• 100 - Columnar storage.mp4 (29.5 MB)
• 97 - Cloud vs onpremise English.srt (3.5 KB)
• 97 - Cloud vs onpremise.mp4 (16.0 MB)
• 98 - Benefits cloud vs onpremise English.srt (7.4 KB)
• 98 - Benefits cloud vs onpremise.mp4 (35.5 MB)
• 99 - Massive parallel processing English.srt (6.5 KB)
• 99 - Massive parallel processing.mp4 (37.4 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)
• 10 - Setting up Pentaho ETL tool.mp4 (30.4 MB)
• 11 - Setting up PostgreSQL Database system English.srt (8.0 KB)
• 11 - Setting up PostgreSQL Database system.mp4 (39.2 MB)
• 5 - Why a data warehouse English.srt (5.3 KB)
• 5 - Why a data warehouse.mp4 (29.7 MB)
• 6 - What is a data warehouse English.srt (5.1 KB)
• 6 - What is a data warehouse.mp4 (25.8 MB)
• 7 - What is Business Intelligence English.srt (3.0 KB)
• 7 - What is Business Intelligence.mp4 (18.0 MB)
• 8 - Data Lake or Data Warehouse English.srt (7.6 KB)
• 8 - Data Lake or Data Warehouse.mp4 (34.3 MB)
• 9 - Demos & Handson English.srt (3.2 KB)
• 9 - Demos & Handson.mp4 (13.7 MB)
3 - Data Warehouse Architecture
• 12 - 3 Layers of a Data Warehouse English.srt (7.7 KB)
• 12 - 3 Layers of a Data Warehouse.mp4 (42.4 MB)
• 13 - Staging area English.srt (9.2 KB)
• 13 - Staging area.mp4 (49.0 MB)
• 14 - Demo Setting up the staging area English.srt (4.6 KB)
• 14 - Demo Setting up the staging area.mp4 (21.7 MB)
• 15 - Data Marts English.srt (8.1 KB)
• 15 - Data Marts.mp4 (40.1 MB)
• 16 - Relational databases English.srt (7.6 KB)
• 16 - Relational databases.mp4 (37.8 MB)
• 17 - InMemory databases English.srt (8.1 KB)
• 17 - InMemory databases.mp4 (37.2 MB)
• 18 - Cubes English.srt (9.4 KB)
• 18 - Cubes.mp4 (44.3 MB)
• 19 - Operational Data Storage English.srt (9.3 KB)
• 19 - Operational Data Storage.mp4 (44.1 MB)
• 20 - Summary English.srt (5.2 KB)
• 20 - Summary.mp4 (27.5 MB)
4 - Dimensional Modeling
• 21 - What is dimensional modeling English.srt (4.0 KB)
• 21 - What is dimensional modeling.mp4 (19.0 MB)
• 22 - Why dimensional modeling English.srt (5.5 KB)
• 22 - Why dimensional modeling.mp4 (28.8 MB)
• 23 - Facts English.srt (5.7 KB)
• 23 - Facts.mp4 (27.7 MB)
• 24 - Dimensions English.srt (5.4 KB)
• 24 - Dimensions.mp4 (25.1 MB)
• 25 - Star schema English.srt (9.6 KB)
• 25 - Star schema.mp4 (50.7 MB)
• 26 - Snowflake schema English.srt (6.0 KB)
• 26 - Snowflake schema.mp4 (33.7 MB)
• 27 - Demo Product & Category dimension snowflaked English.srt (12.8 KB)
• 27 - Demo Product & Category dimension snowflaked.mp4 (73.1 MB)
• 27 - SQL-Script-DM-Example.txt (0.7 KB)
• 27 - products.csv (57.1 KB)
5 - Facts
• 28 - Additivity English.srt (10.0 KB)
• 28 - Additivity.mp4 (62.5 MB)
• 29 - Nulls in facts English.srt (4.7 KB)
• 29 - Nulls in facts.mp4 (25.4 MB)
• 30 - YeartoDate facts English.srt (4.3 KB)
• 30 - YeartoDate facts.mp4 (19.0 MB)
• 31 - Types of fact tables English.srt (0.6 KB)
• 31 - Types of fact tables.mp4 (2.5 MB)
• 32 - Transactional fact tables English.srt (4.3 KB)
• 32 - Transactional fact tables.mp4 (25.2 MB)
• 33 - Periodic fact tables English.srt (4.6 KB)
• 33 - Periodic fact tables.mp4 (26.5 MB)
• 34 - Accumulating snapshots English.srt (4.3 KB)
• 34 - Accumulating snapshots.mp4 (30.9 MB)
• 35 - Comparing fact table types English.srt (4.6 KB)
• 35 - Comparing fact table types.mp4 (18.3 MB)
• 36 - Factless fact tables English.srt (4.8 KB)
• 36 - Factless fact tables.mp4 (24.8 MB)
• 37 - Steps in designing fact tables English.srt (5.6 KB)
• 37 - Steps in designing fact tables.mp4 (32.6 MB)
• 38 - Surrogate Keys English.srt (7.7 KB)
• 38 - Surrogate Keys.mp4 (37.2 MB)
• 39 - Case Study The Project English.srt (5.4 KB)
• 39 - Case Study The Project.mp4 (31.4 MB)
• 40 - Case Study Identify the business process English.srt (2.4 KB)
• 40 - Case Study Identify the business process.mp4 (11.9 MB)
• 41 - Case Study Define the grain English.srt (3.3 KB)
• 41 - Case Study Define the grain.mp4 (23.5 MB)
• 42 - Case Study Identify the dimensions English.srt (4.5 KB)
• 42 - Case Study Identify the dimensions.mp4 (28.8 MB)
• 43 - Case Study Identify the facts English.srt (6.6 KB)
• 43 - Case Study Identify the facts.mp4 (44.0 MB)
6 - Dimensions
• 44 - Dimension tables English.srt (7.8 KB)
• 44 - Dimension tables.mp4 (48.9 MB)
• 45 - Date dimensions English.srt (8.8 KB)
• 45 - Date dimensions.mp4 (49.4 MB)
• 45 - Date-Table-SQL.txt (2.1 KB)
• 46 - Nulls in dimensions English.srt (5.6 KB)
• 46 - Nulls in dimensions.mp4 (38.1 MB)
• 47 - Hierarchies in dimensions English.srt (6.0 KB)
• 47 - Hierarchies in dimensions.mp4 (34.1 MB)
• 48 - Conformed dimensions English.srt (6.8 KB)
• 48 - Conformed dimensions.mp4 (36.4 MB)
• 49 - Degenerate dimensions English.srt (4.4 KB)
• 49 - Degenerate dimensions.mp4 (24.2 MB)
• 50 - Junk dimension English.srt (10.1 KB)
• 50 - Junk dimension.mp4 (46.8 MB)
• 51 - Roleplaying dimension English.srt (7.4 KB)
• 51 - Roleplaying dimension.mp4 (36.6 MB)
• 52 - Case Study Date dimension English.srt (7.1 KB)
• 52 - Case Study Date dimension.mp4 (43.8 MB)
7 - Slowly Changing Dimensions
• 53 - What are slowly changing dimensions English.srt (3.9 KB)
• 53 - What are slowly changing dimensions.mp4 (17.8 MB)
• 54 - Type 0 Original English.srt (2.5 KB)
• 54 - Type 0 Original.mp4 (10.0 MB)
• 55 - Type 1 Overwrite English.srt (4.5 KB)
• 55 - Type 1 Overwrite.mp4 (27.3 MB)
• 56 - Type 2 Additional row English.srt (6.8 KB)
• 56 - Type 2 Additional row.mp4 (40.6 MB)
• 57 - Administrating Type 2 dimensions English.srt (7.1 KB)
• 57 - Administrating Type 2 dimensions.mp4 (43.2 MB)
• 58 - Mixing Type 1 & Type 2 English.srt (3.2 KB)
• 58 - Mixing Type 1 & Type 2.mp4 (15.9 MB)
• 59 - Type 3 Additional attribute English.srt (7.6 KB)
• 59 - Type 3 Additional attribute.mp4 (43.7 MB)
8 - ETL process
• 60 - Understanding the ETL process English.srt (8.4 KB)
• 60 - Understanding the ETL process.mp4 (40.7 MB)
• 61 - Extract English.srt (3.7 KB)
• 61 - Extract.mp4 (16.3 MB)
• 62 - Initial Load English.srt (4.2 KB)
• 62 - Initial Load.mp4 (17.6 MB)
• 63 - Delta Load English.srt (8.7 KB)
• 63 - Delta Load.mp4 (41.9 MB)
• 64 - Load Workflow English.srt (5.3 KB)
• 64 - Load Workflow.mp4 (26.9 MB)
• 65 - Demo Quick Intro to Pentaho English.srt (11.6 KB)
• 65 - Demo Quick Intro to Pentaho.mp4 (57.8 MB)
• 66 - Create-dwh-tables.txt (1.1 KB)
• 66 - Demo Setting up tables in SQL English.srt (6.0 KB)
• 66 - Demo Setting up tables in SQL.mp4 (29.1 MB)
• 67 - Demo Initial Load example English.srt (12.5 KB)
• 67 - Demo Initial Load example.mp4 (63.7 MB)
• 68 - Demo Delta Load example English.srt (15.5 KB)
• 68 - Demo Delta Load example.mp4 (71.8 MB)
• 69 - Transforming data English.srt (5.8 KB)
• 69 - Transforming data.mp4 (29.3 MB)
• 70 - Basic Transformations English.srt (7.5 KB)
• 70 - Basic Transformations.mp4 (43.6 MB)
• 71 - Advanced Transformations English.srt (8.8 KB)
• 71 - Advanced Transformations.mp4 (55.9 MB)
• 72 - Demo Planning next steps English.srt (6.6 KB)
• 72 - Demo Planning next steps.mp4 (32.2 MB)
• 73 - Demo Table setup & Complete Staging English.srt (11.1 KB)
• 73 - Demo Table setup & Complete Staging.mp4 (55.3 MB)
• 74 - Demo Transform English.srt (8.9 KB)
• 74 - Demo Transform.mp4 (49.9 MB)
• 74 - SQL-Transform.txt (0.4 KB)
• 75 - Demo Load & Validate results English.srt (6.8 KB)
• 75 - Demo Load & Validate results.mp4 (40.3 MB)
• 76 - Scheduling jobs English.srt (7.3 KB)
• 76 - Scheduling jobs.mp4 (31.8 MB)
9 - ETL tools
• 77 - ETL tools English.srt (6.1 KB)
• 77 - ETL tools.mp4 (25.5 MB)
• 78 - Choosing the right ETL tool English.srt (7.9 KB)
• 78 - Choosing the right ETL tool.mp4 (30.1 MB)