Skip to main content

course

Exploratory Data Analysis in SQL

Intermediate

4.4+

Updated 12/2024

Learn how to explore what's available in a database: the tables, relationships between them, and data stored in them.

Start course for free

Included for FreePremium or Teams

SQLExploratory Data Analysis4 hours16 videos57 exercises4,650 XP132,206Statement of Accomplishment

Create Your Free Account

Google LinkedIn Facebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

Training 2 or more people?

Try DataCamp for Business

Loved by learners at thousands of companies

Course Description

You have access to a database. Now what do you do? Building on your existing skills joining tables, using basic functions, grouping data, and using subqueries, the next step in your SQL journey is learning how to explore a database and the data in it. Using data from Stack Overflow, Fortune 500 companies, and 311 help requests from Evanston, IL, you'll get familiar with numeric, character, and date/time data types. You'll use functions to aggregate, summarize, and analyze data without leaving the database. Errors and inconsistencies in the data won't stop you! You'll learn common problems to look for and strategies to clean up messy data. By the end of this course, you'll be ready to start exploring your own PostgreSQL databases and analyzing the data in them.

Prerequisites

Data Manipulation in SQL

1

What's in the Database?

What's in the database?

Explore table sizes

Count missing values

Join tables

The keys to the database

Foreign keys

Read an entity relationship diagram

Column types and constraints

Effects of casting

Summarize the distribution of numeric values

2

Summarizing and Aggregating Numeric Data

Numeric data types and summary functions

Explore with division

Summarize numeric columns

Summarize group statistics

Exploring distributions

Generate series

More summary functions

Correlation

Mean and Median

Creating temporary tables

Create a temp table

Create a temp table to simplify a query

Insert into a temp table

3

Exploring Categorical Data and Unstructured Text

Character data types and common issues

Count the categories

Spotting character data problems

Cases and spaces

Exploring unstructured text

Splitting and concatenating text

Concatenate strings

Split strings on a delimiter

Shorten long strings

Strategies for multiple transformations

Create an "other" category

Group and recode values

Create a table with indicator variables

4

Working with Dates and Timestamps

Date/time types and formats

Date comparisons

Date arithmetic

Completion time by category

Date/time components and aggregation

Variation by day of week

Date truncation

Aggregating with date/time series

Find missing dates

Custom aggregation periods

Monthly average with missing dates

Time between events

Longest gap

Exploratory Data Analysis in SQL

Course
Complete

Earn Statement of Accomplishment

Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review

Included withPremium or Teams

Don’t just take our word for it

*4.4

from 64 reviews

66%

22%

8%

3%

2%

Highest to Lowest
Lowest to Highest
Most recent
Top reviews

Charbel B.

2 months

Good comprehensive introduction to SQL

Alex M.

2 months

Amazing course

Marek W.

2 months

Very interesting but last tasks was to hard.

James K.

4 months

Excellent course

Roman G.

4 months

Excellent! Thanks a lot!

"Good comprehensive introduction to SQL"

Charbel B.

"Amazing course"

Alex M.

"Very interesting but last tasks was to hard."

Marek W.

FAQs

Join over 15 million learners and start Exploratory Data Analysis in SQL today!

Create Your Free Account

Google LinkedIn Facebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.