PostgreSQL Exercises
Exercises
Test your PostgreSQL skills with exercises from all categories:
Create table
Insert Data
Select Data
Add Column
Update Data
ALTER COLUMN
DROP COLUMN
DELETE
DROP TABLE
OPERATORS
SELECT
SELECT DISTINCT
WHERE
ORDER BY
LIMIT
MIN and MAX
COUNT
SUM
AVG
LIKE
IN
BETWEEN
AS
Joins
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL JOIN
CROSS JOIN
UNION
GROUP BY
HAVING
EXISTS
ANY
ALL
CASE
Log in to track your progress
If you haven't already, sign up to become a W3Schooler, and get points for every exercise you complete.
As a logged on W3Schools user you will have access to many features like having your own web page, track your learning progress, receive personal guided paths, and more.
The Exercise
The exercises are a mix of "multiple choice" and "fill in the blanks" questions. There are between 3 and 9 questions in each category. The answer can be found in the corresponding tutorial chapter. If you're stuck, or answer wrong, you can try again or hit the "Show Answer" button to see the correct answer.
If you don't know PostgreSQL, we suggest that you read our PostgreSQL Tutorial from scratch.