Home>Courses>Learn Data Build Tools ( DBT )

Learn Data Build Tools ( DBT )

Gain insights into setting up dbt, managing models, and leveraging features like data testing. Delve into efficient data pipelines and improve data workflows in this data build tools course.

Beginner

64 Lessons

10h

Certificate of Completion

Gain insights into setting up dbt, managing models, and leveraging features like data testing. Delve into efficient data pipelines and improve data workflows in this data build tools course.

AI-POWERED

Explanations

AI-POWERED

Explanations

This course includes

75 Playgrounds

8 Quizzes

Course Overview

What You'll Learn

Course Content

Course Overview

This course offers a comprehensive introduction to data build tools (dbt), a powerful data transformation tool that streamlines the development and management of data pipelines. You will learn to set up and configure dbt projects, create and manage models, work with data sources, and leverage advanced features like data testing, targets, and snapshots. The course covers various topics, from the basics of dbt to more advanced concepts. You will gain hands-on experience through coding challenges and quizzes,...Show More

TAKEAWAY SKILLS

SQL

Data Manipulation

Data Pipeline Engineering

What You'll Learn

Working knowledge of dbt fundamentals and project structure

Hands-on experience building effective dbt project architectures

An understanding of advanced dbt features for data quality and automation

Familiarity with external data sources and loading data to dbt projects

Hands-on experience creating and using dbt packages for reusability and collaboration

Working knowledge of dbt fundamentals and project structure

Course Content

Introduction to dbt and Its Setup

4 Lessons

Get familiar with dbt's role in data transformation, connecting with BigQuery, and project setup.

Introduction to dbt

dbt Core, Cloud, BigQuery: Unveiling Data Transformation

Creating a dbt Project

Quiz: Introduction to dbt

Overview of the Project Architecture

7 Lessons

Look at configuring profiles, folder paths, model settings, and accessing compiled code in dbt projects.

Profiles

Folders Structure

Model Configurations

Accessing Compiled Code

Quiz: Project Architecture

Coding Challenge: Complete the project.yml File

Solution: Complete the project.yml File

Models

9 Lessons

Go hands-on with creating, referencing, and organizing SQL models, configurations, schemas, and Python models in dbt.

Creating a SQL Model

Referencing Another Model

Coding Challenge: Join Two Models

Solution: Join Two Models

Changing Model Configuration

Overriding Default Schema

Organizing the Models with Folders and Tags

Python Models

Quiz: Models

Sources

5 Lessons

Grasp the fundamentals of setting up and referencing sources, using seeds, and querying datasets.

Setting Up and Referencing a Source

Loading CSV Data with Seeds

Quiz: Sources

Coding Challenge: Querying a Public Dataset

Solution: Querying a Public Dataset

Materializations

8 Lessons

Map out the steps for materializing views, tables, incremental models, and ephemeral models in dbt.

View

Table

Incremental Model with the MERGE Strategy

Incremental Model with the insert_overwrite Strategy

Ephemeral Models

Quiz: Materializations

Coding Challenge: Daily Incrementation

Solution: Daily Incrementation

Dynamic Models with Jinja

11 Lessons

Focus on leveraging Jinja in dbt for dynamic models with variables, loops, and macros.

Introduction to Jinja

Project Variables

Environment Variables

Setting Up Jinja Variables

Iterations

Coding Challenge: Loop Through a List of Columns

Solution: Loop Through a List of Columns

Macros

Quiz: Jinja

Coding Challenge: Daily Aggregation Macro

Solution: Daily Aggregation Macro

Packages

7 Lessons

Build on the use and creation of dbt packages to streamline and enhance projects.

Overview of Packages

Downloading a Package from dbt Hub

Using Macros from a Package

Creating Your First Package

Quiz: Packages

Coding Challenge: Pack Your Macro

Solution: Pack Your Macro

Advanced dbt Concepts

12 Lessons

Sharpen your skills in advanced dbt concepts for data validation, environment management, and documentation.

Challenge: Store Model Runs Inside a Table

Solution: Store Model Runs Inside a Table

Analysis

Documentation

Go Even Further with dbt

Quiz: Advanced dbt Concepts

Challenge: Targets, Tests, and Documentation

Solution: Targets, Tests, and Documentation

Conclusion

1 Lessons

Look at the transformative potential of dbt, enhancing data quality and automating workflows.

Wrap Up

Course Author

Marie Truong

Trusted by 2.5 million developers working at companies

"These are high-quality courses. Trust me. I own around 10 and the price is worth it for the content quality. EducativeInc came at the right time in my career. I'm understanding topics better than with any book or online video tutorial I've done. Truly made for developers. Thanks"

Anthony Walker

@_webarchitect_

"Just finished my first full #ML course: Machine learning for Software Engineers from Educative, Inc. ... Highly recommend!"

Evan Dunbar

ML Engineer

"You guys are the gold standard of crash-courses... Narrow enough that it doesn't need years of study or a full blown book to get the gist, but broad enough that an afternoon of Googling doesn't cut it."

Carlos Matias La Borde

Software Developer

"I spend my days and nights on Educative. It is indispensable. It is such a unique and reader-friendly site"

Souvik Kundu

Front-end Developer

"Your courses are simply awesome, the depth they go into and the breadth of coverage is so good that I don't have to refer to 10 different websites looking for interview topics and content."

Vinay Krishnaiah

Software Developer

"I've tried probably 5-7 different sites and Educative is easily the best. It perfectly blends explanation with interactivity"

Eric Downs

Musician/Entrepeneur

Hands-on Learning Powered by AI

See how Educative uses AI to make your learning more immersive than ever before.

Instant Code Feedback

Evaluate and debug your code with the click of a button. Get real-time feedback on test cases, including time and space complexity of your solutions.

AI-Powered Mock Interviews

Put your skills to the test in a simulated interview setting. Receive personalized feedback based on your performance. Available in Premium & Premium Plus plans.

Adaptive Learning

At various checkpoints throughout Educative courses, you will be prompted to take a quick assessment. Receive a condensed curriculum tailored to your strengths and skill gaps.

Explain with AI

Select any text within any Educative course, and get an instant explanation — without ever leaving your browser.

AI Code Mentor

AI Code Mentor helps you quickly identify errors in your code, learn from your mistakes, and nudge you in the right direction — just like a 1:1 tutor!

Free Resources

FOR TEAMS

Interested in this course for your business or team?

Unlock this course (and 1,000+ more) for your entire org with DevPath