dbtforbeginners.com

On-demand Enterprise Program

dbt from scratch

Online program with live lectures and real-life practice that should help you master dbt from the ground up and build reliable and scalable analytics.

Enroll now Details ↓

6 lectures πŸŽ“

Each hour lecture takes about 1 hour and is conducted live with a coach at a time that works for you.

6 practical tasks πŸ’»

Practical projects help you quickly get started with the tool while simulating real-world project scenarios.

Your career πŸ‘©πŸΎβ€πŸ’»

After completing the program, you'll be equipped to work as an Analytics Engineer, as dbt is the industry-standard tool in analytics engineering.

Take Your Skills to the Next Level πŸš€

Join our coaching program and learn how world-class data teams leverage dbt to modernize their analytics workflows.

Whether you're looking to improve data modeling, enhance collaboration, or streamline ELT processes, this program will give you the skills and confidence to succeed.

What You’ll Achieve βœ…

By the end of this coaching program, you will:

  • βœ”οΈ Gain a comprehensive understanding of dbt and its real-world applications
  • βœ”οΈ Have the skills to implement dbt in your analytics workflow
  • βœ”οΈ Collaborate effectively with data teams on data modeling projects
  • βœ”οΈ Apply best practices in data testing and documentation
  • βœ”οΈ Improve data pipeline reliability and scalability

Who Is This Program For?

β˜‘οΈ Small and medium businesses aiming to modernize their data stack.
β˜‘οΈ Data-driven organizations looking to enhance data quality and streamline ETL processes.
β˜‘οΈ Analytics professionals who want to implement best practices in data modeling and transformation.

Not sure if it's for you? If you work with data and want to level up your skills, this program is the right fit! βœ…

Coaching program β˜€οΈ

Session 1

Introduction to dbt

Theory πŸŽ“

  • learn about β€œdbt approach”
  • difference between ETL and ETL
  • how dbt fits into modern data stack
  • what is possible to do with dbt

Practice πŸ› οΈ

  • setting up a dev environment
  • create your first dbt project
  • run your first dbt command

Session 2

dbt foundations

Theory πŸŽ“

  • dbt key components
  • dbt commands
  • node selection syntax
  • Jinja templating

Practice πŸ› οΈ

  • create model, source and seed
  • practice running dbt commands
  • learn β€œref()” and β€œsource()” macros

Session 3

Project structure

Theory πŸŽ“

  • common problems with dbt at scale
  • modeling layers
  • model conventions
  • refactoring to best practices

Practice πŸ› οΈ

  • refactor models to modeling layers
  • set default materializations strategies

Session 4

Testing and documentation

Theory πŸŽ“

  • models properties
  • documenting models
  • tests in dbt
  • tests configuration

Practice πŸ› οΈ

  • create property files
  • document models and generate docs
  • write data and freshness tests

Session 5

Advanced features

Theory πŸŽ“

  • macros and packages
  • dbt variables
  • advanved materializations
  • dbt snapshots

Practice πŸ› οΈ

  • create a macro
  • install and try packages
  • create a model with dbt variable

Session 6

Deployment and scaling

Theory πŸŽ“

  • code environments
  • developer experience
  • CI/CD and SlimCI
  • scheduling options

Practice πŸ› οΈ

  • create PR template
  • add SQL linter and CI pipeline
  • deploy to Github Actions

Required Knowledge πŸ“š

SQL

Basic knowledge of SQL, including the ability to write SELECT queries.

CLI

Basic knowledge of bash commands and familiarity with command-line interface (CLI) tools.

Git

Basic understanding of Git commands and a GitHub account.

Program Format πŸŽ“

  • πŸ“… Duration: 3 weeks
  • πŸ“ Live Sessions: 2 per week
  • πŸ’¬ Direct Chat: Ongoing support via shared chat
  • ❓ Q&A Sessions: Optional for additional guidance

Meet your instructor

With years of hands-on experience in data analytics and engineering, Oleg has helped numerous teams optimize their data workflows using dbt.

This coaching program is designed to provide practical, real-world insights to help you succeed.

LinkedIn My newsletter

Pricing

Full program

$379

/ per participant

Full version of the program with live lectures and practice

What's included:

  • 6 lectures (~1h each)
  • guided homework
  • access to recordings
  • online support via chat
Enroll now

Custom program

Custom

/ per participant

Custom program tailred to your needs.

What's included:

  • lectures with agreed topics
  • guided homework
  • access to recordings
  • Q&A sessions
Enroll now

Frequently Asked Questions

  • πŸ”Ή What prior experience do I need for this course?

    You'll need basic knowledge of SQL (ability to write SELECT queries), familiarity with terminal/CLI commands, and basic understanding of Git/GitHub. No prior dbt experience is required.

  • πŸ”Ή How much time should I allocate per week?

    You should expect to spend about 4-5 hours per week, including 2 one-hour live sessions and 2-3 hours for practical assignments and self-study.

  • πŸ”Ή What if I miss a live session?

    All sessions are scheduled at times that work for you. However, if you need to miss one, recordings will be available, and you can ask questions through our chat support.

  • πŸ”Ή What tools and software will I need?

    To complete the course, you only need a computer with internet access and a web browser, as all work can be done in GitHub Codespaces. For a better development experience, students may optionally work locally on their laptops using Git and their preferred IDE. Access to Snowflake database will be provided as part of the course.

  • πŸ”Ή Is there ongoing support after the program ends?

    Yes, you'll have access to the course materials even after completion. You can also stay connected with fellow participants through our community channels.

  • πŸ”Ή Can my company sponsor this training?

    Yes, many companies provide professional development for their teams. We can provide all necessary documentation for corporate training budgets.