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.

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

StageItems with a stated lengthHours of materialAt 4 hrs a week
Getting started15 hrs1 wks
Doing the job0none statedn/a
Senior and leading0none statedn/a
All stages15 hrs1 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.

  • Start hereCourse

    dbt Fundamentals

    dbt Labs

    • 5 hours of material
    View course →

    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
  • Hands-on tutorialFree to learn

    PostgreSQL Tutorial

    PostgreSQL Global Development Group

    View 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.

  • Hands-on tutorialFree to learn

    Learn Metabase

    Metabase

    View course →

    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
  • Hands-on tutorialFree to learn

    Introduction to GX Core

    Great Expectations

    View course →

    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.

  • Hands-on tutorialFree to learn

    What is the dbt Semantic Layer?

    dbt Labs

    View course →

    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.