Course

Advanced

Creating Basic SQL Reports in MySQL

Learn how to build MySQL reports that track and analyze key performance metrics with this interactive course.

Table of contents

10 free interactive coding challenges

Lifetime access

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

limited to this course only

$39

Buy now

Want a better deal?

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

Get unlimited lifetime access to all 68 present and future courses

Save $450

Unlimited lifetime access

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

to all 68 present and future courses

$149

$599

75% OFF

Buy now
Details
97

Interactive exercises

10 h

Estimated time

1491

Users enrolled

☆☆☆☆☆
★★★★★

193 ratings

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! 😉

Table of contents

Free

Paid content

0%

Course progress

0/97

Exercises completed

1.

Introduction

Get to know the data model and review some basic SQL concepts.

0/8

Introduction

Get to know the database

Summary

2.

Summarizing Data in SQL

Learn how to create simple yet useful business metrics.

0/18

Introduction

Providing detailed information and counting objects

Calculating metrics for multiple business objects

Understanding the difference between various count metrics

Summary

3.

Classifying Data with CASE WHEN and GROUP BY

Discover how to get metrics based on custom classifications.

0/19

Introduction

Custom classifications of business objects

Custom grouping of business objects

Custom counting of business objects

Summary

4.

Multi-level Aggregation

Learn how to construct reports that aggregate data on multiple levels.

0/19

Introduction

Basic multi-level aggregation

Multi-level aggregation in groups

Multi-level aggregation with custom classification

Three or more aggregation levels

Summary

5.

Multiple Metrics in One Report

Discover how to include multiple metrics in a single report.

0/19

Introduction

Multiple metrics for a single object

Metrics for two groups

Ratios and percentages

Global vs. specific metrics

Summary

6.

Comparing Groups in One Report

Find out even more about how you can compare groups in single SQL reports.

0/14

Introduction

Method One

Method Two

Method Three

Summary

Reviews (0)

Average rating

4.80/5

☆☆☆☆☆
★★★★★

193 ratings

Details

5 stars

83%

4 stars

16%

3 stars

1%

2 stars

0%

1 stars

0%