Live training

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!

Tuesday, November 8 @ 11 am ET
Register Now

What will I learn?

You will learn how to:
  • 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

What should I prepare?

We will be using DataCamp Workspace. All you need is a DataCamp account. If you need help, read the "Getting Started with Workspace" tutorial ( Note that members of some enterprise groups do not yet have access to use DataCamp Workspace. Create a free DataCamp account with your personal email address to follow along.

Who should attend?

We recommend that you have taken the following course before attending:

  • Data Manipulation in SQL

Presenter Bio

Justin Saddlemyer Headshot

Justin Saddlemyer

Workspace Architect

Justin is a Workspace Architect at DataCamp. He holds a bachelor's degree in psychology from St. Francis Xavier University and a graduate degree in social psychology from VU Amsterdam. In 2016 Justin received a Ph.D. in marketing from KU Leuven.
Follow on LinkedIn