PostgreSQL Tutorial

PostgreSQL is an advanced relational system.

PostgreSQL supports both relational (SQL) and
non-relational (JSON) queries.

PostgreSQL is free and open-source.

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.

PostgreSQL Exercises

PostgreSQL Quiz

Learn by taking a quiz! The quiz will give you a signal of how much you know about PostgreSQL.

My Learning

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.

PostgreSQL Tutorial

PostgreSQL Home PostgreSQL Intro PostgreSQL Install postgresql Get Started PostgreSQL pgAdmin 4

Database

PostgreSQL CREATE TABLE PostgreSQL INSERT INTO PostgreSQL Fetch Data PostgreSQL ADD COLUMN PostgreSQL UPDATE PostgreSQL ALTER COLUMN PostgreSQL DROP COLUMN PostgreSQL DELETE PostgreSQL DROP TABLE Create Demo Database

PostgreSQL Syntax

PostgreSQL Operators PostgreSQL SELECT PostgreSQL SELECT DISTINCT PostgreSQL WHERE PostgreSQL ORDER BY PostgreSQL LIMIT PostgreSQL MIN and MAX PostgreSQL COUNT PostgreSQL SUM PostgreSQL AVG PostgreSQL LIKE PostgreSQL IN PostgreSQL BETWEEN PostgreSQL AS PostgreSQL Joins PostgreSQL INNER JOIN PostgreSQL LEFT JOIN PostgreSQL RIGHT JOIN PostgreSQL FULL JOIN PostgreSQL CROSS JOIN PostgreSQL UNION PostgreSQL GROUP BY PostgreSQL HAVING PostgreSQL EXISTS PostgreSQL ANY PostgreSQL ALL PostgreSQL CASE

Exercises

PostgreSQL Exercises PostgreSQL Quiz PostgreSQL Certificate