SQL Exercises
Test your SQL skills with exercises from all categories:
Exercises
Tip: Sign in to track your progress - it's free.
0/60 done
Syntax4 exercises
Select5 exercises
Select Distinct5 exercises
Where6 exercises
Order By6 exercises
And5 exercises
Or5 exercises
Not6 exercises
Insert Into4 exercises
Null Values7 exercises
Update6 exercises
Delete6 exercises
Select Top3 exercises
Min and Max5 exercises
Count4 exercises
Sum5 exercises
Avg5 exercises
Like9 exercises
Wildcards8 exercises
In6 exercises
Between8 exercises
Aliases5 exercises
Joins6 exercises
Inner Join5 exercises
Left Join3 exercises
Right Join3 exercises
Full Join3 exercises
Self Join3 exercises
Union4 exercises
Group By5 exercises
Having5 exercises
Exists3 exercises
Any, All5 exercises
Select Into5 exercises
Insert Into Select4 exercises
CASE Expression3 exercises
NULL Functions5 exercises
Stored Procedures6 exercises
Comments7 exercises
Operators7 exercises
Create Database5 exercises
Drop Database6 exercises
Backup Database5 exercises
Create Table5 exercises
Drop Table7 exercises
Alter Table8 exercises
Constraints5 exercises
Not Null5 exercises
Unique5 exercises
Primary Key4 exercises
Foreign Key5 exercises
Check4 exercises
Default4 exercises
Create Index5 exercises
Auto Increment3 exercises
Dates3 exercises
View6 exercises
Injection4 exercises
Hosting3 exercises
Data Types3 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-in 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.