Skip to main content
HomeSQLExploratory Data Analysis in SQL

Exploratory Data Analysis in SQL

4.3+
53 reviews
Intermediate

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

Start Course for Free
4 Hours16 Videos58 Exercises
107,220 LearnersTrophyStatement of Accomplishment

Create Your Free Account

GoogleLinkedInFacebook

or

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

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.
  1. 1

    What's in the database?

    Free

    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.

    Play Chapter Now
    What's in the database?
    50 xp
    Explore table sizes
    50 xp
    Count missing values
    100 xp
    Join tables
    100 xp
    The keys to the database
    50 xp
    Foreign keys
    50 xp
    Read an entity relationship diagram
    100 xp
    Coalesce
    100 xp
    Coalesce with a self-join
    100 xp
    Column types and constraints
    50 xp
    Effects of casting
    100 xp
    Summarize the distribution of numeric values
    100 xp
  2. 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.

    Play Chapter Now
  3. 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.

    Play Chapter Now

In the following tracks

Associate Data Analyst in SQLSQL for Business Analysts

Collaborators

Collaborator's avatar
Chester Ismay
Collaborator's avatar
Mona Khalil
Collaborator's avatar
Adrián Soto
Christina Maimone HeadshotChristina Maimone

Data Scientist, Northwestern University

Christina Maimone leads Research Data Services at Northwestern University with the IT Research Computing Services group. She enables innovative research by providing data science, programming, and software development support for researchers. Through consultations, project collaborations, user groups, and workshops, the Research Data Services team ensures researchers have the resources, services, and skills they need to overcome challenges in their work. Christina regularly uses R, Python, and SQL but enjoys the challenge of using a wide range of programs and languages in her work. She has a PhD in political science and an MS in statistics from Stanford.
See More

Don’t just take our word for it

*4.3
from 53 reviews
58%
26%
9%
4%
2%
Sort by
  • Ben M.
    5 months

    I thought this was a good class. There was a large amount of overlap with the prior classes in the same tracks. It requires a bit of extra effort to understand the “why” for the things it teaches you to do; in other words, the motivation is not always obvious, even though the content itself is golden.

  • Vladyslav H.
    6 months

    The most engaging (and challenging!) course in the Data Analyst in SQL track.

  • Albert F.
    9 months

    Is very hard but like it!

  • Edwin B.
    10 months

    Great course to build up your SQL skills

  • Ilies S.
    10 months

    Great course

"I thought this was a good class. There was a large amount of overlap with the prior classes in the same tracks. It requires a bit of extra effort to understand the “why” for the things it teaches you to do; in other words, the motivation is not always obvious, even though the content itself is golden."

Ben M.

"The most engaging (and challenging!) course in the Data Analyst in SQL track."

Vladyslav H.

"Is very hard but like it!"

Albert F.

FAQs

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

Create Your Free Account

GoogleLinkedInFacebook

or

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