SQL Practice Set in MySQL

Do you want to practice your MySQL skills? Here are 88 interactive SQL exercises that will test your knowledge. Start with simple one table SELECT statements and move on to more advanced topics.

Table of contents

10 free interactive coding challenges

Lifetime access


limited to this course only


Buy now

Want a better deal?


Get unlimited lifetime access to all 68 present and future courses

Save $450

Unlimited lifetime access


to all 68 present and future courses



75% OFF

Buy now

Interactive exercises

10 h

Estimated time


Users enrolled


797 ratings

We know how difficult it is to find good MySQL practice exercises, especially if you are a beginner. That’s why we created this online MySQL course. If you need to practice SQL to build up your confidence or prepare for an interview, this is for you.

Our interactive MySQL practice set will help you test your basic SQL knowledge and will show you where you need to improve. Its practical exercises will allow you to gain experience in creating realistic SQL queries using the world’s most popular database system: MySQL.

The MySQL practice set includes:

  • Simple SELECT queries
  • Different kinds of WHERE conditions
  • Aggregate functions (COUNT, SUM, AVG, MIN, and MAX)
  • Grouping and ordering results
  • Simple JOINs (i.e. querying from multiple tables using LEFT JOIN and RIGHT JOIN)
  • Self-joins and non-equi joins
  • Subqueries (simple subqueries, subqueries with multiple results, correlated subqueries, and using subqueries in the FROM and SELECT clauses).

The last two parts of the course comprise a special challenge that combines all of the above topics for a comprehensive review.

Each section starts with a brief review of the concept and syntax – you’ll learn everything you need to solve the task, even if you don’t remember this topic from your earlier studies. Next, several exercises let you practice this skill.

We assume that you’re familiar with the basics of SQL. If you’re a complete beginner, we recommend going through our SQL Basics in MySQL course first.

The course is interactive. You practice by writing real SQL code and solving exercises directly in your web browser. Our online platform runs your code and verifies your solution. You don't need to install any software on your computer.

Finally, SQL Practice Set in MySQL uses MySQL 8, but people familiar with MySQL 5 can also complete the course.

What Do You Need To Take This Course?

  • A web browser
  • Basic knowledge of SQL

This Course Will Help You Practice:

  • Selecting data from one table using different WHERE conditions
  • Computing statistics for groups of rows using GROUP BY and the aggregate functions COUNT, AVG, SUM, MIN, and MAX
  • Sorting query results with ORDER BY
  • Getting data from multiple tables using INNER JOIN, LEFT JOIN, FULL JOIN, and multiple joins
  • Using self-joins
  • Writing non-correlated and correlated subqueries.
  • Combining different SQL features in one query to solve challenging SQL problems.

Plus, you’ll get to practice your skills on over 88 interactive exercises.

Who Should Take This Course?

  • Data analysts who use MySQL
  • Students taking courses in relational databases
  • Beginner programmers interested in MySQL
  • Business database users who want to improve their MySQL querying skills
  • Anyone who finished the SQL Basics course or has equivalent knowledge
  • Anyone who wants to practice writing MySQL queries

What's In It for Me?

  • 88 interactive exercises. Learn at your own pace, from anywhere and at any time. Interactive, hands-on learning improves 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. After you successfully finish all of the exercises, you’ll get a downloadable PDF certificate to showcase your accomplishment.
  • 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 help. There are hints available in the exercises to help you if you get stuck. You can also ask our learning community for help through the Disqus tab. Or drop the course creators a line – we’ll be more than happy to answer! 😉

Table of contents


Paid content


Course progress


Exercises completed


Warm up: Selecting from one table

Review the fundamentals of SQL. Practice using SELECT and WHERE to filter data in MySQL.





Aggregation and grouping

Test your knowledge of GROUP BY and ORDER BY clauses by writing the queries in MySQL.






Practice using JOIN, LEFT JOIN, and non-equi JOIN in MySQL. Check your skills of working with multiple tables.



Exercises with artists, museums and their pieces of art

Exercises with the band members table

Exercises with tables of Japanese 100 Yen store

Exercises with employees, salaries and benefits



Verify your knowledge of subqueries. Practice wiritng simple and correlated subqueries in MySQL.





MySQL Challenge

Practice your SQL skills. Write MySQL queries which combine SELECT, WHERE, JOIN, GROUP BY, HAVING, ORDER BY and subqueries.



Challenge with artists

Challenge with orchestras

Reviews (0)

Average rating



797 ratings


5 stars


4 stars


3 stars


2 stars


1 stars