Advanced Track
Advanced SQL in MySQL 8
Have you mastered the basics of SQL? Are you ready for more? Learn modern SQL features like recursion and CTEs in MySQL 8. You’ll be writing sophisticated and effective queries in no time!
4.71
5,930 Lerners enrolled
Free trial Yes
Certificate of completion Yes
Estimated time 45 h
Courses included 3
Skills you will gain
- 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.
Last reviews
Description
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! 😉
Track courses
-
Window Functions in MySQL 8218 Coding challenges Advanced
Want to stay up to date with the latest MySQL features? MySQL window functions are essential for doing modern data analysis. Learn how to use them to take your analysis skills to the next level!
-
GROUP BY Extensions in MySQL27 Coding challenges Advanced
Do you want to perform multiple groupings in one query? Learn how to use GROUP BY extensions, such as ROLLUP in MySQL. Take the next step towards being a SQL expert!
-
Recursive Queries in MySQL 8114 Coding challenges Advanced
Do you want to be able to process trees and graphs in MySQL? Are you using MySQL 8 or higher? Learn how to write recursive queries and you’ll soon be producing concise and powerful SQL queries!
Get the Certificate of Competency in SQL
This certificate will confirm your practical SQL problem-solving skills
