Basic Course
Basic SQL Practice: Run Track Through Queries!
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.
4.77
4,278 learners enrolled
Free trial Yes
Certificate of completion Yes
Time to complete 11 h
Coding challenges 119
Skills you will gain
- Write simple SELECT queries to get data from a single table.
- Filter data with WHERE, using different number comparison operators, text patterns, and Boolean conditions, while combining them with AND, OR, and NOT.
- Sort query results with ORDER BY, using ASCending and DESCending order.
- Combine data from multiple tables using JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
- Write challenging queries with JOIN, such as multiple JOINs, self-joins, and non-equi JOINs.
- Group data with GROUP BY and computing statistics using aggregate functions COUNT(), AVG(), SUM(), MIN(), and MAX().
- Use mathematical functions to perform simple calculations in SQL.
- Work with NULL in SQL queries using IS NULL and IS NOT NULL operators.
- Write subqueries, including correlated subqueries.
- Merge query results using set operations UNION, INTERSECT, and EXCEPT.
- Combine all basic SQL features in a challenging advanced queries section.
Last reviews
Description
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.
What's in it for me?
- 119 interactive exercises to practice writing SQL queries: practice at your own pace, from anywhere and at any time, with interactive hands-on exercises for improved retention.
- Lifetime access to the course: when you purchase the course, you'll get instant personal access to all of its content.
- Certificate of completion: you'll get a downloadable PDF certificate to showcase your accomplishment.
- A 30-day, money-back guarantee: if you're not satisfied with the quality of the course, you can get a refund within 30 days of your purchase.
- Hints and support: you can ask questions and share insights with other members of the community through the Discuss tab (you can also drop us a line at contact@learnsql.com, and we'll be more than happy to answer!).
What Are the Requirements?
- Knowledge of basic SQL (for example, take this after completing our SQL Basics course).
- Web browser.
What Will I Practice in This Course?
- Writing simple SELECT queries to get data from a single table.
- Filtering data with WHERE, using different number comparison operators, text patterns, and Boolean conditions, while combining them with AND, OR, and NOT.
- Sorting query results with ORDER BY, using ASCending and DESCending order.
- Combining data from multiple tables using JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
- Writing challenging queries with JOIN, such as multiple JOINs, self-joins, and non-equi JOINs.
- Grouping data with GROUP BY and computing statistics using aggregate functions COUNT(), AVG(), SUM(), MIN(), and MAX().
- Using mathematical functions to perform simple calculations in SQL.
- Working with NULL in SQL queries using IS NULL and IS NOT NULL operators.
- Writing subqueries, including correlated subqueries.
- Merging query results using set operations UNION, INTERSECT, and EXCEPT.
- Combining all basic SQL features in a challenging advanced queries section.
Who Should Take This Course?
- SQL beginners who want to practice their SQL skills.
- People preparing for interviews for jobs that require SQL.
- Students preparing to take SQL and database exams.
- Store owners and managers who want to start using the power of databases.
- Anyone who is looking for SQL practice problems.
Table of contents
Course progress 0%
Exercises completed 0/119
-
One table queries
0/26Practice selecting data from a single table
-
JOINs
0/14Join data from a few tables using different types of JOINs
-
ORDER BY
0/14Practice sorting the results of the queries
-
Aggregate functions and GROUP BY
0/27Test your knowledge of different aggregate functions, and how the GROUP BY clause works
-
Other SQL Features
0/22Practice using different SQL features: how to handle NULLs, do mathematical operations, use subqueries and set operators
-
Challenge
0/16Challenge yourself with queries that use all the SQL features that were in this course!
Get the Certificate of Competency in SQL
This certificate will confirm your practical SQL problem-solving skills
