Description

Price:  $5.00 USD | Size: 4.1 GB  |  Duration :  4+ Hours  | 50+ Video Lessons | ⭐️⭐️⭐️⭐️⭐️ 4.9

BRAND : Expert TRAINING | ENGLISH |   INSTANT DOWNLOAD 

• 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

• 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)

THEORETICAL SECTION:

Among several other topics, the theoretical section puts special emphasis on transferring knowledge in the following areas;

• Data-Maturity Model
• Well-functioning Data Architectures
• Data Warehouses, Data Lakes, and Data Lakehouses
• ETL and ELT procedures and Data Transformations
• Fundamentals of dbt (Data Build Tool)
• Analytics Engineering
• Modern Data Stack
• Slowly Changing Dimensions
• CTEs

Once we understood the theoretical layer and how dbt fits into the picture, we are going to start building out a dbt project from scratch, just as you would do this in the real world.

PRACTICAL SECTION:

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:

• MAC Development Environment Setup
• WINDOWS Development Environment Setup
• IDE dbt Extension Installation
• Creation and Activation of Virtual Environments
• Setting up Snowflake

Once we are ready – among several other technical topics, the following features will be covered;

• dbt Models
• dbt Materializations
• dbt Tests
• dbt Documentation
• dbt Sources, Seeds, Snapshots
• dbt Hooks and Operations
• Jinja and Macros
• dbt Packages
• Analyses, Exposures
• dbt Seeds
• Data Visualization (Preset)
• Working with Great Expectations (dbt-expectations)
• Debugging tests in dbt

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!

Who is this course for?

• Data Engineers
• Data Analysts
• Data Scientists
• BI Developers
• BI Analyst

… and anyone who interacts with data lake/data warehouse/data lakehouse or uses SQL!