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.

You need an Oracle Account to join Oracle Dev Gym. Click here to sign up.

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' );


Which choices return one row per colour, so the query returns these rows?


Choices - Select all that apply.

Choice 1

  select colour
  from   qz_bricks
  order  by colour;

Choice 2

  select distinct colour
  from   qz_bricks
  order  by colour;

Choice 3

  select unique colour
  from   qz_bricks
  order  by colour;

Choice 4

  select colour
  from   qz_bricks
  group  by colour
  order  by colour;

Choice 5

  select max ( colour ) colour
  from   qz_bricks
  group  by shape
  order  by colour;

No Choice Correct (Collapsible)

No choice is correct.

Practice your SQL skills using workouts

To help you enhance your SQL muscles, we've built targeted SQL workouts. These training sessions have a series of quizzes focussed on a specific aspect of the language. This helps you get to grips with the details of each feature.

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!