| 1. Data Warehousing - a short introduction.mp4 | 16.5 MB | ||
| 1. Data Warehousing - a short introduction.srt | 4.2 KB | ||
| 1. How to use github and the class resources.html | 716.8 B | ||
| 1. Instructors Introduction.mp4 | 19.5 MB | ||
| 1. Instructors Introduction.srt | 2 KB | ||
| 1. Introduction - Maslow's Pyramid of Data.mp4 | 29.3 MB | ||
| 1. Introduction - Maslow's Pyramid of Data.srt | 3.7 KB | ||
| 1. Learning Objectives - Analyses, Hook and Exposures.mp4 | 4.8 MB | ||
| 1. Learning Objectives - Analyses, Hook and Exposures.srt | 819.2 B | ||
| 1. Learning Objectives - Documentation.mp4 | 3.5 MB | ||
| 1. Learning Objectives - Documentation.srt | 921.6 B | ||
| 1. Learning Objectives - Macros, Custom Tests and Packages.mp4 | 2.9 MB | ||
| 1. Learning Objectives - Macros, Custom Tests and Packages.srt | 512 B | ||
| 1. Learning Objectives - Materializations.mp4 | 4.1 MB | ||
| 1. Learning Objectives - Materializations.srt | 819.2 B | ||
| 1. Learning Objectives - Models.mp4 | 4.8 MB | ||
| 1. Learning Objectives - Models.srt | 819.2 B | ||
| 1. Learning Objectives - Seeds and Sources.mp4 | 1.9 MB | ||
| 1. Learning Objectives - Seeds and Sources.srt | 409.6 B | ||
| 1. Learning Objectives - Snapshots.mp4 | 3.4 MB | ||
| 1. Learning Objectives - Snapshots.srt | 819.2 B | ||
| 1. Learning objectives - Tests.mp4 | 2.1 MB | ||
| 1. Learning objectives - Tests.srt | 409.6 B | ||
| 1. The Basics of Database Normalization.mp4 | 29.7 MB | ||
| 1. The Basics of Database Normalization.srt | 3.7 KB | ||
| 1. The Basics of Slowly Changing Dimensions.mp4 | 13.9 MB | ||
| 1. The Basics of Slowly Changing Dimensions.srt | 1.6 KB | ||
| 1. dbt Overview.mp4 | 41.4 MB | ||
| 1. dbt Overview.srt | 4.9 KB | ||
| 1.1 Analyses-Hooks-Exposures.pdf | 195 KB | ||
| 1.1 The project's GitHub page.html | 102.4 B | ||
| 10. A note on the DEV schema.html | 409.6 B | ||
| 11. Datasets and Data Flow Overview.mp4 | 43.3 MB | ||
| 11. Datasets and Data Flow Overview.srt | 5.4 KB | ||
| 2. Analyses.mp4 | 16.2 MB | ||
| 2. Analyses.srt | 2.8 KB | ||
| 2. Documentation Overview.mp4 | 13.7 MB | ||
| 2. Documentation Overview.srt | 2.8 KB | ||
| 2. External Tables and Cloud Data Warehouses.mp4 | 17.8 MB | ||
| 2. External Tables and Cloud Data Warehouses.srt | 2.3 KB | ||
| 2. First Normal Form (1NF).mp4 | 41.9 MB | ||
| 2. First Normal Form (1NF).srt | 4.7 KB | ||
| 2. Macros Overview.mp4 | 5.1 MB | ||
| 2. Macros Overview.srt | 819.2 B | ||
| 2. Materializations Overview.mp4 | 32.8 MB | ||
| 2. Materializations Overview.srt | 4.7 KB | ||
| 2. Models Overview.mp4 | 5.2 MB | ||
| 2. Models Overview.srt | 1 KB | ||
| 2. Seeds and Sources Overview.mp4 | 5.2 MB | ||
| 2. Seeds and Sources Overview.srt | 1 KB | ||
| 2. Snapshots Overview.mp4 | 18.4 MB | ||
| 2. Snapshots Overview.srt | 3.4 KB | ||
| 2. Snowflake Registration.mp4 | 31.4 MB | ||
| 2. Snowflake Registration.srt | 3.3 KB | ||
| 2. Tests Overview.mp4 | 13.1 MB | ||
| 2. Tests Overview.srt | 2.6 KB | ||
| 2. The Data Maturity Model.mp4 | 33.7 MB | ||
| 2. The Data Maturity Model.srt | 4.9 KB | ||
| 2. Type 0 - Retain Original.mp4 | 10.8 MB | ||
| 2. Type 0 - Retain Original.srt | 1.2 KB | ||
| 2. Use-case and Input Data Model Overview.mp4 | 46.8 MB | ||
| 2. Use-case and Input Data Model Overview.srt | 6.2 KB | ||
| 2. Welcome.mp4 | 16.6 MB | ||
| 2. Welcome.srt | 1.2 KB | ||
| 3. Course Structure Overview.mp4 | 71.6 MB | ||
| 3. Course Structure Overview.srt | 4.2 KB | ||
| 3. Creating a Snapshot.mp4 | 73.5 MB | ||
| 3. Creating a Snapshot.srt | 12.3 KB | ||
| 3. Creating our First Macro.mp4 | 42.8 MB | ||
| 3. Creating our First Macro.srt | 7.2 KB | ||
| 3. Data Lakes.mp4 | 12.8 MB | ||
| 3. Data Lakes.srt | 1.8 KB | ||
| 3. ETL and ELT.mp4 | 30 MB | ||
| 3. ETL and ELT.srt | 4.2 KB | ||
| 3. Generic Tests.mp4 | 60.6 MB | ||
| 3. Generic Tests.srt | 10.7 KB | ||
| 3. Hooks.mp4 | 35 MB | ||
| 3. Hooks.srt | 5.1 KB | ||
| 3. Importing Airbnb Data into Snowflake.mp4 | 29.3 MB | ||
| 3. Importing Airbnb Data into Snowflake.srt | 4.3 KB | ||
| 3. Model Dependencies and dbt's ref tag.mp4 | 75.9 MB | ||
| 3. Model Dependencies and dbt's ref tag.srt | 10.9 KB | ||
| 3. Second Normal Form (2NF).mp4 | 31.8 MB | ||
| 3. Second Normal Form (2NF).srt | 3.5 KB | ||
| 3. Seeds.mp4 | 39.5 MB | ||
| 3. Seeds.srt | 5.5 KB | ||
| 3. Theory CTE - Common Table Expressions.mp4 | 28.1 MB | ||
| 3. Theory CTE - Common Table Expressions.srt | 3.9 KB | ||
| 3. Type 1 - Overwrite.mp4 | 16.5 MB | ||
| 3. Type 1 - Overwrite.srt | 2 KB | ||
| 3. Writing and Exploring Basic Documentation.mp4 | 54.7 MB | ||
| 3. Writing and Exploring Basic Documentation.srt | 9.1 KB | ||
| 3.1 Documentation.md.pdf | 177.6 KB | ||
| 3.1 Macros-CustomTests-Packages.md.pdf | 168.7 KB | ||
| 3.1 Materializations.md.pdf | 227.4 KB | ||
| 3.1 Snapshots.md.pdf | 187.6 KB | ||
| 3.1 Snowflake-Setup.md.pdf | 211.9 KB | ||
| 3.1 Tests.md.pdf | 193.2 KB | ||
| 3.1 seed_full_moon_dates.csv | 2.9 KB | ||
| 3.1 topdown_bottom_up_2).mp4 | 71.2 MB | ||
| 3.2 Sources-and-Seeds.pdf | 187.2 KB | ||
| 4. Creating our first model Airbnb listings.mp4 | 76.5 MB | ||
| 4. Creating our first model Airbnb listings.srt | 12.4 KB | ||
| 4. Data Lakehouse.mp4 | 9.8 MB | ||
| 4. Data Lakehouse.srt | 1.2 KB | ||
| 4. Markdown-based Docs, Custom Overview Page and Assets.mp4 | 66.1 MB | ||
| 4. Markdown-based Docs, Custom Overview Page and Assets.srt | 9.9 KB | ||
| 4. READ ME! A Note on dbt's Python version compatibility.html | 1.3 KB | ||
| 4. Setting up a BI Dashboard in Snowflake and Preset.mp4 | 44.5 MB | ||
| 4. Setting up a BI Dashboard in Snowflake and Preset.srt | 5.6 KB | ||
| 4. Singular Tests.mp4 | 25.5 MB | ||
| 4. Singular Tests.srt | 3.2 KB | ||
| 4. Snapshots Quiz.html | 204.8 B | ||
| 4. Sources.mp4 | 28.9 MB | ||
| 4. Sources.srt | 4.8 KB | ||
| 4. Table type materialization & Project-level Materialization config.mp4 | 24.6 MB | ||
| 4. Table type materialization & Project-level Materialization config.srt | 3.9 KB | ||
| 4. Third Normal Form (3NF).mp4 | 25.8 MB | ||
| 4. Third Normal Form (3NF).srt | 3 KB | ||
| 4. Type 2 - Add New Row.mp4 | 20.7 MB | ||
| 4. Type 2 - Add New Row.srt | 2.8 KB | ||
| 4. Writing Custom Generic Tests.mp4 | 20 MB | ||
| 4. Writing Custom Generic Tests.srt | 3.3 KB | ||
| 4.1 Models.md.pdf | 196.3 KB | ||
| 4.1 input_schema.png | 65.4 KB | ||
| 5. Create your own singular test.html | 204.8 B | ||
| 5. Exposures.mp4 | 26.3 MB | ||
| 5. Exposures.srt | 4.3 KB | ||
| 5. Incremental materialization.mp4 | 57.9 MB | ||
| 5. Incremental materialization.srt | 8.9 KB | ||
| 5. Installing Third-Party Packages.mp4 | 49.6 MB | ||
| 5. Installing Third-Party Packages.srt | 7.5 KB | ||
| 5. Models Quiz.html | 204.8 B | ||
| 5. Source Freshness.mp4 | 21.5 MB | ||
| 5. Source Freshness.srt | 3.4 KB | ||
| 5. The Linage Graph (Data Flow DAG).mp4 | 41.4 MB | ||
| 5. The Linage Graph (Data Flow DAG).srt | 6.8 KB | ||
| 5. Type 3 - Add New Attribute.mp4 | 20.2 MB | ||
| 5. Type 3 - Add New Attribute.srt | 3 KB | ||
| 5. dbt setup - Mac.mp4 | 34.6 MB | ||
| 5. dbt setup - Mac.srt | 6.6 KB | ||
| 5.1 dbt-installation-MAC.md.pdf | 173.2 KB | ||
| 6. Create the src_hosts model.html | 204.8 B | ||
| 6. Document the dim_hosts_cleansed table.html | 204.8 B | ||
| 6. Ephemeral materialization.mp4 | 76.1 MB | ||
| 6. Ephemeral materialization.srt | 11.6 KB | ||
| 6. Hooks Quiz.html | 204.8 B | ||
| 6. Macros, Custom Tests and Packages Quiz.html | 204.8 B | ||
| 6. Tests Quiz.html | 204.8 B | ||
| 6. dbt setup - Windows.mp4 | 99.4 MB | ||
| 6. dbt setup - Windows.srt | 13.3 KB | ||
| 7. Course Feedback.html | 204.8 B | ||
| 7. Creating a dbt project and connecting it to Snowflake.mp4 | 39.5 MB | ||
| 7. Creating a dbt project and connecting it to Snowflake.srt | 7.6 KB | ||
| 7. Documentation quiz.html | 204.8 B | ||
| 7. Quiz - Materializations.html | 204.8 B | ||
| 8. Install dbt power tools into VSCode Setup (optional).mp4 | 19.9 MB | ||
| 8. Install dbt power tools into VSCode Setup (optional).srt | 2.9 KB | ||
| 9. Overview of the dbt Project Structure.mp4 | 28.9 MB | ||
| 9. Overview of the dbt Project Structure.srt | 3.9 KB | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 162 total files | |||
Complete dbt (Data Build Tool) Bootcamp: From Zero to Hero
https://DevCourseWeb.com
Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: AAC, 48.0 KHz
Language: English | Size: 2.0 GB | Duration: 4h 12m
The most complete dbt™ course covering theory & practice through a real-world Airbnb use case. Continuously updated!
What you'll learn
Learn to use the dbt™ platform professionally through the creation of an exhaustive, real-world, hands-on dbt - Airbnb project covering both Theory and Practice
Set up the complete development environment on Mac & Windows, Connect to Snowflake and BI, Configure dbt profile, extend the IDE with dbt tools
Learn core dbt concepts such as Models, Materialization, Sources, Seeds, Snapshots, Packages, Hooks, Exposures, Analyses, write complex SQL queries
Understand the dbt project structure and learn about dbt tips & tricks, advanced techniques and best practices, extend dbt with your own / third-party macros
Implement singular and generic dbt tests, work with additional arguments and default config values, customize dbt built-in tests
Document your models and pipeline, customize the dbt docs page, Explore and analyse dependencies between transformation steps
Understand how dbt fits into the modern data stack, learn about the stages of the Data-Maturity Model, and well functioning Data Architectures
Master ETL/ELT procedures, Data Transformations, Database Normalization, Slowly Changing Dimensions, Common Table Expressions and Analytics Engineering
Understand what is a Data Warehouse, Data Lake, or Data Lakehouse and when to use which, handle Data Collection, Data Wrangling and Data Integrations
Requirements
Basic SQL experience
Working computer (Mac/Windows/Linux)
No previous programming language experience required
Description
Greetings to the MOST COMPLETE, CONTINUOUSLY UPDATED independent dbt™ (Data Build Tool) software course in the world - as of 2022!
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 2.7 GB | freecoursewb | 5 days | 7 | 15 | |
| 3 GB | freecoursewb | 5 days | 13 | 29 | |
| 2.7 GB | freecoursewb | 3 weeks | 12 | 1 | |
| 3.8 GB | freecoursewb | 3 weeks | 23 | 3 | |
| 2.7 GB | freecoursewb | 3 weeks | 18 | 1 |
All Comments