PostgreSQL is an advanced relational database system.
PostgreSQL supports both relational (SQL) and non-relational (JSON) queries.
PostgreSQL is free and open-source.Start learning PostgreSQL now ❯
Learning by Doing
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.
You will learn how to query, filter, and sort data from the database.
Examples in Each Chapter
In the tutorial we will use examples to show what SQL statements returns from the database:
Sort the table by year:
SELECT * FROM cars
Run Example »
ORDER BY year;
Learn by taking a quiz! The quiz will give you a signal of how much you know about PostgreSQL.
Track your progress with the free "My Learning" program here at W3Schools.
Log in to your account, and start earning points!
This is an optional feature. You can study at W3Schools without using My Learning.