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

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

Slides

Topics

Data Analysis

SQL

Business Intelligence

Data Analyst

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

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

code-along

Exploratory Data Analysis in SQL for Absolute Beginners

Learn the basics of exploring new datasets using SQL.

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

code-along

Using DataLab in Data Academies

Learn how to use DataCamp Workspace as part of a corporate training program

Filip Schouwenaars

code-along

Analyzing Streaming Service Content in SQL

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

Justin Saddlemyer

See More See More