Udemy – The Complete dbt (Data Build Tool) Bootcamp: Zero to Hero 2024-9

The Complete dbt (Data Build Tool) Bootcamp: Zero to Hero, The structure of the course is designed to have a top-down approach. It starts with the Analytics Engineering Theory – all you need to know is to put dbt (Data Build Tool) in context and to have an understanding of how it fits into the modern data stack. We start with the big picture; then, we go deeper and deeper. Once you learn about the pieces, we are going to shift to the technicalities – a practical section -, which will focus on putting together the dbt “puzzle”. The practical section will cover each and every single dbt feature present today through the construction of a complete, real-world project; Airbnb. This presents an opportunity for us to show you which features should be used at what stage in a given project, and you will see how dbt is used in the industry. The practical section will go through a real-world Airbnb project where you will master the ins and outs of dbt! We put special focus on getting everyone up and ready before the technical deep dive, hence we will start off by setting up our Development Environment Once the theory and the practical stages are finished, we are going to dive into the best practices and more advanced topics.

The course is continuously updated, whenever dbt publishes an update we adjust the course accordingly, so you always be up to date! The course doesn’t have any expectations about your abilities and starts education from zero. Every exercise is an unavoidable step in your studies. In the same way, don’t start an exercise of a superior level without having completed the preceding ones: you will be in difficulty if you do so. Practice is the only way to learn and it cannot be taken lightly. We are going to be next to you along the journey and you have our absolute support! When the Airbnb project is presented to you, you have to do it in its entirety, without omitting any guidelines and by understanding the objective. A project “almost completely” done is often a project “totally incomplete” for us. Give special attention to detail. Your only reliable source of information regarding the instructions is the pedagogical team, don’t trust the “I’ve heard”.

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, Modern Data Stack, 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
• See how advanced testing works using dbt-expectations, a Great Expectations inspired testing framework

Who this course is for

• Analytics Engineers
• Data Analysts
• BI Analysts
• Data Scientists
• Data Engineers

Specificatoin of The Complete dbt (Data Build Tool) Bootcamp: Zero to Hero

• Publisher: Udemy
• Teacher: Zoltan C. Toth , Miklos (Mike) Petridisz
• Language: English
• Level: All Levels
• Number of Course: 115
• Duration: 8 hours and 46 minutes

Content

Requirements

• Basic SQL experience
• No previous programming language experience required
• Working computer (Mac/Windows/Linux)
• Network access whitelist to snowflake(.com) and GitHub if you work behind a firewall or VPN
• Git and Python (We are linking to the installation instructions of these tools in the course)

Pictures

Sample Clip

Installation Guide

Extract the files and watch with your favorite player

Subtitle: English

Quality: 720p

Changes:

Version 2023/11 compared to 2022/11 has increased the number of 13 lessons for 1 hour and 30 minutes.

Version 2024/9 compared to 2023/11 has increased the number of 21 lessons for 2 hour and 3 minutes.

Download Links

Download Part 1 – 1 GB

Download Part 2 – 1 GB

Download Part 3 – 868 MB

File size

2.86 GB