PostgreSQL
A feature-rich object-relational database.
PostgreSQL is taught here in 3 lessons, running from psql and the basics of SQL through to Transactions and MVCC basics. Each lesson takes one topic, shows the working code, and links onward to the next, so the course can be read straight through in order.
| Track | Databases |
| Lessons | 3 |
| Level | Beginner |
| Reading time | about 39 minutes |
| Prerequisites | Helpful, but not required: MySQL |
Lessons
- psql and the basics of SQLDrive the server from psql, learn the meta-commands worth memorising, and create tables with the types PostgreSQL actually gives you.
- JSONB and arraysWhen a document column beats another table, how the JSON operators differ, and how to index both JSONB and arrays properly.
- Transactions and MVCC basicsIsolation levels in practice, why readers never block writers, and what vacuum is really cleaning up.
More in Databases
SQL MySQL MongoDB Redis SQLite
FAQ
How long does the PostgreSQL course take?
It has 3 lessons, about 39 minutes of reading. Expect roughly twice that if you type out and run every example.
Do I need prior experience for PostgreSQL?
Not strictly. It helps to have read MySQL first, because some lessons build on it, but every lesson explains its own assumptions.
What should I read after PostgreSQL?
Continue with MongoDB (14 lessons), the next course in Databases.
Last refreshed 2026-09-18.