SQLSQL LabPostgreSQL practice
Free PostgreSQL practice · Intermediate

Learn PostgreSQL
by doing.

Forty-five hands-on drills built around deployments, incidents, pipelines, product usage, and the messy-but-real data you meet at work.

Day 010/7 done
0/ 45solved

Today’s focus

Strategic accountsSELECT · WHERE · ORDER BY
Solved0 / 45
Accuracy0%
Streak0 days
Attempts0
Today

Day 1 assignments

0/7
Your progress

Skill tracks

Diagnostic0/6
Joins0/6
Metrics0/7
CTEs0/6
Windows0/7
Time0/5
Field Ops0/6
Stretch0/2
All drills

45 exercises

01 / Diagnostic

Refresh filtering, NULLs, CASE, and basic grouping.

02 / Joins

Connect operational entities without losing or multiplying rows.

03 / Metrics

Build reliable operational metrics with grouped SQL.

04 / CTEs

Decompose ambiguous questions into inspectable stages.

05 / Windows

Rank, deduplicate, compare, and calculate running values.

06 / Time

Reason about cohorts, latency, intervals, and time buckets.

07 / Field Ops

Answer messy deployment and customer-health questions.

08 / Stretch

Practice JSONB and recursive date scaffolding.