Menu
×
   ❮   
HTML CSS JAVASCRIPT SQL PYTHON JAVA PHP HOW TO W3.CSS C C++ C# BOOTSTRAP REACT MYSQL JQUERY EXCEL XML DJANGO NUMPY PANDAS NODEJS R TYPESCRIPT ANGULAR GIT POSTGRESQL MONGODB ASP AI GO KOTLIN SASS VUE DSA GEN AI SCIPY AWS CYBERSECURITY DATA SCIENCE
     ❯   

PostgreSQL Tutorial

[+:

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:

Example

Sort the table by year:

SELECT * FROM cars
ORDER BY year;
Run Example »

PostgreSQL Exercises

Test Yourself With Exercises

Exercise:

Insert the missing part to return all the columns from the cars table:

 FROM cars;

Start the Exercise


PostgreSQL Quiz

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

Start PostgreSQL Quiz


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.

Track your progress with at W3Schools.com

×

Contact Sales

If you want to use W3Schools services as an educational institution, team or enterprise, send us an e-mail:
sales@w3schools.com

Report Error

If you want to report an error, or if you want to make a suggestion, send us an e-mail:
help@w3schools.com

W3Schools is optimized for learning and training. Examples might be simplified to improve reading and learning. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. While using W3Schools, you agree to have read and accepted our terms of use, cookie and privacy policy.

Copyright 1999-2024 by Refsnes Data. All Rights Reserved. W3Schools is Powered by W3.CSS.