Skip to main content

Exploring Astronaut Activities in SQL

In this live training, we use string cleaning to process and analyze a database
Feb 7, 2023
Code along with us onCode Along

View slidesView dataset

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

Additional Resources

Topics
Related

tutorial

Cleaning Data in SQL

In this tutorial, you'll learn techniques on how to clean messy data in SQL, a must-have skill for any data scientist.
Sayak Paul's photo

Sayak Paul

10 min

code-along

Analyzing NASA Planetary Exploration Budgets in SQL

We're using SQL and DataCamp Workspace to explore a dataset on NASA's budget
Richie Cotton's photo

Richie Cotton

code-along

Exploratory Data Analysis in SQL for Absolute Beginners

Learn the basics of exploring new datasets using SQL.
Jasmin Ludolf's photo

Jasmin Ludolf

code-along

Data Modeling in SQL

In this live training, you'll learn about data cleaning, shaping and loading techniques and learn about common database schemas for organizing tables for analysis.
Andy Alseth's photo

Andy Alseth

code-along

Using DataLab in Data Academies

Learn how to use DataCamp Workspace as part of a corporate training program
Filip Schouwenaars's photo

Filip Schouwenaars

code-along

Analyzing Streaming Service Content in SQL

Learn to join data from multiple sources, and create no-code visualizations.
Justin Saddlemyer's photo

Justin Saddlemyer

See MoreSee More