OneCompiler

PostgreSQL

Learn PostgreSQL by writing real queries. Short lessons on every core concept, each followed by exercises you solve right in the editor.

8 sections·54 items·Beginner
This course includes
  • 65 practice problems
  • 54 lessons
  • Free — runs in your browser, no setup

What you'll learn

Read and filter data with SELECT, WHERE and ORDER BY
Summarize data with GROUP BY and aggregate functions
Insert, update and delete records, with RETURNING, upserts and transactions
Combine data from multiple tables with joins
Work with constraints, views and indexes
Use PostgreSQL features like window functions, arrays and JSONB

Syllabus

About this course

PostgreSQL (often called Postgres) is a free and open-source relational database, and one of the most popular databases in the world. The fastest way to learn it is to write queries against real tables. That is how this course works: each topic starts with a short lesson, then gives you an exercise with the tables already set up, so you can try it right away.

You will start with reading data: SELECT, WHERE, sorting and filtering. Then you will learn aggregate functions, changing data, joins, constraints, views and indexes. The last section covers some of PostgreSQL's best features, like window functions, arrays and JSONB. Short quizzes along the way check that the ideas stick.

There is nothing to set up or install. The editor runs your queries on a real PostgreSQL database and checks the results for you. If you have never used a database before, start at the top and go in order. If you know the basics, jump to the topic you need.