Course
AdvancedLearn how to build MySQL reports that track and analyze key performance metrics with this interactive course.
Creating Basic SQL Reports in MySQL is perfect for people who know SQL basics and would like to master writing complex queries. The skills from this course are essential for data analysts and others who track business metrics with MySQL. This could be a turning point in your business development or a significant advance in your career as an analyst.
In this course, you’ll learn the most common types of basic SQL reports and build them step by step. To do this, you’ll work with data from an online store. The entities in a store database – customers, products, orders, and transactions – are present in most business models. Even if you work in a completely different business domain, much of the data you’ll work with is similar to what’s in a store model. Some of the SQL queries that you will write could be applied (with some small modifications) in your own projects.
Creating Basic SQL Reports in MySQL starts with reviewing how to use popular SQL aggregate functions like COUNT() and SUM(). You'll count business objects and calculate total amounts.
Next, you’ll learn to classify your data using CASE WHEN and the GROUP BY clause. As we consider the intricacies of GROUP BY, we'll also review a few typical beginner mistakes and show how you can avoid them.
Finally, we'll talk about comparing different business groups in a single report. You’ll learn three different methods, so you can pick the one that best matches each project’s requirements.
Each of the sections comes with extensive practice material, which means you'll write lots of SQL code on your own. At the end of each part, you'll be challenged with a short summary quiz.
Creating Basic SQL Reports 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 course uses MySQL 8. However, anyone working with MySQL 5 and earlier can also take the course. The features that are only available in MySQL 8 are clearly marked.
Course progress
Exercises completed
1.
Get to know the data model and review some basic SQL concepts.
2.
Learn how to create simple yet useful business metrics.
3.
Discover how to get metrics based on custom classifications.
4.
Learn how to construct reports that aggregate data on multiple levels.
5.
Discover how to include multiple metrics in a single report.
6.
Find out even more about how you can compare groups in single SQL reports.