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.
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:
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.
Plus, you’ll get to practice your skills on over 88 interactive exercises.
Review the fundamentals of SQL. Practice using SELECT and WHERE to filter data in MySQL.
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.
Verify your knowledge of subqueries. Practice wiritng simple and correlated subqueries in MySQL.
Practice your SQL skills. Write MySQL queries which combine SELECT, WHERE, JOIN, GROUP BY, HAVING, ORDER BY and subqueries.