SQL Practice in MySQL

SQL is a practical skill, and mastering it requires practice. This learning path offers two interactive MySQL practice courses. It is designed for SQL beginners and focuses on topics they often find challenging: joins, grouping, aggregation, and filtering rows.

We assume that you know the basics of MySQL and are looking for practice exercises to polish your skills. If you’re a beginner, we recommend starting with our course SQL Basics in MySQL.

SQL Practice in MySQL 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.

This track uses MySQL 8. However, users working with MySQL 5 and earlier can also take it. The features that are only available in MySQL 8 are clearly marked.

What Do You Need to Take This Track?

• A web browser
• An Internet connection
• Basic knowledge of SQL in MySQL (e.g. you’ve completed our SQL Basics in MySQL course)

This Track Will Help You:

• Review topics that frequently challenge SQL beginners:
  • SELECT statements.
  • The WHERE clause.
  • SQL joins (INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, multiple JOIN, self-JOIN, and non-equi JOIN).
  • Aggregation with GROUP BY and HAVING.
  • SQL subqueries, including correlated subqueries.
• Practice using a MySQL database.

Who Should Take This Track?

• People who want to consolidate their understanding of MySQL
• Anyone preparing for a MySQL job interview
• Students preparing for a MySQL test or exam
• Anyone looking for practice exercises using a MySQL database

What’s In It for Me?

• Practice at your own pace, from anywhere and at any time. Interactive, hands-on learning improves retention.
• Lifetime access to each course. When you purchase this track, 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. We offer student2student support, mentor2student support, and technical support. You can also ask our learning community for help through the Disqus tab. Or drop the course creators a line at contact@learnsql.com – we’ll be more than happy to answer! 😉