|
|
1. Data Warehousing - a short introduction.mp4
|
MP4
|
16.5 MB
|
|
|
1. Data Warehousing - a short introduction.srt
|
SRT
|
4.2 KB
|
|
|
1. How to use github and the class resources.html
|
HTML
|
716.8 B
|
|
|
1. Instructors Introduction.mp4
|
MP4
|
19.5 MB
|
|
|
1. Instructors Introduction.srt
|
SRT
|
2 KB
|
|
|
1. Introduction - Maslow's Pyramid of Data.mp4
|
MP4
|
29.3 MB
|
|
|
1. Introduction - Maslow's Pyramid of Data.srt
|
SRT
|
3.7 KB
|
|
|
1. Learning Objectives - Analyses, Hook and Exposures.mp4
|
MP4
|
4.8 MB
|
|
|
1. Learning Objectives - Analyses, Hook and Exposures.srt
|
SRT
|
819.2 B
|
|
|
1. Learning Objectives - Documentation.mp4
|
MP4
|
3.5 MB
|
|
|
1. Learning Objectives - Documentation.srt
|
SRT
|
921.6 B
|
|
|
1. Learning Objectives - Macros, Custom Tests and Packages.mp4
|
MP4
|
2.9 MB
|
|
|
1. Learning Objectives - Macros, Custom Tests and Packages.srt
|
SRT
|
512 B
|
|
|
1. Learning Objectives - Materializations.mp4
|
MP4
|
4.1 MB
|
|
|
1. Learning Objectives - Materializations.srt
|
SRT
|
819.2 B
|
|
|
1. Learning Objectives - Models.mp4
|
MP4
|
4.8 MB
|
|
|
1. Learning Objectives - Models.srt
|
SRT
|
819.2 B
|
|
|
1. Learning Objectives - Seeds and Sources.mp4
|
MP4
|
1.9 MB
|
|
|
1. Learning Objectives - Seeds and Sources.srt
|
SRT
|
409.6 B
|
|
|
1. Learning Objectives - Snapshots.mp4
|
MP4
|
3.4 MB
|
|
|
1. Learning Objectives - Snapshots.srt
|
SRT
|
819.2 B
|
|
|
1. Learning objectives - Tests.mp4
|
MP4
|
2.1 MB
|
|
|
1. Learning objectives - Tests.srt
|
SRT
|
409.6 B
|
|
|
1. The Basics of Database Normalization.mp4
|
MP4
|
29.7 MB
|
|
|
1. The Basics of Database Normalization.srt
|
SRT
|
3.7 KB
|
|
|
1. The Basics of Slowly Changing Dimensions.mp4
|
MP4
|
13.9 MB
|
|
|
1. The Basics of Slowly Changing Dimensions.srt
|
SRT
|
1.6 KB
|
|
|
1. dbt Overview.mp4
|
MP4
|
41.4 MB
|
|
|
1. dbt Overview.srt
|
SRT
|
4.9 KB
|
|
|
1.1 Analyses-Hooks-Exposures.pdf
|
PDF
|
195 KB
|
|
|
1.1 The project's GitHub page.html
|
HTML
|
102.4 B
|
|
|
10. A note on the DEV schema.html
|
HTML
|
409.6 B
|
|
|
11. Datasets and Data Flow Overview.mp4
|
MP4
|
43.3 MB
|
|
|
11. Datasets and Data Flow Overview.srt
|
SRT
|
5.4 KB
|
|
|
2. Analyses.mp4
|
MP4
|
16.2 MB
|
|
|
2. Analyses.srt
|
SRT
|
2.8 KB
|
|
|
2. Documentation Overview.mp4
|
MP4
|
13.7 MB
|
|
|
2. Documentation Overview.srt
|
SRT
|
2.8 KB
|
|
|
2. External Tables and Cloud Data Warehouses.mp4
|
MP4
|
17.8 MB
|
|
|
2. External Tables and Cloud Data Warehouses.srt
|
SRT
|
2.3 KB
|
|
|
2. First Normal Form (1NF).mp4
|
MP4
|
41.9 MB
|
|
|
2. First Normal Form (1NF).srt
|
SRT
|
4.7 KB
|
|
|
2. Macros Overview.mp4
|
MP4
|
5.1 MB
|
|
|
2. Macros Overview.srt
|
SRT
|
819.2 B
|
|
|
2. Materializations Overview.mp4
|
MP4
|
32.8 MB
|
|
|
2. Materializations Overview.srt
|
SRT
|
4.7 KB
|
|
|
2. Models Overview.mp4
|
MP4
|
5.2 MB
|
|
|
2. Models Overview.srt
|
SRT
|
1 KB
|
|
|
2. Seeds and Sources Overview.mp4
|
MP4
|
5.2 MB
|
|
|
2. Seeds and Sources Overview.srt
|
SRT
|
1 KB
|
|
|
2. Snapshots Overview.mp4
|
MP4
|
18.4 MB
|
|
|
2. Snapshots Overview.srt
|
SRT
|
3.4 KB
|
|
|
2. Snowflake Registration.mp4
|
MP4
|
31.4 MB
|
|
|
2. Snowflake Registration.srt
|
SRT
|
3.3 KB
|
|
|
2. Tests Overview.mp4
|
MP4
|
13.1 MB
|
|
|
2. Tests Overview.srt
|
SRT
|
2.6 KB
|
|
|
2. The Data Maturity Model.mp4
|
MP4
|
33.7 MB
|
|
|
2. The Data Maturity Model.srt
|
SRT
|
4.9 KB
|
|
|
2. Type 0 - Retain Original.mp4
|
MP4
|
10.8 MB
|
|
|
2. Type 0 - Retain Original.srt
|
SRT
|
1.2 KB
|
|
|
2. Use-case and Input Data Model Overview.mp4
|
MP4
|
46.8 MB
|
|
|
2. Use-case and Input Data Model Overview.srt
|
SRT
|
6.2 KB
|
|
|
2. Welcome.mp4
|
MP4
|
16.6 MB
|
|
|
2. Welcome.srt
|
SRT
|
1.2 KB
|
|
|
3. Course Structure Overview.mp4
|
MP4
|
71.6 MB
|
|
|
3. Course Structure Overview.srt
|
SRT
|
4.2 KB
|
|
|
3. Creating a Snapshot.mp4
|
MP4
|
73.5 MB
|
|
|
3. Creating a Snapshot.srt
|
SRT
|
12.3 KB
|
|
|
3. Creating our First Macro.mp4
|
MP4
|
42.8 MB
|
|
|
3. Creating our First Macro.srt
|
SRT
|
7.2 KB
|
|
|
3. Data Lakes.mp4
|
MP4
|
12.8 MB
|
|
|
3. Data Lakes.srt
|
SRT
|
1.8 KB
|
|
|
3. ETL and ELT.mp4
|
MP4
|
30 MB
|
|
|
3. ETL and ELT.srt
|
SRT
|
4.2 KB
|
|
|
3. Generic Tests.mp4
|
MP4
|
60.6 MB
|
|
|
3. Generic Tests.srt
|
SRT
|
10.7 KB
|
|
|
3. Hooks.mp4
|
MP4
|
35 MB
|
|
|
3. Hooks.srt
|
SRT
|
5.1 KB
|
|
|
3. Importing Airbnb Data into Snowflake.mp4
|
MP4
|
29.3 MB
|
|
|
3. Importing Airbnb Data into Snowflake.srt
|
SRT
|
4.3 KB
|
|
|
3. Model Dependencies and dbt's ref tag.mp4
|
MP4
|
75.9 MB
|
|
|
3. Model Dependencies and dbt's ref tag.srt
|
SRT
|
10.9 KB
|
|
|
3. Second Normal Form (2NF).mp4
|
MP4
|
31.8 MB
|
|
|
3. Second Normal Form (2NF).srt
|
SRT
|
3.5 KB
|
|
|
3. Seeds.mp4
|
MP4
|
39.5 MB
|
|
|
3. Seeds.srt
|
SRT
|
5.5 KB
|
|
|
3. Theory CTE - Common Table Expressions.mp4
|
MP4
|
28.1 MB
|
|
|
3. Theory CTE - Common Table Expressions.srt
|
SRT
|
3.9 KB
|
|
|
3. Type 1 - Overwrite.mp4
|
MP4
|
16.5 MB
|
|
|
3. Type 1 - Overwrite.srt
|
SRT
|
2 KB
|
|
|
3. Writing and Exploring Basic Documentation.mp4
|
MP4
|
54.7 MB
|
|
|
3. Writing and Exploring Basic Documentation.srt
|
SRT
|
9.1 KB
|
|
|
3.1 Documentation.md.pdf
|
PDF
|
177.6 KB
|
|
|
3.1 Macros-CustomTests-Packages.md.pdf
|
PDF
|
168.7 KB
|
|
|
3.1 Materializations.md.pdf
|
PDF
|
227.4 KB
|
|
|
3.1 Snapshots.md.pdf
|
PDF
|
187.6 KB
|
|
|
3.1 Snowflake-Setup.md.pdf
|
PDF
|
211.9 KB
|
|
|
3.1 Tests.md.pdf
|
PDF
|
193.2 KB
|
|
|
3.1 seed_full_moon_dates.csv
|
CSV
|
2.9 KB
|
|
|
3.1 topdown_bottom_up_2).mp4
|
MP4
|
71.2 MB
|
|
|
3.2 Sources-and-Seeds.pdf
|
PDF
|
187.2 KB
|
|
|
4. Creating our first model Airbnb listings.mp4
|
MP4
|
76.5 MB
|
|
|
4. Creating our first model Airbnb listings.srt
|
SRT
|
12.4 KB
|
|
|
4. Data Lakehouse.mp4
|
MP4
|
9.8 MB
|
|
|
4. Data Lakehouse.srt
|
SRT
|
1.2 KB
|
|
|
4. Markdown-based Docs, Custom Overview Page and Assets.mp4
|
MP4
|
66.1 MB
|
|
|
4. Markdown-based Docs, Custom Overview Page and Assets.srt
|
SRT
|
9.9 KB
|
|
|
4. READ ME! A Note on dbt's Python version compatibility.html
|
HTML
|
1.3 KB
|
|
|
4. Setting up a BI Dashboard in Snowflake and Preset.mp4
|
MP4
|
44.5 MB
|
|
|
4. Setting up a BI Dashboard in Snowflake and Preset.srt
|
SRT
|
5.6 KB
|
|
|
4. Singular Tests.mp4
|
MP4
|
25.5 MB
|
|
|
4. Singular Tests.srt
|
SRT
|
3.2 KB
|
|
|
4. Snapshots Quiz.html
|
HTML
|
204.8 B
|
|
|
4. Sources.mp4
|
MP4
|
28.9 MB
|
|
|
4. Sources.srt
|
SRT
|
4.8 KB
|
|
|
4. Table type materialization & Project-level Materialization config.mp4
|
MP4
|
24.6 MB
|
|
|
4. Table type materialization & Project-level Materialization config.srt
|
SRT
|
3.9 KB
|
|
|
4. Third Normal Form (3NF).mp4
|
MP4
|
25.8 MB
|
|
|
4. Third Normal Form (3NF).srt
|
SRT
|
3 KB
|
|
|
4. Type 2 - Add New Row.mp4
|
MP4
|
20.7 MB
|
|
|
4. Type 2 - Add New Row.srt
|
SRT
|
2.8 KB
|
|
|
4. Writing Custom Generic Tests.mp4
|
MP4
|
20 MB
|
|
|
4. Writing Custom Generic Tests.srt
|
SRT
|
3.3 KB
|
|
|
4.1 Models.md.pdf
|
PDF
|
196.3 KB
|
|
|
4.1 input_schema.png
|
PNG
|
65.4 KB
|
|
|
5. Create your own singular test.html
|
HTML
|
204.8 B
|
|
|
5. Exposures.mp4
|
MP4
|
26.3 MB
|
|
|
5. Exposures.srt
|
SRT
|
4.3 KB
|
|
|
5. Incremental materialization.mp4
|
MP4
|
57.9 MB
|
|
|
5. Incremental materialization.srt
|
SRT
|
8.9 KB
|
|
|
5. Installing Third-Party Packages.mp4
|
MP4
|
49.6 MB
|
|
|
5. Installing Third-Party Packages.srt
|
SRT
|
7.5 KB
|
|
|
5. Models Quiz.html
|
HTML
|
204.8 B
|
|
|
5. Source Freshness.mp4
|
MP4
|
21.5 MB
|
|
|
5. Source Freshness.srt
|
SRT
|
3.4 KB
|
|
|
5. The Linage Graph (Data Flow DAG).mp4
|
MP4
|
41.4 MB
|
|
|
5. The Linage Graph (Data Flow DAG).srt
|
SRT
|
6.8 KB
|
|
|
5. Type 3 - Add New Attribute.mp4
|
MP4
|
20.2 MB
|
|
|
5. Type 3 - Add New Attribute.srt
|
SRT
|
3 KB
|
|
|
5. dbt setup - Mac.mp4
|
MP4
|
34.6 MB
|
|
|
5. dbt setup - Mac.srt
|
SRT
|
6.6 KB
|
|
|
5.1 dbt-installation-MAC.md.pdf
|
PDF
|
173.2 KB
|
|
|
6. Create the src_hosts model.html
|
HTML
|
204.8 B
|
|
|
6. Document the dim_hosts_cleansed table.html
|
HTML
|
204.8 B
|
|
|
6. Ephemeral materialization.mp4
|
MP4
|
76.1 MB
|
|
|
6. Ephemeral materialization.srt
|
SRT
|
11.6 KB
|
|
|
6. Hooks Quiz.html
|
HTML
|
204.8 B
|
|
|
6. Macros, Custom Tests and Packages Quiz.html
|
HTML
|
204.8 B
|
|
|
6. Tests Quiz.html
|
HTML
|
204.8 B
|
|
|
6. dbt setup - Windows.mp4
|
MP4
|
99.4 MB
|
|
|
6. dbt setup - Windows.srt
|
SRT
|
13.3 KB
|
|
|
7. Course Feedback.html
|
HTML
|
204.8 B
|
|
|
7. Creating a dbt project and connecting it to Snowflake.mp4
|
MP4
|
39.5 MB
|
|
|
7. Creating a dbt project and connecting it to Snowflake.srt
|
SRT
|
7.6 KB
|
|
|
7. Documentation quiz.html
|
HTML
|
204.8 B
|
|
|
7. Quiz - Materializations.html
|
HTML
|
204.8 B
|
|
|
8. Install dbt power tools into VSCode Setup (optional).mp4
|
MP4
|
19.9 MB
|
|
|
8. Install dbt power tools into VSCode Setup (optional).srt
|
SRT
|
2.9 KB
|
|
|
9. Overview of the dbt Project Structure.mp4
|
MP4
|
28.9 MB
|
|
|
9. Overview of the dbt Project Structure.srt
|
SRT
|
3.9 KB
|
|
|
Bonus Resources.txt
|
TXT
|
409.6 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
