dbt Fundamentals course

What Your Team Will Learn

Our dbt Fundamentals course gets your team hands-on with dbt Cloud. In just a few days, they'll gain the confidence and skills to get started with their own dbt projects and deliver clean and relialable data for

BUILDING THE FOUNDATIONS

Get hands-on: create models, define source tables, test your data and document your project in dbt.
Configure model materialization, track source data freshness, explore the interactive dbt documentation site, and navigate your data lineage.
‍

EXTENDING SQL

Unlock the power of Jinja: use Jinja to dynamically generate queries, reduce repetition, and simplify complex logic.
Create and apply dbt macros to make your analytics code cleaner, smarter, and easier to maintain.

DATA QUALITY

Build confidence in your data: implement automated tests in dbt to catch errors early and keep your pipelines reliable.
Understand why testing matters, use dbt's built-in tests, define your own custom tests, and build data quality into your projects from day one.

STRUCTURED DESIGN

Get ready to scale: Write clean, readable, and consistent SQL that scales with your dbt projects.
Structure your dbt project using layered design patterns to support maintainability, collaboration, and long-term growth.

Who Is This For?

This course is ideal for:
‍

Data Analysts: Analysts looking to level up from traditional SQL scripting to modern analytics engineering practices with dbt
Analytics Engineers (New to dbt): Analytics engineers starting to build and maintain transformation pipelines, but who lack formal dbt project structure experience
Teams Moving to Modern Data Stacks: Teams transitioning from legacy ETL or reporting platforms into dbt + warehouse-based architectures (e.g., Snowflake, Microsoft Fabric)
Internal IT/Data Teams Supporting Analytics: Teams tasked with maintaining or building dbt environments, but without prior exposure to dbt best practices
Data Product Owners / Domain Architects / Managers: Leaders or architects who need hands-on understanding of dbt fundamentals to guide teams, evaluate architecture decisions, or harmonize practices
Project Teams Rolling Out dbt: Groups launching their first dbt projects and needing a strong, scalable, and consistent way of working from the start

Delivery Format

4 half-days (recommended) or 2 full days
Virtual or on-site
Live co-instruction (two trainers)
Hands-on labs and exercises

Frequenty Asked Questions

Discover how modern analytics can transform your business. Dive into the essentials of AI-driven data strategies.