cookies-icon

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings. You can modify your browser settings on your own. For more information see our Privacy Policy.

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

Lifetime access

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

limited to this course only

$29

Buy now

Want a better deal?

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

Get unlimited lifetime access to all 64 present and future courses

Save $420

Unlimited lifetime access

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

to all 64 present and future courses

$179

$599

70% OFF

Buy now
Full pricing
97

Interactive exercises

10 h

Estimated time

1310

Users enrolled

☆☆☆☆☆
★★★★★

192 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
Start now

3.

Classifying Data with CASE WHEN and GROUP BY

Discover how to get metrics based on custom classifications.

0/19

6.

Comparing Groups in One Report

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

0/14

Reviews (0)

Average rating

4.80/5

☆☆☆☆☆
★★★★★

192 ratings

Details

5 stars

83%

4 stars

16%

3 stars

1%

2 stars

0%

1 stars

0%