FreeCourseSite com Udemy Data Warehouse The Ultimate Guide | 33EA4D77C70CD95E004AFB3F6A47B992D4774938

FreeCourseSite com Udemy Data Warehouse The Ultimate Guide

Name	[FreeCourseSite.com] Udemy - Data Warehouse - The Ultimate Guide	DOWNLOAD Copy Link
Total Size	3.6 GB
Total Files	217
Last Seen	2024-07-08 23:37
Hash	33EA4D77C70CD95E004AFB3F6A47B992D4774938

/0. Websites you may like/
[CourseClub.Me].url	0.1 KB
[FreeCourseSite.com].url	0.1 KB
[GigaCourse.Com].url	0.0 KB
/1 - Intro/
1 - Welcome English.srt	3.5 KB
1 - Welcome.mp4	41.2 MB
2 - How this course works English.srt	6.3 KB
2 - How this course works.mp4	31.9 MB
3 - What do you learn in this course English.srt	4.0 KB
3 - What do you learn in this course.mp4	22.1 MB
4 - Course slides.html	0.1 KB
4 - Course-slides-Data-Warehouse-The-Ultimate-Guide.pdf	5.9 MB
/.../0. Websites you may like/
[CourseClub.Me].url	0.1 KB
[FreeCourseSite.com].url	0.1 KB
[GigaCourse.Com].url	0.0 KB
/10 - Case Study Creating a Data Warehouse/
79 - Plan of attack English.srt	3.1 KB
79 - Plan of attack.mp4	12.7 MB
80 - Create-public-sales.txt	0.4 KB
80 - Fact-Sales-1.csv	327.6 KB
80 - Source data & table design English.srt	12.1 KB
80 - Source data & table design.mp4	77.9 MB
81 - Create-dwh-tables.txt	1.1 KB
81 - Setting up the tables in database English.srt	3.9 KB
81 - Setting up the tables in database.mp4	20.4 MB
82 - Staging Sales Fact English.srt	10.0 KB
82 - Staging Sales Fact.mp4	49.3 MB
83 - Staging job & fixing problems English.srt	8.9 KB
83 - Staging job & fixing problems.mp4	52.6 MB
84 - Load Payment Dimension English.srt	7.6 KB
84 - Load Payment Dimension.mp4	34.9 MB
85 - Transform & Load Sales Fact English.srt	12.1 KB
85 - Transform & Load Sales Fact.mp4	76.0 MB
85 - Transform-Fact-sales.txt	0.6 KB
86 - Transform & Load job English.srt	4.0 KB
86 - Transform & Load job.mp4	24.7 MB
87 - Fact-Sales-2.csv	2.9 KB
87 - Final ETL job & Incremental Load English.srt	7.9 KB
87 - Final ETL job & Incremental Load.mp4	55.5 MB
/11 - ETL vs ELT/
88 - What is an ELT English.srt	6.0 KB
88 - What is an ELT.mp4	38.1 MB
89 - ETL vs ETL English.srt	5.7 KB
89 - ETL vs ETL.mp4	28.4 MB
/12 - Using a Data Warehouse/
90 - What are the common use cases English.srt	4.9 KB
90 - What are the common use cases.mp4	24.4 MB
91 - Connecting the DWH to Power BI English.srt	12.8 KB
91 - Connecting the DWH to Power BI.mp4	65.6 MB
/13 - Optimizing a Data Warehouse/
92 - Using indexes English.srt	6.2 KB
92 - Using indexes.mp4	29.9 MB
93 - Btree indexes English.srt	3.2 KB
93 - Btree indexes.mp4	17.2 MB
94 - Bitmap indexes English.srt	4.4 KB
94 - Bitmap indexes.mp4	23.6 MB
95 - Guidelines for indexes English.srt	9.4 KB
95 - Guidelines for indexes.mp4	43.1 MB
96 - Demo Setting indexes English.srt	4.9 KB
96 - Demo Setting indexes.mp4	29.6 MB
/14 - The Modern Data Warehouses/
100 - Columnar storage English.srt	5.3 KB
100 - Columnar storage.mp4	31.0 MB
97 - Cloud vs onpremise English.srt	3.6 KB
97 - Cloud vs onpremise.mp4	16.8 MB
98 - Benefits cloud vs onpremise English.srt	7.6 KB
98 - Benefits cloud vs onpremise.mp4	37.2 MB
99 - Massive parallel processing English.srt	6.7 KB
99 - Massive parallel processing.mp4	39.2 MB
/15 - Bonus/
101 - Bonus lecture.html	3.2 KB
/2 - Data Warehouse Basics/
10 - Setting up Pentaho ETL tool English.srt	5.1 KB
10 - Setting up Pentaho ETL tool.mp4	31.9 MB
11 - Setting up PostgreSQL Database system English.srt	8.2 KB
11 - Setting up PostgreSQL Database system.mp4	41.1 MB
5 - Why a data warehouse English.srt	5.4 KB
5 - Why a data warehouse.mp4	31.1 MB
6 - What is a data warehouse English.srt	5.2 KB
6 - What is a data warehouse.mp4	27.0 MB
7 - What is Business Intelligence English.srt	3.0 KB
7 - What is Business Intelligence.mp4	18.9 MB
8 - Data Lake or Data Warehouse English.srt	7.8 KB
8 - Data Lake or Data Warehouse.mp4	35.9 MB
9 - Demos & Handson English.srt	3.3 KB
9 - Demos & Handson.mp4	14.3 MB
/3 - Data Warehouse Architecture/
12 - 3 Layers of a Data Warehouse English.srt	7.9 KB
12 - 3 Layers of a Data Warehouse.mp4	44.5 MB
13 - Staging area English.srt	9.5 KB
13 - Staging area.mp4	51.3 MB
14 - Demo Setting up the staging area English.srt	4.7 KB
14 - Demo Setting up the staging area.mp4	22.8 MB
15 - Data Marts English.srt	8.3 KB
15 - Data Marts.mp4	42.1 MB
16 - Relational databases English.srt	7.8 KB
16 - Relational databases.mp4	39.7 MB
17 - InMemory databases English.srt	8.3 KB
17 - InMemory databases.mp4	39.0 MB
18 - Cubes English.srt	9.7 KB
18 - Cubes.mp4	46.5 MB
19 - Operational Data Storage English.srt	9.6 KB
19 - Operational Data Storage.mp4	46.3 MB
20 - Summary English.srt	5.4 KB
20 - Summary.mp4	28.8 MB
/4 - Dimensional Modeling/
21 - What is dimensional modeling English.srt	4.1 KB
21 - What is dimensional modeling.mp4	19.9 MB
22 - Why dimensional modeling English.srt	5.6 KB
22 - Why dimensional modeling.mp4	30.2 MB
23 - Facts English.srt	5.9 KB
23 - Facts.mp4	29.1 MB
24 - Dimensions English.srt	5.6 KB
24 - Dimensions.mp4	26.4 MB
25 - Star schema English.srt	9.8 KB
25 - Star schema.mp4	53.1 MB
26 - Snowflake schema English.srt	6.1 KB
26 - Snowflake schema.mp4	35.4 MB
27 - Demo Product & Category dimension snowflaked English.srt	13.1 KB
27 - Demo Product & Category dimension snowflaked.mp4	76.7 MB
27 - SQL-Script-DM-Example.txt	0.8 KB
27 - products.csv	58.4 KB
/5 - Facts/
28 - Additivity English.srt	10.2 KB
28 - Additivity.mp4	65.6 MB
29 - Nulls in facts English.srt	4.8 KB
29 - Nulls in facts.mp4	26.6 MB
30 - YeartoDate facts English.srt	4.4 KB
30 - YeartoDate facts.mp4	19.9 MB
31 - Types of fact tables English.srt	0.7 KB
31 - Types of fact tables.mp4	2.6 MB
32 - Transactional fact tables English.srt	4.4 KB
32 - Transactional fact tables.mp4	26.4 MB
33 - Periodic fact tables English.srt	4.7 KB
33 - Periodic fact tables.mp4	27.8 MB
34 - Accumulating snapshots English.srt	4.4 KB
34 - Accumulating snapshots.mp4	32.3 MB
35 - Comparing fact table types English.srt	4.7 KB
35 - Comparing fact table types.mp4	19.2 MB
36 - Factless fact tables English.srt	5.0 KB
36 - Factless fact tables.mp4	26.0 MB
37 - Steps in designing fact tables English.srt	5.8 KB
37 - Steps in designing fact tables.mp4	34.2 MB
38 - Surrogate Keys English.srt	7.9 KB
38 - Surrogate Keys.mp4	39.0 MB
39 - Case Study The Project English.srt	5.6 KB
39 - Case Study The Project.mp4	33.0 MB
40 - Case Study Identify the business process English.srt	2.5 KB
40 - Case Study Identify the business process.mp4	12.4 MB
41 - Case Study Define the grain English.srt	3.4 KB
41 - Case Study Define the grain.mp4	24.7 MB
42 - Case Study Identify the dimensions English.srt	4.7 KB
42 - Case Study Identify the dimensions.mp4	30.2 MB
43 - Case Study Identify the facts English.srt	6.7 KB
43 - Case Study Identify the facts.mp4	46.1 MB
/6 - Dimensions/
44 - Dimension tables English.srt	8.0 KB
44 - Dimension tables.mp4	51.2 MB
45 - Date dimensions English.srt	9.0 KB
45 - Date dimensions.mp4	51.8 MB
45 - Date-Table-SQL.txt	2.1 KB
46 - Nulls in dimensions English.srt	5.7 KB
46 - Nulls in dimensions.mp4	39.9 MB
47 - Hierarchies in dimensions English.srt	6.1 KB
47 - Hierarchies in dimensions.mp4	35.8 MB
48 - Conformed dimensions English.srt	7.0 KB
48 - Conformed dimensions.mp4	38.1 MB
49 - Degenerate dimensions English.srt	4.5 KB
49 - Degenerate dimensions.mp4	25.4 MB
50 - Junk dimension English.srt	10.4 KB
50 - Junk dimension.mp4	49.1 MB
51 - Roleplaying dimension English.srt	7.5 KB
51 - Roleplaying dimension.mp4	38.4 MB
52 - Case Study Date dimension English.srt	7.3 KB
52 - Case Study Date dimension.mp4	46.0 MB
/7 - Slowly Changing Dimensions/
53 - What are slowly changing dimensions English.srt	4.0 KB
53 - What are slowly changing dimensions.mp4	18.7 MB
54 - Type 0 Original English.srt	2.6 KB
54 - Type 0 Original.mp4	10.5 MB
55 - Type 1 Overwrite English.srt	4.6 KB
55 - Type 1 Overwrite.mp4	28.6 MB
56 - Type 2 Additional row English.srt	6.9 KB
56 - Type 2 Additional row.mp4	42.6 MB
57 - Administrating Type 2 dimensions English.srt	7.2 KB
57 - Administrating Type 2 dimensions.mp4	45.3 MB
58 - Mixing Type 1 & Type 2 English.srt	3.3 KB
58 - Mixing Type 1 & Type 2.mp4	16.7 MB
59 - Type 3 Additional attribute English.srt	7.8 KB
59 - Type 3 Additional attribute.mp4	45.8 MB
/8 - ETL process/
60 - Understanding the ETL process English.srt	8.6 KB
60 - Understanding the ETL process.mp4	42.6 MB
61 - Extract English.srt	3.8 KB
61 - Extract.mp4	17.1 MB
62 - Initial Load English.srt	4.3 KB
62 - Initial Load.mp4	18.4 MB
63 - Delta Load English.srt	9.0 KB
63 - Delta Load.mp4	43.9 MB
64 - Load Workflow English.srt	5.4 KB
64 - Load Workflow.mp4	28.2 MB
65 - Demo Quick Intro to Pentaho English.srt	11.9 KB
65 - Demo Quick Intro to Pentaho.mp4	60.7 MB
66 - Create-dwh-tables.txt	1.1 KB
66 - Demo Setting up tables in SQL English.srt	6.2 KB
66 - Demo Setting up tables in SQL.mp4	30.5 MB
67 - Demo Initial Load example English.srt	12.8 KB
67 - Demo Initial Load example.mp4	66.8 MB
68 - Demo Delta Load example English.srt	15.9 KB
68 - Demo Delta Load example.mp4	75.3 MB
69 - Transforming data English.srt	5.9 KB
69 - Transforming data.mp4	30.7 MB
70 - Basic Transformations English.srt	7.7 KB
70 - Basic Transformations.mp4	45.8 MB
71 - Advanced Transformations English.srt	9.0 KB
71 - Advanced Transformations.mp4	58.7 MB
72 - Demo Planning next steps English.srt	6.8 KB
72 - Demo Planning next steps.mp4	33.8 MB
73 - Demo Table setup & Complete Staging English.srt	11.3 KB
73 - Demo Table setup & Complete Staging.mp4	57.9 MB
74 - Demo Transform English.srt	9.1 KB
74 - Demo Transform.mp4	52.4 MB
74 - SQL-Transform.txt	0.4 KB
75 - Demo Load & Validate results English.srt	6.9 KB
75 - Demo Load & Validate results.mp4	42.2 MB
76 - Scheduling jobs English.srt	7.5 KB
76 - Scheduling jobs.mp4	33.4 MB
/9 - ETL tools/
77 - ETL tools English.srt	6.2 KB
77 - ETL tools.mp4	26.7 MB
78 - Choosing the right ETL tool English.srt	8.1 KB
78 - Choosing the right ETL tool.mp4	31.5 MB
Total files 217