Skip to main content
HomeCode-alongsData Analysis

Exploratory Data Analysis in SQL for Absolute Beginners

Learn the basics of exploring new datasets using SQL.
Feb 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
Introducing datalab

blog

Introducing DataLab

DataCamp is launching DataLab, an AI-enabled data notebook to make it easier and faster than ever before to go from data to insight. Read on to learn more about what makes DataLab unique and our path towards it.
Filip Schouwenaars's photo

Filip Schouwenaars

3 min

blog

The 4 Best Data Analytics Bootcamps in 2024

Discover the best data analytics bootcamps in 2024, discussing what they are, how to choose the best bootcamp, and you can learn.

Kevin Babitz

5 min

blog

A Guide to Corporate Data Analytics Training

Understand the importance of corporate data analytics training in driving business success. Learn about key building blocks and steps to launch an effective training initiative tailored to your organization's needs.

Kevin Babitz

6 min

podcast

50 Years of SQL with Don Chamberlin, Computer Scientist and Co-Inventor of SQL

Richie and Don explore the early development of SQL, the commercialization and adoption of SQL, how it became standardized, how it evolved and spread via open source, the future of SQL through NoSQL and SQL++ and much more.
Richie Cotton's photo

Richie Cotton

36 min

code-along

Full Stack Data Engineering with Python

In this session, you'll see a full data workflow using some LIGO gravitational wave data (no physics knowledge required). You'll see how to work with HDF5 files, clean and analyze time series data, and visualize the results.
Blenda Guedes's photo

Blenda Guedes

code-along

Getting Started With Data Analysis in Alteryx Cloud

In this session, you'll learn how to get started with the Alteryx AI Platform by performing data analysis using Alteryx Designer Cloud.
Joshua Burkhow's photo

Joshua Burkhow

See MoreSee More