Welcome to PostgreSQL Exercises! This site was born when I noticed that there's a load of material out there to help people learn about SQL, but not a great deal to make it easy to learn by doing. PGExercises provides a series of questions and explanations built on a single, simple dataset.

PostgreSQL Operators PostgreSQL SELECT PostgreSQL SELECT DISTINCT PostgreSQL WHERE PostgreSQL ORDER BY PostgreSQL LIMIT PostgreSQL MIN and MAX PostgreSQL COUNT PostgreSQL SUM PostgreSQL AVG PostgreSQL LIKE PostgreSQL IN PostgreSQL BETWEEN PostgreSQL AS PostgreSQL Joins PostgreSQL INNER JOIN PostgreSQL LEFT JOIN PostgreSQL RIGHT JOIN PostgreSQL FULL JOIN PostgreSQL CROSS JOIN PostgreSQL UNION PostgreSQL GROUP BY PostgreSQL HAVING PostgreSQL EXISTS PostgreSQL ANY PostgreSQL ALL PostgreSQL CASE ... Tip: Sign in to track your progress. ... If you haven't already, sign up to become a W3Schooler, and get points for every exercise you complete.

July 16, 2026: PostgreSQL 19 Beta 2 Released!

October 30, 2025 - The best way to learn PostgreSQL is through practice. This section is for beginners to intermediate users to enhance their SQL skills with exercises.

This is a compilation of all the questions and answers on Alisdair Owen's PostgreSQL Exercises.

Practice PostgreSQL in Free Labs. Gain hands-on experience with SQL queries, database design, and data management in an interactive and free PostgreSQL playground.

This playlist is a free comprehensive guide through 42 SQL exercises from the free website pgexercises.com. Each video is a step-by-step walkthrough, providi...

Log InLog InJoin FreeJoin For Free · Sharpen PostgreSQL skills through a series of hands-on exercises. This collection of practical challenges is designed to test and improve the ability to solve real-world database problems using PostgreSQL.

Solidify your knowledge of using PostgreSQL queries! This online practice set is dedicated to users who know SQL basics.

Improve your SQL database programming skills with 18 PostgreSQL practice exercises for beginners.

In this tutorial you get a step by step guide on how to install and create a PostgreSQL database. You will learn how to create a project where you can create, read, update, and delete data.

Here are the consolidated list of exercises covering all the key topics related to Postgresql to gain mastery over SQL.

July 23, 2025 - The section features 20 medium-level PostgreSQL questions designed to enhance your SQL skills through practical exercises. These questions cover various topics such as querying member borrowings, identifying the most popular books and authors, and managing book records.

You can try to use free online datasets or even try to create some projects on your own. But it can be hard to come up with practice problems and scenarios. Also, it’s good to have a learning path, where you can find your current level of experience and see what you need to do to progress. That is why LearnSQL’s Practice Set in PostgreSQL is so useful. Its 88 exercises ...

PostgreSQL Practice Exercises · Raw · postgresql_practice_exercises.md · Sample solutions to exercises can be found here: https://gist.github.com/kjs222/5169a292d87d1774832b7160f7ba2b49 · ###Setup: Clone Repo: git clone git@github.com:turingschool-examples/storedom.git bundle update ·

This is a compilation of all the questions and answers on Alisdair Owen's PostgreSQL Exercises.

PostgreSQL Exercises — Learn PostgreSQL with user-submitted tutorials and courses. Compare formats (video, book, interactive), levels (beginner to advanced), and free or paid options to choose the best resource for your learning style.

Solidify your knowledge of using PostgreSQL queries! This online practice set is dedicated to users who know SQL basics.

PostgreSQL Exercises PostgreSQL Quiz PostgreSQL Syllabus PostgreSQL Study Plan · ❮ Previous Next ❯ · You can test your PostgreSQL skills with W3Schools' Quiz. The test contains 25 questions and there is no time limit.