2021 Monthly SQL Practice Sets - Basic

Table of contents

1. 1. February 2021 SQL Challenge

   0/14

   Mike owns and wants to grow a car rental business. Help him gather important information using your SQL skills.

   List of exercises Start now
   1. Introduction
      1. Introduction
      2. The color table
      3. The customer table
      4. The car table
      5. The rental table
   2. Tasks
      1. Task 1
      2. Task 2
      3. Task 3
      4. Task 4
      5. Task 5
      6. Task 6
      7. Task 7
      8. Task 8
      9. Congratulations

2. 2. April 2021 SQL Challenge

   0/15

   Rita and Richard want to improve their apartment rental agency. Can you help them gather the information they need with your SQL chops?

   List of exercises Buy course
   1. Introduction
      1. Introduction
      2. The client table
      3. The employee table
      4. The apartment table
      5. The rental table
      6. Task 1
      7. Task 2
      8. Task 3
      9. Task 4
      10. Task 5
      11. Task 6
      12. Task 7
      13. Task 8
      14. Task 9
      15. Congratulations

3. 3. June 2021 SQL Challenge

   0/16

   Jennifer is a veterinarian who runs a dog sitting service in different cities. She's always interested in new business projects. Use SQL to help her see if there are enough potential clients for her ideas.

   List of exercises Buy course
   1. Introduction
      1. Introduction
      2. The owner table
      3. The dog_sitter table
      4. The dog table
      5. The care table
   2. Tasks
      1. Task 1
      2. Task 2
      3. Task 3
      4. Task 4
      5. Task 5
      6. Task 6
      7. Task 7
      8. Task 8
      9. Task 9
      10. Task 10
      11. Congratulations

4. 4. August 2021 SQL Challenge

   0/16

   Martin runs a travel agency in the U.S. state of Illinois. Use SQL to help him get to know his clients and the attractions.

   List of exercises Buy course
   1. Introduction
      1. Introduction
      2. The client table
      3. The category table
      4. The city_to_visit table
      5. The attraction table
      6. The client_attraction table
   2. Tasks
      1. Task 1
      2. Task 2
      3. Task 3
      4. Task 4
      5. Task 5
      6. Task 6
      7. Task 7
      8. Task 8
      9. Task 9
      10. Congratulations

5. 5. October 2021 SQL Challenge

   0/16

   Dean runs a business in Cleveland. He would like to know about his customers and their needs. Can you help them gather the information he needs by using SQL?

   List of exercises Buy course
   1. Introduction
      1. Introduction
      2. The customer table
      3. The category table
      4. The furniture table
      5. The furniture_order table
      6. The order_item table
   2. Tasks
      1. Task 1
      2. Task 2
      3. Task 3
      4. Task 4
      5. Task 5
      6. Task 6
      7. Task 7
      8. Task 8
      9. Task 9
      10. Congratulations

6. 6. December 2021 SQL Challenge

   0/16

   Scott is a board game enthusiast who has decided to run his own e-store. He needs your help to decide what games and genres are popular, which customers are the most loyal, etc.

   List of exercises Buy course
   1. Introduction
      1. Introduction
      2. The board games database and the customer table
      3. The boardgame table
      4. The delivery table
      5. The purchase table
      6. The game_purchase table
   2. Tasks
      1. Task 1
      2. Task 2
      3. Task 3
      4. Task 4
      5. Task 5
      6. Task 6
      7. Task 7
      8. Task 8
      9. Task 9
      10. Congratulations

Get the Certificate of Competency in SQL

This certificate will confirm your practical SQL problem-solving skills

Obtain the Certificate Learn more