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