コース
SQLで学ぶ探索的データ分析
中級スキルレベル
更新日 2026/01
SQLExploratory Data Analysis4時間16 ビデオ57 演習4,650 XP180K+修了証明書
無料アカウントを作成
Googleで続行その他のオプションを表示または
何千もの企業の従業員が支持
チームのトレーニングを担当していますか？
Businessをお試しくださいコース説明
前提条件
Data Manipulation in SQL1
What's in the Database?
Start exploring a database by identifying the tables and the foreign keys that link them. Look for missing values, count the number of observations, and join tables to understand how they're related. Learn about coalescing and casting data along the way.
2
Summarizing and Aggregating Numeric Data
You'll build on functions like min and max to summarize numeric data in new ways. Add average, variance, correlation, and percentile functions to your toolkit, and learn how to truncate and round numeric values too. Build complex queries and save your results by creating temporary tables.
3
Exploring Categorical Data and Unstructured Text
Text, or character, data can get messy, but you'll learn how to deal with inconsistencies in case, spacing, and delimiters.
Learn how to use a temporary table to recode messy categorical data to standardized values you can count and aggregate. Extract new variables from unstructured text as you explore help requests submitted to the city of Evanston, IL.
4
Working with Dates and Timestamps
What time is it? In this chapter, you'll learn how to find out. You'll aggregate date/time data by hour, day, month, or year and practice both constructing time series and finding gaps in them.
SQLで学ぶ探索的データ分析
コース完了 19百万人を超える学習者と共にSQLで学ぶ探索的データ分析を始めましょう！
無料アカウントを作成
Googleで続行その他のオプションを表示または
DataCamp for Mobileでデータスキルを磨きましょう
モバイル コースと毎日の 5 分間のコーディング チャレンジで、外出先でも進歩できます。