Advanced Course
Creating Basic SQL Reports in MySQL
Learn how to build MySQL reports that track and analyze key performance metrics with this interactive course.
4.80
1,511 learners enrolled
Free trial Yes
Certificate of completion Yes
Time to complete 10 h
Coding challenges 97
Skills you will gain
- Use popular SQL aggregate functions (COUNT() and SUM()) to summarize data
- Create custom classifications of objects using the CASE syntax
- Use classifications to group objects in the GROUP BY clause
- Calculate average values and minimum/maximum averages in MySQL
- Organize long queries in MySQL
- Include multiple metrics in a single MySQL report
- Calculate ratios and percentages in MySQL
- Compare global and granular metrics in MySQL
- Compare different business groups in a single report
- Use common table expressions (CTEs) in MySQL 8
Last reviews
Table of contents
Course progress 0%
Exercises completed 0/97
-
Introduction
0/8Get to know the data model and review some basic SQL concepts.
-
Summarizing Data in SQL
0/18Learn how to create simple yet useful business metrics.
-
Classifying Data with CASE WHEN and GROUP BY
0/19Discover how to get metrics based on custom classifications.
-
Multi-level Aggregation
0/19Learn how to construct reports that aggregate data on multiple levels.
-
Multiple Metrics in One Report
0/19Discover how to include multiple metrics in a single report.
-
Comparing Groups in One Report
0/14Find out even more about how you can compare groups in single SQL reports.
Get the Certificate of Competency in SQL
This certificate will confirm your practical SQL problem-solving skills
Description
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.
What Do You Need to Take This Course?
- A web browser and an Internet connection.
- Knowledge of basic SQL concepts, such as what’s in our SQL Basics in MySQL course.
This Course Will Teach You How To:
- Use popular SQL aggregate functions (COUNT() and SUM()) to summarize data
- Create custom classifications of objects using the CASE syntax
- Use classifications to group objects in the GROUP BY clause
- Calculate average values and minimum/maximum averages in MySQL
- Organize long queries in MySQL
- Include multiple metrics in a single MySQL report
- Calculate ratios and percentages in MySQL
- Compare global and granular metrics in MySQL
- Compare different business groups in a single report
- Use common table expressions (CTEs) in MySQL 8
Who Should Take This Course?
- Analysts who want to create meaningful reports in MySQL
- Beginner data science enthusiasts working with MySQL
- Business analysts who want to use MySQL to generate business metrics
- Anyone with basic MySQL knowledge who wants to learn more
- Anyone interested in a career in reporting using MySQL
What's in It for Me?
- 97 interactive exercises. Learn at your own pace, from anywhere and at any time. Interactive, hands-on learning improves retention.
- Lifetime access to the course. When you purchase the course, 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. You can also ask our learning community for help through the Disqus tab. Or drop the course creators a line – we’ll be more than happy to answer! 😉