Analytics Engineer roadmap › Courses
Best courses for Analytics Engineers
This list covers the courses behind the modeling layer: SQL on a real engine, the dbt course that teaches the project structure, and the tools that check and serve the numbers you produce.
The dbt Fundamentals course is the centerpiece, at about five hours. The rest are free docs and short lessons, so the cost of this list is time, not money.
Finish the dbt course, then build your own small project against a public dataset. The quality tools and the semantic layer make more sense once you have a model that people depend on.
- 5 items in 3 stages: 5 courses and tutorials, 0 certifications.
- We opened every page on November 20, 2026 and show only what the provider states.
- No prices, ratings or enrollment counts.
See the full Analytics Engineer roadmap →Best books for Analytics Engineers →
How to choose your courses
A short method, so you spend your hours on the right thing for where you are instead of collecting certificates.
Find your stage
Getting started · 2 items
The foundations: a structured dbt course and a SQL tutorial on a real database engine. Read these until joins, aggregates and window functions come easily.
Jump to this stage ↓Doing the job · 2 items
The daily work: the BI lessons that show what your models feed, and a data test library that stops bad upstream data from reaching a dashboard.
Jump to this stage ↓Senior and leading · 1 items
Metric definitions in code. Read the semantic layer documentation when you are deciding which definitions move out of dashboards and into the project.
Jump to this stage ↓
If you are unsure, start one stage lower than you think. Later items assume what the earlier ones teach.
Begin with one course
Our starting pick
dbt Fundamentals
dbt Labs
It walks through the project lifecycle the job is judged on: models, sources, tests, documentation and deployment, with a hands-on build.
See the course ↓Then pick by your situation
Choose the next course by the problem in front of you, not by its place in the list.
If your SQL works but you are not sure it is correct on a real engine
take PostgreSQL Tutorial (getting started)
If upstream tables keep breaking and you need tests that fail before a dashboard does
take Introduction to GX Core (doing the job)
If different teams compute the same metric in different tools
take What is the dbt Semantic Layer? (senior and leading)
Free path or paid path?
4 of the 5 courses and tutorials can be read or taken without paying, so you can build most of the skill at no cost. Check each certification page for exam fees.
Paid courses earn their place when you need structure, deadlines or feedback. Check what the provider says is included before you commit.
Set a time budget
| Stage | Items with a stated length | Hours of material | At 4 hrs a week |
|---|---|---|---|
| Getting started | 1 | 5 hrs | 1 wks |
| Doing the job | 0 | none stated | n/a |
| Senior and leading | 0 | none stated | n/a |
| All stages | 1 | 5 hrs | 1 wks |
Totals are approximate.
Exam time is not included, and hands-on practice takes longer than the material itself. Treat this as a floor.
Judge any course before you commit
Who runs it
Prefer courses from the people who build or govern the tool. They tend to stay current, and an exam from a tool’s own maker is the clearest credential for that tool.
Hands-on or watch-only
In this field you learn by running things. Choose material where you build a pipeline, a cluster or a dashboard over material you only watch.
How current it is
Tools change fast. Look for a version or last-updated date on the provider’s page, and check anything several years old against the current docs.
What you will be able to show
Ask what you will have at the end: a working repository, a deployed service or a passed exam. If it is only a certificate of completion, pair it with a project of your own.
Getting started
The foundations: a structured dbt course and a SQL tutorial on a real database engine. Read these until joins, aggregates and window functions come easily.
What you will learn
- Connecting dbt to a warehouse and a Git repository
- Models and sources
- Data tests and documentation
- Deployment of the project
Good for
The most direct structured route into a dbt project. It covers the development lifecycle this role is judged on.
Also stated by the provider
- Lessons: Set Up dbt, Models, Sources, Data Tests, Documentation, Deployment
- Builds a model and runs tests in the course
What you will learn
- Creating tables and populating rows
- Joins between tables
- Aggregate functions
- Window functions and views
Good for
Practice SQL on a real database engine with the query features that analytics models use most.
Also stated by the provider
- Part of the official PostgreSQL documentation
Doing the job
The daily work: the BI lessons that show what your models feed, and a data test library that stops bad upstream data from reaching a dashboard.
What you will learn
- Analyze and visualize data
- Querying and dashboards
- Learn SQL
- Database fundamentals
Good for
Short lessons on the BI layer that your models feed. Use it when you need to build the dashboard yourself.
Also stated by the provider
- Lesson durations shown range from 1 to 15 minutes
- Guides and tutorials on Metabase and analytics
What you will learn
- GX Core components and workflows
- Running GX Core workflows on sample data
Good for
Data tests written as code, so a broken upstream table fails before a dashboard shows wrong numbers.
Also stated by the provider
- Python library
- Public project documentation
Senior and leading
Metric definitions in code. Read the semantic layer documentation when you are deciding which definitions move out of dashboards and into the project.
What you will learn
- Build your metrics
- Deploy the Semantic Layer
- Consume metrics in downstream tools
- Architecture and caching
Good for
Read it when you are moving metric definitions into code and need one definition that every tool can query.
Also stated by the provider
- Includes a quickstart and an FAQ
Details such as hours, format and whether material is free are as the providers state them on November 20, 2026, and can change. Confirm on the provider’s page before you commit. See our disclosure.
Frequently asked questions
Which course should a Analytics Engineer take first?
dbt Fundamentals, from dbt Labs. It walks through the project lifecycle the job is judged on: models, sources, tests, documentation and deployment, with a hands-on build.
Can a Analytics Engineer learn this for free?
Largely, yes. 4 of the 5 courses and tutorials here can be read or taken without paying (PostgreSQL Tutorial, Learn Metabase, Introduction to GX Core, What is the dbt Semantic Layer?). Check each certification page for exam fees: not every page states one.
How long does it take?
The providers state 5 hours of material across 1 of the 5 courses and tutorials; the rest do not state a length. At four hours a week that is about 1 weeks for the stated material alone, before projects and exam preparation.
How was this list put together?
We opened each course, tutorial and certification page on November 20, 2026 and wrote down only what the page states: who runs it, what it covers, hours and exam format where given, and whether the material is free to read. We do not show prices, ratings or enrollment figures. Details can change, so confirm on the provider’s page before you commit.