Advanced SQL in MySQL 8

If you are serious about working professionally with MySQL databases, you should know the advanced SQL features introduced in MySQL 8. These include window functions, Common Table Expressions (CTEs), recursive queries, and GROUP BY extensions. They will allow you to perform complex computations using shorter SQL queries. If you want to perform deeper data analysis in MySQL, this set of interactive exercises is for you!

Window functions – first available in MySQL 8 – help you create rankings, find top-performing objects, compute running totals and moving averages, find year-to-year or month-to-month differences, etc. This will really power up your SQL reporting and help you find insights.

Common Table Expressions (CTEs) let you write readable and organized queries. Nowadays, data is processed in teams and it is important for everyone to be able to understand (and in some cases, change or adapt) queries written by others.

Recursive queries let you easily process hierarchical data like trees and graphs (e.g. employment hierarchies or organizational charts). Finally, GROUP BY extensions let you prepare multiple different statistics and different groupings in one query. Both make daily work easier.

These advanced SQL features are often omitted in traditional online MySQL courses. Our 3-course track gives you a unique opportunity to learn them in an interactive way.

The track is designed for intermediate and advanced SQL users interested in modern SQL. You should know the basics of SQL well: joining tables, working with GROUP BY and HAVING, using subqueries, and sorting data with ORDER BY. If these aren’t familiar concepts, start with our SQL Basics in MySQL course and come back here for more.

Advanced SQL in MySQL 8 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 and an Internet connection
• Basic knowledge of SQL (e.g. you’ve completed our SQL Basics in MySQL course)

This Track Will Teach You How To:

• Understand and apply window functions in MySQL, which makes writing complex queries easy.
• Learn when and how to use different ranking functions (RANK(), DENSE_RANK(), ROW_NUMBER()) to create ranking reports in MySQL.
• Compute running totals and running (cumulative) sums.
• Write complex reports using GROUP BY and CASE WHEN in MySQL.
• Differentiate and use ROLLUP, CUBE, and GROUPING SETS.
• Use Common Table Expressions to organize a long SQL query.
• Create recursive MySQL queries that process hierarchical data structures, such as trees and graphs.

Who Should Take This Track?

• Programmers, DBAs, and analysts who want to keep their knowledge of MySQL current.
• MySQL users who want to expand their skills beyond what is usually found in online courses and books.
• Anyone who knows fundamental MySQL and wants to learn its advanced features.

What’s In It for Me?

• The only fully interactive advanced MySQL 8 learning path on the internet. Three courses bring you the latest on MySQL’s
advanced features. Learn at your own pace, from anywhere and at any time. Interactive, hands-on learning improves retention.
• Lifetime access to each course. When you purchase the 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 this path, 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! 😉