All courses
Step 1 of 4 in Analytics Engineer
SQL Fundamentals with DuckDB
Learn the SQL you need for analytics — SELECT to JOINs — using DuckDB, the in-process analytics database.
- 7 lessons
- 2 runnable labs
- ~2h
- Assessed certificate
- Updated August 2026
Everything in this course is free to read — no account needed. Sign in to track your progress and earn the certificate.
What you'll learn
- Read and write SELECT queries with confident filtering and sorting
- Summarize real datasets with GROUP BY and the core aggregate functions
- Combine tables with JOINs and reason about what each join keeps
- Run and check every query yourself in DuckDB, right in the browser
Who this is for
Analysts, engineers, and anyone data-adjacent who wants to stop copy-pasting SQL and start writing it. If spreadsheets are getting too small for your questions, you're in the right place.
Before you start
No SQL experience needed — we start from the first SELECT. You should be comfortable in a browser and curious about data; everything else is provided, nothing to install.
About this course
SQL is the working language of analytics, and DuckDB is the fastest way to practice it for real: a full analytics database that runs right here in your browser. This course takes you from your first SELECT to confident JOINs and aggregations — every concept lands in a runnable lab against real data, checked as you go.
Try a lab from this course
This is a real lab from lesson 4, “Lab: Filtering practice” — press Run.