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