PostgreSQL
Learn PostgreSQL by writing real queries. Short lessons on every core concept, each followed by exercises you solve right in the editor.
- 65 practice problems
- 54 lessons
- Free — runs in your browser, no setup
What you'll learn
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.