Basic Track
SQL Practice in MySQL
Are you looking for interactive exercises in MySQL? We have a whole bunch of hands-on, beginner-friendly SQL challenges using SQL JOINs, aggregation, grouping, and subqueries. Take your skills to the next level!
4.89
5,670 Lerners enrolled
Free trial Yes
Certificate of completion Yes
Estimated time 20 h
Courses included 2
Skills you will gain
- Review SELECT statements.
- Practice the WHERE clause.
- Review SQL joins (INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, multiple JOIN, self-JOIN, and non-equi JOIN).
- Reinforce your knowledge of aggregation with GROUP BY and HAVING.
- Practice SQL subqueries, including correlated subqueries.
- Practice using a MySQL database.
Last reviews
Description
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! 😉
Track courses
-
SQL JOINs in MySQL92 Coding challenges Basic
Would you like to work with data from multiple tables? Or do you need to practice MySQL JOINs? We’ve prepared 92 exercises to help you learn all about JOINs in MySQL.
-
SQL Practice Set in MySQL88 Coding challenges Basic
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.
Get the Certificate of Competency in SQL
This certificate will confirm your practical SQL problem-solving skills
