2020 Monthly SQL Practice Sets

Table of contents

1. 1. January 2020 SQL Challenge

   0/11

   During winter, especially in January, the black sky allows for good observation of the stars. You can see a lot of stars in the sky, but what are their names and properties? What constellations do they form?

   List of exercises Start now
   1. Introduction
      1. Introduction
      2. The table constellation
      3. The table star
   2. Tasks
      1. Task 1
      2. Task 2
      3. Task 3
      4. Task 4
      5. Task 5
      6. Task 6
      7. Task 7
      8. Congratulations!

2. 2. February 2020 SQL Challenge

   0/14

   February is when many couples celebrate Valentine's Day by going to restaurants. Help Lisa and Gary find a nice place to have pizza in Chicago.

   List of exercises Buy course
   1. Introduction
      1. Introduction
      2. The table restaurant
      3. The table pizza
      4. The table ingredient
      5. The table topping
      6. The table order_pizza
   2. Tasks
      1. Task 1
      2. Task 2
      3. Task 3
      4. Task 4
      5. Task 5
      6. Task 6
      7. Task 7
      8. Congratulations

3. 3. March 2020 SQL Challenge

   0/16

   March is a good month to plant the first flowers in a garden. Many people dream about having a flower garden and spending their free time in its beautiful surroundings.

   List of exercises Buy course
   1. Introduction
      1. Introduction
      2. category table
      3. color table
      4. flower table
      5. flower_color 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. April 2020 SQL Challenge

   0/14

   Many people want to create their own company. Starting is not easy, but your commitment and hard work might pay off with a successful business that you love.

   List of exercises Buy course
   1. Introduction
      1. Introduction
      2. Table model
      3. Table part
      4. Table service
      5. Table service_part
   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

5. 5. May 2020 SQL Challenge

   0/14

   Success in business is very important – but it’s not always easy to achieve. Knowing your industry is one thing, but having some SQL skills can also be helpful!

   List of exercises Buy course
   1. Introduction
      1. Introduction
      2. The cake table
      3. The ingredient table
      4. The cake_ingredient table
      5. The 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. Congratulations

6. 6. June 2020 SQL Challenge

   0/13

   The new owner of a company always needs some information. It allows them to implement new ideas, plan new products and services and improve what's already on offer. The more you know, the better you can manage!

   List of exercises Buy course
   1. Instruction
      1. Introduction
      2. The insurance table
      3. The client table
      4. The agent table
      5. The policy 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. Congratulations

7. 7. July 2020 SQL Challenge

   0/12

   Even if you are from the USA, you may not know all the facts about the 50 states. What rivers flow through the most states? What states have the most land area? How about population? Write the SQL queries for our tasks and you'll find the answers.

   List of exercises Buy course
   1. Introduction
      1. Introduction
      2. The state table
      3. The river table
      4. The river_state 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. Congratulations

8. 8. August 2020 SQL Challenge

   0/12

   First year in school isn't always easy. Help Mike prepare for going to the school.

   List of exercises Buy course
   1. Introduction
      1. Introduction
   2. Tasks
      1. Back-to-school gifts
      2. Checking the information in the system
      3. Housing assignment
      4. Mike's classmates
      5. Mike's teachers
      6. Mike's new friend
      7. Skipping school
      8. The science contest
      9. Mike needs to help a friend
      10. The end of the school year
      11. Congratulations

9. 9. September 2020 SQL Challenge

   0/12

   SQL databases are not just for IT specialists and businesses. Even actors can use data in databases to plan their career!

   List of exercises Buy course
   1. Introduction
      1. Introduction
      2. The genre table
      3. The movie table
      4. The person table
      5. The person_movie table
   2. Tasks
      1. Task 1
      2. Task 2
      3. Task 3
      4. Task 4
      5. Task 5
      6. Task 6
      7. Congratulations

10. 10. October 2020 SQL Challenge

    0/13

    Employers are looking for IT specialists, SQL database administrators, SQL developers, and other computer science positions. But which agencies offer the most IT jobs?

    List of exercises Buy course
    1. Introduction
       1. Introduction
       2. The agency table
       3. The category table
       4. The job table
       5. The candidate 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. Congratulations

11. 11. November 2020 SQL Challenge

    0/13

    2020 has produced a good market for cookbooks. Help Monica, a young chef, prepare her first cookbook!

    List of exercises Buy course
    1. Introduction
       1. Introduction
       2. The recipe table
       3. The ingredient table
       4. The recipe_ingredient table
       5. The preparation 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. Congratulations

12. 12. December 2020 SQL Challenge

    0/16

    December is a month when the evenings are long and people have more time to read. However, finding new books to read isn't always easy!

    List of exercises Buy course
    1. Introduction
       1. Introduction
       2. The category table
       3. The author table
       4. The owner table
       5. The book table
       6. The author_book 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