Skip to main content

Exploring Astronaut Activities in SQL


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

Start Code AlongView SlidesView Dataset
Justin Saddlemyer Headshot
Justin Saddlemyer

Workspace Architect at DataCamp

View More Webinars

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.