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

About this course

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.