メインコンテンツへスキップ

コース

SQLでのレポーティング

中級スキルレベル

更新日 2025/11

SQLでレポートやダッシュボードを自作し、データ探索・クリーニング・検証のスキルを磨きましょう。

コースを無料で開始

SQLReporting

4時間

15 ビデオ

54 演習

4,450 XP

38,768

修了証明書

何千もの企業の従業員が支持

チームのトレーニングを担当していますか？

Businessをお試しください

コース説明

前提条件

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

チャプターを開始

SQLでのレポーティング

コース完了

修了証明書を取得

この修了書をLinkedInや履歴書、CVに追加しましょう
ソーシャルメディアや人事評価で共有しましょう今すぐ登録

19百万人を超える学習者と共にSQLでのレポーティングを始めましょう！

DataCamp for Mobileでデータスキルを磨きましょう

モバイルコースと毎日の 5 分間のコーディングチャレンジで、外出先でも進歩できます。