Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings. You can modify your browser settings on your own. For more information see our Privacy Policy.
Course
BasicPractice SQL queries with all coding challenges from 2020!
Take the SQL challenge! Solve everyday problems, and have fun while doing it!
Practice SQL like never before. We have collected all of our Monthly SQL Challenges published in 2020 into one SQL course. With over 160 interactive exercises in one place, you can keep your SQL skills fresh by practicing SQL in real-life scenarios.
We publish SQL Challenges every month on LearnSQL.com. These mini-courses have 5 to 10 SQL exercises. They are perfect for practicing your newly acquired knowledge and going beyond our course offerings.
We broke the convention of ordinary exercises to give you more unique tasks, each related to a specific topic. You will have the opportunity to play the role of a snowboarder looking for the perfect destination for the holidays, a stargazer, a car repair shop owner, and a bakery owner.
You can also practice SQL while traveling around the USA, looking for the perfect pizza place in Chicago, or designing a garden. We have created 12 different topics in which SQL can be unexpectedly helpful. Check out what else we came up with!
Some SQL Challenges will be easier. Others are more difficult. However, do not be intimidated. If you know the basics of SQL (e.g., you have completed our SQL Basics course), you will surely do well.
The exercises are designed to be challenging but doable for beginners. Remember, if you have a problem with something, you can always get hints or support. When you encounter difficulties, you will learn what you need to focus on and go over again.
What are you waiting for? Practice SQL, and have fun!
Course progress
Exercises completed
1.
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?
2.
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.
3.
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.
4.
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.
5.
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!
6.
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!
7.
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.
8.
First year in school isn't always easy. Help Mike prepare for going to the school.
9.
SQL databases are not just for IT specialists and businesses. Even actors can use data in databases to plan their career!
10.
Employers are looking for IT specialists, SQL database administrators, SQL developers, and other computer science positions. But which agencies offer the most IT jobs?
11.
2020 has produced a good market for cookbooks. Help Monica, a young chef, prepare her first cookbook!
12.
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!