3 Things You'll Learn

But how will you actually learn this?

I will be walking you step-by-step through each topic and building a project from scratch along with you.

Here are the tools we will use (all free):

1. Visual Studio Code (editor for writing code)
2. Python (dbt is a Python package)
3. Git (needed for local version control)
4. GitHub (needed for hosted version control and workflow automation)
5. Snowflake - Trial (cloud database for storing data)
6. dbt Cloud - Trial (managed cloud platform for dbt)

If any of this sounds confusing, don't worry - I got you.

My environment will be a blank slate too and the course assumes nothing is installed to start.

You'll also receive pre-built SQL queries that we'll use to quickly configure our Snowflake environment. This will save us setup time so that we can instead focus more on working with dbt.

Some kind words from the Youtube Community

FAQs

Who is this course for?

Data professionals looking to build their skillset with modern data engineering tools.

But there are already too many new tools I need to learn, why dbt?

It has quickly become one of the most popular data transformation tools in the market. As a result there is an increased demand for developers who know how to use it.

I can tell you from first hand experience this is true today.

By learning dbt you'll not only pick up a new skillset but also be introduced to a new way of thinking about how modern analytics teams should operate.

That's cool, but who are you and why should I listen to you?

I've led dbt implementations at companies ranging from Fortune 100 to as small as greenfield startups. Today, I run my own analytics consulting company and work full-time on dbt projects as a solution architect.

I've also taught dbt to hundreds of thousands of people through my YouTube channel over the past 2 years.

Like many others, I am originally a self taught developer and come from a traditional on-premise/ETL data background.

Of course you don't have to listen to me, but learning dbt has had a profound impact on my professional career as a data engineer.

Can my employer pay for this?

Most companies are more than willing to reimburse for continued education and trainings, yet a lot of people never even ask.

In fact, many companies have money budgeted specifically for this purpose.

It's a small expense for a great investment in your skillset. If you are unsure, I would definitely ask.

Are there any prerequisites?

The only must-know is SQL. If you are not comfortable with this language then I wouldn't suggest enrolling in this course.

It is recommended that you have a general understanding of data warehouse concepts (facts, dimensions) and basic programming (loops, variables, etc).

However, even without those you can still complete this course as we will touch on them as we go along.

How long will it take to see results?

After this course you should feel comfortable working on dbt projects right away.

However, remember that dbt is open source and packed with many subtle features. It would be impossible to cover them all in one course.

Like any skill, it will take you more time and practice to become an advanced user. But this course will set your foundations.

What's missing in this course that other high-cost trainings charge so much for?

This is not a multi-day bootcamp or some overly produced content.

In fact, there will be very minimal editing and no special effects. It is simply me teaching you about dbt as efficiently as possible so that you can get on your way.

Many trainings I've attended have a lot of fluff and seem to think that longer times makes it worth more.

I purposely set the goal to keep the runtime around 4 hours to make sure only the most vital information is presented and that it is a course you can actually complete.

Ok, I'm in. How do I sign up?

Click the "Enroll Now" button below or at the top of this page and you'll be on your way.

I look forward to seeing you there.

Cheers,

Mike