课程

Reporting in SQL

中级技能水平

更新时间 2025年11月

Learn how to build your own SQL reports and dashboards, plus hone your data exploration, cleaning, and validation skills.

免费开始课程

SQLReporting

4小时

15 视频

54 道练习

4,450 XP

38,768

成就证明

深受数千家公司学习者的喜爱

需要团队培训？

企业版试用

课程描述

Master SQL Reporting

Build clear and valuable SQL reports and dashboards, and hone your skills in data cleaning and validation.

In this course, you will apply all the SQL concepts and functions you have learned in previous courses to build your very own dashboard. You will work on an Olympics database to learn about data exploration, data manipulation, data cleaning and validation, and performing complex calculations.

The first chapter aims to get you familiar with the dataset you’ll use, covering some of the essentials you'll need to explore the data properly. Here you will learn how to use ER diagrams and data exploration techniques to get a solid understanding of the data.

Practice Building SQL Reports Using Real Datasets

Next, you’ll learn to build more complex SQL queries to help you explore the data in more detail. The step-by-step approach helps you understand why complex queries require more thought and how they can help you build reports.

Once you get a hang of reporting in SQL, you will learn how to clean and validate SQL data, ensuring our reports are accurate and interpretable.

Develop Your SQL Database Skills

Learn to perform complex calculations using window functions and layered calculations in the final chapter. You will gain hands-on experience building two advanced calculations in particular: the percent of a total calculation and the performance index calculation.

This SQL course is perfect for anyone who will be commonly pulling data from databases and is a great complement for those who use R or Python for data science. This course is part of the SQL for Business Analysts Track and is essential for those who are planning to complete a Data Science or Data Analysis certification with DataCamp.

先决条件

Data Manipulation in SQL

1

Exploring the Olympics Dataset

Before you can start building out reports to answer specific questions, you should get familiar with the data. In this chapter, you will learn how to use E:R diagrams and data exploration techniques to get a solid understanding of the data to better answer business-related questions.

Identifying the base report

Building the base report

Athletes vs events by sport

The Olympics dataset

Planning queries with an E:R diagram

Age of oldest athlete by region

Number of events in each sport

Exploring our data

Exploring summer_games

Validating our query

Report 1: Most decorated summer athletes

2

Creating Reports

Queries can get large, fast. It's important to take a logical approach when building more complicated queries. In this chapter, you will take a step-by-step approach to plan and build a complex query that requires you to combine tables in multiple ways and create different types of fields.

Planning the query

Planning the SELECT statement

Planning the filter

Combining tables

JOIN then UNION query

UNION then JOIN query

Creating custom fields

CASE statement refresher

BMI bucket by sport

Troubleshooting CASE statements

Filtering and finishing touches

Filtering with a JOIN

Filtering with a subquery

Report 2: Top athletes in nobel-prized countries

3

Cleaning & Validation

Although it would be nice, data in the real-world is rarely stored in an ideal way. Simply put: data can get messy. In chapter 3, you will learn how to deal with this messy data by fixing data type issues, cleaning messy strings, handling nulls, and removing duplication.

Converting data types

Identifying data types

Interpreting error messages

Using date functions on strings

Cleaning strings

String functions

Replacing and removing substrings

Fixing incorrect groupings

Dealing with nulls

Filtering out nulls

Fixing calculations with coalesce

Report duplication

Identifying duplication

Fixing duplication through a JOIN

Report 3: Countries with high medal rates

4

Complex Calculations

The value of reporting really shows when presenting not-so-obvious insights through complex calculations. In this chapter, you will learn how to build more complicated fields by leveraging window functions and layered calculations. You will gain hands-on experience building two advanced calculations in particular: the percent of a total calculation and the performance index calculation.

Building complex calculations

Testing out window functions

Average total country medals by region

Most decorated athlete per region

Comparing groups

Volume vs efficiency metrics

Percent of gdp per country

GDP per capita performance index

Comparing dates

Month-over-month comparison

Week-over-week comparison

Report 4: Tallest athletes and % GDP by region

Course summary

Reporting in SQL

课程完成

获得成就证明

将此证书添加到您的 LinkedIn 档案、简历或履历中
在社交媒体和绩效评估中分享立即注册

加入超过19百万学习者，今天就开始Reporting in SQL！

通过 DataCamp for Mobile 提升您的数据技能

随时随地通过我们的移动课程和每日 5 分钟编程挑战提升技能。