Snowflake & dbt – A Hands-On Guide

Hands-On Data Engineering with dbt & Snowflake – Build Scalable Data Models and ETL Pipelines

What you'll learn
Ingest data into Snowflake from multiple sources (AWS S3 and local files)
Set up and manage internal and external stages in Snowflake
Use SnowSQL to load and query data in Snowflake efficiently
Build and optimize data transformation models using dbt
Understand version control and modularity in dbt for scalable data projects
Work with semi-structured data - JSON
Work with Time functions and Window functions

Requirements
Basic SQL knowledge is recommended but not required
Familiarity with data concepts (optional, but helpful)
No prior experience with dbt or Snowflake required - everything will be explained step by step

Description
Are you ready to take your data skills to the next level? Whether you're a data analyst, engineer, or aspiring data professional, this hands-on course will teach you how to design and build modern data pipelines using Snowflake and dbt (data build tool) — two of the most powerful tools in the data stack today.In this course, you’ll learn how to set up your own Snowflake environment, ingest data from different sources (including local files and cloud storage), and transform it into clean, analytics-ready tables using dbt. We’ll cover data modeling concepts, ELT best practices, version control, and how to structure a real-world project using dbt Core.You’ll also learn how to:Create and manage Snowflake databases, schemas, and stagesWrite modular SQL transformations with dbt modelsLearn to work with CTEs and Window functionsCollaborate using dbt and GitPrepare your data for reporting tools like Power BI and other platformsThis course is packed with practical examples, code walkthroughs, and tips based on real-world experience setting up Snowflake and dbt in production environments.By the end of the course, you’ll be confident in building reliable, maintainable data pipelines — and fully ready to apply those skills immediately.Let’s dive in!

Who this course is for:
Aspiring and current data analysts and engineers looking to master Snowflake and dbt, Developers and software engineers interested in modern ELT workflows, Anyone who wants a hands-on, project-based approach to Snowflake and dbt