Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
dbt Core From Scratch - Build Your First Project in 2 Hours
Rating: 4.6 out of 5(34 ratings)
286 students

dbt Core From Scratch - Build Your First Project in 2 Hours

Learn DBT Core step-by-step by creating your own analytics project. Perfect for beginners in modern data engineering.
Created byDominik Jagoda
Last updated 1/2026
English

What you'll learn

  • Understand the fundamentals and architecture of dbt Core
  • Test, Document, and Monitor Data Transformations
  • Debug and Resolve Common Issues in DBT Core
  • Build a complete dbt project from scratch

Course content

6 sections • 22 lectures • 2h 10m total length

  • Introduction1:01

    Learn dbt core from scratch through hands-on, real-project work designed for beginners. Progress through structured sections, complete zip-file exercises, and quizzes to build your first dbt project in two hours.

  • ELT vs ETL3:22
  • What is dbt ?2:47

    Explore how dbt replaces in-warehouse transformations with a structured, testable, version-controlled ELT workflow that builds, documents, and visualizes lineage of data models.

Requirements

  • Basic Knowledge of SQL
  • Fundamental Understanding of Databases
  • Python Installed

Description

Welcome to a comprehensive yet fast-paced onboarding course for dbt Core — the essential tool revolutionizing how data teams transform and manage data in the modern analytics stack. Over approximately 2 hours, this course will guide you step-by-step through everything you need to know to confidently start working with dbt Core, from installation and configuration to advanced modeling and documentation.

You will begin by understanding the key differences between ELT and ETL processes, and learn exactly what dbt is and why it’s a game-changer for data transformation. Next, we’ll cover how to set up your environment, including detailed installation instructions for both Windows and Linux, and configuration of the critical profiles.yaml file to connect dbt to your data warehouse.

The course dives deep into working with Sources to manage your raw data, including freshness checks and tests to ensure data reliability. You’ll master Models — learning how to build, organize, and materialize SQL models efficiently, including incremental models that optimize performance.

Macros will be demystified so you can automate repetitive tasks and streamline your dbt workflows. Finally, you’ll explore Seeds and Documentation, learning to load CSV data into your warehouse and generate clean, useful documentation for your projects.

Whether you’re a data analyst, engineer, or anyone eager to embrace modern data transformation best practices, this fast onboarding course will equip you with practical skills and confidence to accelerate your dbt Core journey and improve your team’s data pipeline quality and maintainability.

Who this course is for:

  • Data Analysts and Business Analysts Professionals who work with SQL and want a fast, hands-on introduction to dbt Core to improve how they transform and structure data.
  • Data Engineers Specialists responsible for data pipelines who want a practical overview of dbt Core to better collaborate with analytics teams and streamline transformation logic.
  • Analytics Engineers Professionals looking for a quick, structured way to start using dbt Core in their workflows and understand its role in the modern data stack.
  • SQL Developers and ETL/ELT Specialists Experienced SQL users or traditional ETL practitioners transitioning to dbt-based ELT and looking for a concise, no-frills onboarding.
  • Aspiring Data Professionals Beginners with basic SQL knowledge who want to get a quick and modern introduction to data modeling and transformation using dbt Core.

Report abuse