Do you like both sports competition and learning? We have something for you. Here are 119 interactive online SQL exercises to help you practice your skills. Challenge yourself, solve problems, and win the race to SQL proficiency.
A runner must run thousands of miles before reaching the championship level. Proper training is the basis of his/her success. It's the same with learning SQL – the best way to do it is through practice. Writing queries is, after all, a practical skill. However, we know that it is often difficult for beginners to find the right tasks and projects. That's why we created this course.
Here, you'll play with real track results from the Rio Olympics, 2019 IAAF World Championships in Doha, and 2017 IAAF World Championships in London. Our database contains all final results for the track events for men and women, starting with the 100-meter sprints, through middle and long distances, to marathons. In these data, you will find information such as the person with the best result for 100-meter sprints, the average speed for the 3000-meter events, the country with the most medals in track at the Rio Olympics, and many more. Are you interested in sports, athletics, or track? This exercise set is for you!
The 119 interactive exercises are grouped into different SQL topics: selecting from one table, JOINs, ORDER BY, GROUP BY, subqueries, and set operations. Each section of the course starts with a brief review of the SQL syntax needed to solve the exercises. This is followed by hands-on, real-world tasks specially designed to strengthen your SQL skills.
You don't have to do the entire course. If you want to practice specific topics, you can focus just on those. However, it's a good idea to make sure you have mastered the basics. In the course, you will practice topics that are often difficult for SQL beginners. Also, these are topics you might encounter during exams or job interviews. Make sure you know your SQL and test it in practice.
To get the most out of this course, you should know how to write simple SELECT queries, how to use the WHERE clause, what an SQL JOIN is, and how GROUP BY and HAVING work. You can learn all these in our SQL Basics course. After you finish it, come back here to practice what you have learned.
This course is interactive. You don't need to install or set anything up on your computer. You can start practicing SQL right away. You will solve the exercises in your web browser, immediately validating your queries. You will get instant feedback, thanks to which you will make quick progress in learning.
Practice selecting data from a single table
Join data from a few tables using different types of JOINs
Practice sorting the results of the queries
Test your knowledge of different aggregate functions, and how the GROUP BY clause works
Practice using different SQL features: how to handle NULLs, do mathematical operations, use subqueries and set operators
Challenge yourself with queries that use all the SQL features that were in this course!