dbt Certification Study Resources: The Free-First Stack
Almost everything you need for the dbt certification is free and published by dbt Labs. The scarce resource is exam-style questions — here is the whole shelf.
- $200Exam fee
- 35-50 hTotal prep
- $0Material cost
- FreeLab tier
- Exam-style QsBiggest gap

Table of Contents
What actually exists
The dbt Analytics Engineering certification is 65 questions in 120 minutes with a 65% pass mark, at $200. It is unusual among data certifications in that the vendor gives away almost all the preparation material: dbt Labs publishes free courses, a study guide, exhaustive documentation, and a free developer tier you can build in. The scarcity is at the other end — exam-style question volume is thin, and the exam is written for people who have shipped models rather than watched videos about them.
- Official coursesWell serveddbt Labs' learning platform carries free courses from fundamentals through advanced topics such as testing, Jinja and macros, and deployment. Free, current, and written by the vendor.
- Official study guideWell serveddbt Labs publishes an exam study guide that lists what is tested. It is short — treat it as the scope boundary rather than as the content.
- DocumentationWell servedThe dbt docs are unusually good and the exam draws directly on them: configurations, materialisations, snapshots, tests, sources and the project structure conventions.
- Free hands-on tierWell servedThe developer tier lets you build and run a real project at no cost. Combined with a free warehouse trial, the entire lab layer is free.
- BooksThinOne or two analytics-engineering titles exist and are useful for the discipline, but none is written to this exam. Read for context, not for coverage.
- Third-party coursesThinMarketplace dbt courses exist but rarely target the certification, and several teach older CLI-era workflows.
- CommunityWell servedThe dbt community Slack is one of the most active in data tooling, with channels covering certification, modelling patterns and debugging.
This is the cheapest exam in this batch to prepare for and one of the hardest to fake. Everything you need is free; what the exam actually filters for is whether you have run dbt on a real project.
The stack, in build order
Because the material is free, the plan is about sequencing rather than budgeting. The one rule that matters: build a project early, not at the end.
- 1Study guide, read as scopedbt Labs' exam study guide tells you which topics are in play. Everything else you read should map back to a line in it.
- 2dbt Fundamentals courseThe official on-ramp: projects, models, sources, tests, documentation and deployment basics. Do the exercises rather than watching through.
- 3Build a real projectConnect a warehouse trial, model a small dataset through staging and marts, add tests and docs, and schedule a job. This is the layer the exam is written against.
- 4Advanced official coursesJinja and macros, advanced testing, incremental models and snapshots, and deployment practice. Where the harder exam questions come from.
- 5Docs sweep on configurationMaterialisations, configs and their precedence, ref and source resolution, packages, and project structure conventions. Detail-level recall the exam likes.
- 6Debugging drillsBreak your project deliberately: a circular ref, a failing test, a stale incremental. Troubleshooting is an explicit exam topic and it is best learned by causing the failure.
Total: roughly 35-50 hours for an analytics engineer already using dbt, and 55-70 for an analyst who knows SQL but has never run a dbt project.
Every resource, ranked
Ranked for a candidate paying their own way. The striking part of this list is how little of it costs anything.
| Resource | Type | Cost | Hours | Verdict |
|---|---|---|---|---|
| dbt Labs official courses | official | $0 | 15-20 | The core of the stack. Free, vendor-written, and mapped to how the product actually works. |
| dbt documentation | official | $0 | 5-7 | The exam's detail questions live here — configuration precedence, materialisation behaviour, snapshot strategies. |
| Official exam study guide | official | $0 | 1 | Short but essential: it defines scope. Map every study hour back to it. |
| Free developer tier plus warehouse trial | free | $0 | 12-18 | The whole lab layer, free. No reason to prepare for this exam without a running project. |
| dbt community Slack | community | $0 | As needed | Genuinely useful, unusually so. Certification channels plus fast answers on modelling patterns. |
| Analytics engineering books | paid | $35-$50 | 10-15 | Good for the discipline and the mental model. Not written to this exam — buy for the career, not the pass. |
| ExamCert dbt question bank | paid | Free tier, then $5.99 | 6-8 | Covers the scarcest layer: exam-style question volume. Free sets first. |
Three budgets, three plans
Three plans that differ mainly in how much time you can commit, since the money involved is close to zero either way.
Free path
Exam fee only5-7 weeks
- Official courses, docs and study guide
- Free developer tier plus a warehouse trial
- Community Slack for questions
- The default recommendation — the free material really is sufficient
Free plus drilling
Fee + about $64-6 weeks
- Everything in the free path
- A question bank for exam-style volume
- Closes the one genuine gap in the free shelf
Project-first sprint
Fee + $403-4 weeks
- Build a real project in week one, learn from what breaks
- Official advanced courses as targeted repair
- For working analytics engineers who need the credential quickly
Which resource covers which exam area
dbt Labs organises the exam around four areas. Weights move between revisions, so confirm against the current study guide.
- Developing and optimising dbt modelsLargestFundamentals course plus your own project. Materialisations, refs, sources and incremental strategy.
- Managing model governanceSubstantialDocs plus advanced courses. Tests, documentation, exposures, access and project structure conventions.
- Debugging data modelling errorsSubstantialBreaking your own project on purpose. Compilation errors, circular references and failing tests.
- Troubleshooting and optimising pipelinesModerateDeployment courses plus real job runs. Job scheduling, run failures, and performance patterns.
- Jinja, macros and packagesCuts acrossAdvanced course plus docs. Frequently underestimated because it feels optional day to day.
Governance and pipeline troubleshooting are the two areas analysts under-prepare, because in a real team someone else usually owns them. The exam assumes you own all of it.
What to skip
With the official material free and good, most third-party spending on this exam is wasted.
Do not spend money on these
- Paid courses that duplicate the free official ones. dbt Labs teaches its own product better than a marketplace instructor does, at zero cost.
- Material written for the old CLI-only workflow. The product and the exam have moved; older tutorials teach patterns that no longer match the current defaults.
- Studying without a running project. The most common failure mode on this exam. Reading about incremental models does not survive contact with a question about one.
- Dumps. A $200 exam with a free preparation shelf is not a good place to risk your credential.
- Deep warehouse-specific tuning. Useful in your job, out of scope here — the exam is about dbt, not about one warehouse's optimiser.
The layer nobody budgets for is question volume
The free official material teaches dbt properly. What it does not do is ask you 200 exam-shaped questions and explain every miss. That is the layer worth adding at the end. Free question sets first, then $5.99 unlocks the full bank.
dbt Analytics Engineering exam pageFAQ
Can I pass the dbt certification with free resources?
Yes — more comfortably than on almost any paid certification. dbt Labs publishes free courses, a study guide and complete documentation, and the developer tier lets you build a real project at no cost. The only genuinely scarce resource is exam-style question volume.
Do I need real dbt experience to pass?
You need a real project, though not necessarily a job. The exam asks about debugging, governance and pipeline behaviour in ways that assume you have run models, seen tests fail and fixed a broken ref. Building a small project on the free tier satisfies that.
How long should I study for the dbt exam?
Thirty-five to fifty hours if you already use dbt at work, and fifty-five to seventy if you know SQL but have never run a project. Front-load the project build so that the courses land on top of practical experience rather than the other way round.
Is the dbt certification worth $200?
It is worth it if you are an analytics engineer or an analyst moving toward that role, where dbt is close to a default in the modern data stack. It is worth less if your team does not use dbt — the credential signals tool fluency rather than data modelling seniority.
Sources
Fees, objectives and course catalogues on this page come from dbt Labs and the publishers themselves:
Checked September 9, 2026. Training catalogues, book editions and exam fees change without notice — confirm with dbt Labs before you spend anything.
