Dbt Core From Scratch - Build Your First Project In 2 Hours
Published 5/2025
Created by Dominik Jagoda
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Level: Beginner | Genre: eLearning | Language: English | Duration: 21 Lectures ( 2h 7m ) | Size: 1 GB
dbt Core Essentials: Modeling, Testing, Documentation, and Project Setup
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
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.
Code:
Bitte
Anmelden
oder
Registrieren
um Code Inhalt zu sehen!
