Skip to main content
HomeCode-alongsData Analysis

Using Joins to Analyze Book Sales in SQL

Learn how to join data together to get it into a state for analysis.
Apr 3, 2023
Code along with us onCode Along

View Dataset

Data in databases is typically spread across many tables, but that's not helpful for analyses. In this session you'll learn how to join data from different tables together to get it into a state for analysis. You'll also learn to analyze and visualize retail data through a dataset on book sales from a bookstore.

In this session we use DataLab. All you need is a DataCamp account. Note that members of some enterprise groups do not yet have access to use DataLab. Create a free DataCamp account with your personal email address to follow along.

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

Resources

What will I learn?

  • Understand database structures and use LEFT JOINs and INNER JOINs to manipulate data for analysis.

  • Learn to use exploratory queries to get a comprehensive understanding of a dataset.

  • Get insights into how to analyze retail sales data.

Topics
Related

cheat-sheet

SQL Joins Cheat Sheet

With this SQL Joins cheat sheet, you'll have a handy reference guide to joining data in SQL.
Richie Cotton's photo

Richie Cotton

6 min

tutorial

Introduction to SQL Joins

In this tutorial, you'll learn about the mechanics of joins in SQL and its different types.
Sayak Paul's photo

Sayak Paul

9 min

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

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

Getting Started in SQL

Learn how to write basic queries in SQL and find answers to business questions.
Kelsey McNeillie's photo

Kelsey McNeillie

code-along

Free Trial Performance Analysis in SQL

Learn how to use SQL to analyze marketing data for a free trial of a product
John Brazier-Beckett's photo

John Brazier-Beckett

See MoreSee More