Skip to main content

Exploratory Data Analysis in SQL for Absolute Beginners

Learn the basics of exploring new datasets using SQL.
Feb 7, 2023
Code along with us onCode Along

View datasetRead paper

In this live codealong, you will be introduced to the basics of exploring new datasets using SQL. This session explores data on climate change adaptations in the water industry in Africa. You will calculate summary statistics and draw visualizations to generate insights. After the codealong, you will get access to a solution notebook to use as a future reference!

Learning by doing is encouraged, and you can follow along using DataLab. All you need is a DataCamp account. Note that members of some enterprise groups do not yet have access to use DataLab. Create a free DataCamp account with your personal email address to follow along.

Additional resources

Key takeaways

  • How to use SQL to manipulate data and calculate summary statistics.

  • How to use Workspace no-code visualizations to draw plots.

  • How exploratory data analysis is used to get insights about your data.

Topics
Related

code-along

Exploratory Data Analysis in R for Absolute Beginners

Learn the basics of exploring new datasets in R.
Ishmael Rico's photo

Ishmael Rico

code-along

SQL for Absolute Beginners

Start from the very basics of what SQL is and why it's essential, move through key components such as retrieving data from databases, manipulation of data, and basic SQL queries.
Adel Nehme's photo

Adel Nehme

code-along

A Beginner's Guide to Data Analysis with SQL

In this session, DataCamp's VP of Media Adel Nehme & co-host of the DataFramed podcast, shows you how to get started with SQL.
Adel Nehme's photo

Adel Nehme

code-along

Getting Started in SQL

Learn how to write basic queries in SQL and find answers to business questions.
Kelsey McNeillie's photo

Kelsey McNeillie

code-along

Exploratory Data Analysis in Python for Absolute Beginners

In this live codealong, you will learn the basics of exploring new datasets
Filip Schouwenaars's photo

Filip Schouwenaars

code-along

Free Trial Performance Analysis in SQL

Learn how to use SQL to analyze marketing data for a free trial of a product
John Brazier-Beckett's photo

John Brazier-Beckett

See MoreSee More