Basic Course
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.
4.77
8,670 learners enrolled
Free trial Yes
Certificate of completion Yes
Time to complete 10 h
Coding challenges 88
Skills you will gain
- Select data from one table using different WHERE conditions
- Compute statistics for groups of rows using GROUP BY and the aggregate functions COUNT, AVG, SUM, MIN, and MAX
- Sort query results with ORDER BY
- Retrieve data from multiple tables using INNER JOIN, LEFT JOIN, FULL JOIN, and multiple joins
- Use self-joins
- Write non-correlated and correlated subqueries.
- Combine different SQL features in one query to solve challenging SQL problems.
- Practice your skills on over 88 interactive exercises.
Last reviews
Description
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
Course progress 0%
Exercises completed 0/88
-
Warm up: Selecting from one table
0/9Review the fundamentals of SQL. Practice using SELECT and WHERE to filter data in MySQL.
-
Aggregation and grouping
0/11Test your knowledge of GROUP BY and ORDER BY clauses by writing the queries in MySQL.
-
JOINs
0/32Practice using JOIN, LEFT JOIN, and non-equi JOIN in MySQL. Check your skills of working with multiple tables.
-
Subqueries
0/15Verify your knowledge of subqueries. Practice wiritng simple and correlated subqueries in MySQL.
-
MySQL Challenge
0/21Practice your SQL skills. Write MySQL queries which combine SELECT, WHERE, JOIN, GROUP BY, HAVING, ORDER BY and subqueries.
Get the Certificate of Competency in SQL
This certificate will confirm your practical SQL problem-solving skills
