Course

SQL & Databases

Learn SQL from your first query to production databases — querying, joins, window functions, PostgreSQL, and more, hands-on with real datasets

At a glance

Level
Beginner to Advanced
Lessons
45 lessons across 9 modules
What you build
Real databases & guided projects
Cost
Free forever · no sign-up

Course syllabus

Work through the modules at your own pace. Each lesson is a self-contained, hands-on read.

1 Getting Started with SQL 7 lessons · 1–2 weeks
2 Summarizing Data with SQL 4 lessons · 1 week
3 Combining Tables with Joins 4 lessons · 1–2 weeks
4 Subqueries, CTEs, and Views 6 lessons · 2 weeks
5 Window Functions 7 lessons · 2–3 weeks
6 Querying Databases from Python 2 lessons · 1 week
7 PostgreSQL for Data Engineers 7 lessons · 2–3 weeks
8 Optimizing PostgreSQL 5 lessons · 2 weeks
9 Production Database Tools 3 lessons · 1–2 weeks

Before you start

No prior database experience is needed — you'll write your first query in Lesson 1. The later Python and PostgreSQL modules assume a little Python; if you want it first, our Python for Data Analytics course has you covered.

Course features

Completely Free

No hidden costs or subscriptions

From First Query to Production

SELECT basics through database tuning

Practical Projects

Real databases and guided projects

SQL, PostgreSQL & Beyond

Plus Python, Snowflake, and MongoDB

Self-Paced

Study at your own speed, anytime

Text-Based

Easy to copy, search, and reference

Ready to master SQL?

Begin with Getting Started with SQL and work through all 9 modules, from your first query to production databases.

Start the first lesson