Basic Course
2020 Monthly SQL Practice Sets
Practice SQL queries with all coding challenges from 2020!
4.83
19,246 learners enrolled
Free trial Yes
Certificate of completion Yes
Time to complete 12 h
Coding challenges 160
Skills you will gain
- Solve real-life SQL problems using practical scenarios.
- Enhance query-writing skills with progressively challenging exercises.
- Apply SQL to diverse fields like astronomy, food service, and business.
- Use SQL for data management tasks such as organizing and analyzing datasets.
- Improve problem-solving abilities through a variety of SQL challenges.
- Practice SQL within different contexts to gain a well-rounded understanding of its applications.
Last reviews
Description
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!
What's in it for me?
- 12 great SQL Challenges, all in one course: Practice SQL, and have fun doing over 160 SQL exercises.
- Learn by doing: Get hands-on practice with our real code editor, real data sets, and real-life problems.
- Online certification: After completing the course, you will receive a certificate that you can publish on your LinkedIn profile.
- 30-day money-back guarantee: If you're not satisfied with this course, tell us within 30 days of purchase, and you’ll get a full refund.
- Trusted support system: Our course comes with access to our resource base and technical support. You can also join our learning community and participate in on-task discussions.
- Hints and more: If you get stuck, you can use the included exercise hints. Or, use the Discuss tab to ask questions and share insights with other members of the LearnSQL community. You can also drop us a line at contact@learnsql.com, and we'll be more than happy to help!
Requirements
- Basic knowledge of SQL (we recommend doing the SQL Basics course first)
- A web browser and an internet connection
Who should take this learning path?
- Anyone who wants to practice SQL
- Students taking courses in relational databases
- Beginner programmers looking for interesting SQL challenges
- Business database users who want to improve their skills
- You!
Table of contents
Course progress 0%
Exercises completed 0/160
-
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?
-
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.
-
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.
-
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.
-
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!
-
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!
-
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.
-
First year in school isn't always easy. Help Mike prepare for going to the school.
-
SQL databases are not just for IT specialists and businesses. Even actors can use data in databases to plan their career!
-
Employers are looking for IT specialists, SQL database administrators, SQL developers, and other computer science positions. But which agencies offer the most IT jobs?
-
2020 has produced a good market for cookbooks. Help Monica, a young chef, prepare her first cookbook!
-
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!
Get the Certificate of Competency in SQL
This certificate will confirm your practical SQL problem-solving skills