Test your SQL skills with quizzes, workouts, and classes
SQL is the definitive data access language. Whether you're a developer, DBA, data scientist or analyst, knowing SQL will be an asset throughout your career.
We've built Oracle Dev Gym to train you from zero to hero. Take our free courses to teach you the basics of SQL, targeted workouts to drill you on specific topics, and weekly quizzes to top up your skills and compete with others.
Take free SQL quizzes online
Testing yourself is one of the few ways proven to help you learn faster. With hundreds of multiple choice SQL quizzes to choose from, Oracle Dev Gym is the ideal place to train and enhance your SQL knowledge.
The best way to improve is with a daily routine. To help you with this, we've built the daily quizzer. This sends a link to a new quiz straight to your inbox every weekday.
Here's a sample SQL quiz
Sample quiz (assume Oracle Database 11g Release 2 or higher)
You execute these commands:
create table qz_bricks ( brick_id integer not null primary key, colour varchar2(10) not null, shape varchar2(10) not null ); insert into qz_bricks values ( 1, 'red', 'cylinder' ); insert into qz_bricks values ( 2, 'red', 'cube' ); insert into qz_bricks values ( 3, 'blue', 'cylinder' ); insert into qz_bricks values ( 4, 'blue', 'cube' ); insert into qz_bricks values ( 5, 'green', 'cylinder' ); insert into qz_bricks values ( 6, 'green', 'cube' ); commit;
Which choices return one row per colour, so the query returns these rows?
COLOUR ---------- blue green red
Choices - Select all that apply.
select colour from qz_bricks order by colour;
select distinct colour from qz_bricks order by colour;
select unique colour from qz_bricks order by colour;
select colour from qz_bricks group by colour order by colour;
select max ( colour ) colour from qz_bricks group by shape order by colour;
No Choice Correct (Collapsible)
Practice your SQL skills using workouts
Our top workouts
Learn SQL with free courses
Oracle Dev Gym includes guided programs to help you learn SQL. These free, browser-based SQL classes include:
- Videos to teach you the concepts
- Live SQL tutorials for you to try writing real SQL
- A series of quizzes to test your understanding
All courses include a free certificate of completion.
Our top SQL courses
Start training now!
Whether you're starting from scratch or looking to top up your skills, Oracle Dev Gym is the perfect place to train your SQL muscles. Sign up for your free account and get started!