Skip to main content

Live Training: Exploring Astronaut Activities in SQL

Slides — including links to notebooks


In this live training you will use string cleaning to process and analyze a database containing information on astronaut extra vehicular activities (EVAs).

You will start by exploring the data, identifying potential issues with the columns that contain text. Next, Justin will take you through the steps necessary to clean up the data so you can draw insights the types and participants of EVAs!

Key Learnings

  • Identify potential issues with text data using SQL

  • Reformat and clean up messy text data

  • Basics of regular expressions and how they can be used to categorize data

Follow along with this training in Workspace.

Justin Saddlemyer Headshot
Justin Saddlemyer

Workspace Architect at DataCamp

Recommended Content

Live Training: Analyzing Streaming Service Content in SQL

Learn to join data from multiple sources, and create no-code visualizations.


PySpark SQL Basics Cheat Sheet

Your handy companion to Apache Spark DataFrames in Python with code samples.


Live Training: Analyzing Olympics Data with SQL and Python

Learn how to load data from different sources and perform exploratory analyses.


Hands-on learning experience

Companies using DataCamp achieve course completion rates 6X higher than traditional online course providers

Learn More

Upskill your teams in data science and analytics

Learn More

Join 2,500+ companies and 80% of the Fortune 1000 who use DataCamp to upskill their teams.

Don’t just take our word for it.