PostgreSQL Official Tutorial

The PostgreSQL tutorial introduces relational databases using the database you will actually run. It covers the first steps, the SQL language, and a selection of more advanced concepts. That combination is useful when you want to move beyond a browser exercise and understand how commands are issued to a real database server.

What you will learn

• Create and access a PostgreSQL database
• Define tables and query stored data
• Understand relational operations
• Explore transactions and other PostgreSQL concepts

Who this suits

Useful for a developer or analyst beginning PostgreSQL who is comfortable installing software and using a terminal. Previous SQL experience helps but is not required for the tutorial's opening material. Keep a disposable practice database so experimentation does not affect valuable data.

Before you enroll

The current documentation URL changes its target as new major releases appear. Select the version matching your installation. This tutorial is a guided introduction, while authentication configuration, backups, query plans, and production operations belong to the wider documentation.

Free official documentation with no course certificate. PostgreSQL can be installed locally without buying a hosted database plan.

Put it into practice

Wrap a pair of related changes in a transaction and verify that rolling it back restores both tables to their previous state.

Source and review

This overview is based on the provider's published information, checked on 11 October 2026. It is an editorial assessment, not a claim that we completed the resource. Time filters are approximate study ranges; projects and exercises can take longer.

View the curriculum and current access options at PostgreSQL.

How YellowCourse describes and checks learning resources.