PostgreSQL Exercises
Test your PostgreSQL skills with exercises from all categories:
Exercises
Tip: Sign in to track your progress.
Create table4 exercises
Insert Data3 exercises
Select Data3 exercises
Add Column3 exercises
Update Data3 exercises
ALTER COLUMN3 exercises
DROP COLUMN3 exercises
DELETE4 exercises
DROP TABLE3 exercises
OPERATORS9 exercises
SELECT3 exercises
SELECT DISTINCT3 exercises
WHERE3 exercises
ORDER BY3 exercises
LIMIT3 exercises
MIN and MAX3 exercises
COUNT3 exercises
SUM3 exercises
AVG3 exercises
LIKE4 exercises
IN3 exercises
BETWEEN3 exercises
AS3 exercises
Joins3 exercises
INNER JOIN3 exercises
LEFT JOIN4 exercises
RIGHT JOIN3 exercises
FULL JOIN3 exercises
CROSS JOIN3 exercises
UNION4 exercises
GROUP BY3 exercises
HAVING3 exercises
EXISTS3 exercises
ANY3 exercises
ALL3 exercises
CASE3 exercises
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.