Skip to content
Breakpoint logobreakpoınt

PostgreSQL Exercises

Write real PostgreSQL queries against a country club database

PostgreSQL Exercises is a set of SQL questions built on one small database for a made-up country club, with tables for members, facilities and bookings. Each page asks a question, shows the expected result, and gives you a box to type your query. You run it against a live PostgreSQL database, and you can open a hint or the answer with a short discussion.

Play on pgexercises.com

Free · No login · Browser · Beginner

About PostgreSQL Exercises

The 71 exercises are grouped into basic queries, joins and subqueries, modifying data, aggregates, dates, strings and recursive queries. They suit beginners learning SQL and anyone who wants to practise PostgreSQL features like window functions.

The site is free and needs no account. You can also download the dataset and run it on your own PostgreSQL install. The question text is licensed CC BY-SA.

Made this game? Claim it →

Keyboard shortcuts

j / k
Move down / up the list (this page)
] / [
Next / previous page
o
Open the focused game
b
Save or unsave the focused game
/
Search (the home list, or the command palette elsewhere)
Ctrl K
Command palette: games, skills, pages (works even when single keys are off)
?
This help