cookies-icon

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings. You can modify your browser settings on your own. For more information see our Privacy Policy.

Course

Basic

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

Lifetime access

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

limited to this course only

$29

Buy now

Want a better deal?

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

Get unlimited lifetime access to all 64 present and future courses

Save $420

Unlimited lifetime access

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

to all 64 present and future courses

$179

$599

70% OFF

Buy now
Full pricing
88

Interactive exercises

10 h

Estimated time

6692

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

Free

Paid content

0%

Course progress

0/88

Exercises completed

1.

Warm up: Selecting from one table

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

0/9
Start now

Reviews (0)

Average rating

4.77/5

☆☆☆☆☆
★★★★★

797 ratings

Details

5 stars

78%

4 stars

22%

3 stars

0%

2 stars

0%

1 stars

0%