Skip to main content

Using Joins to Analyze Book Sales in SQL


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 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.

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


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.

Start Code AlongView Dataset
Tim Sangster Headshot
Tim Sangster

Full Stack Software Engineer

Full Stack Software Engineer at DataCamp
View More Webinars

Recommended Content

Supermarket Transaction Analysis in SQL

Learn about Transaction Analysis in SQL - Hosted by Martina Chiari


Live Training: Analyzing Olympics Data with SQL and Python

Learn how to load data from different sources and perform exploratory analyses.


Live Training: Analyzing Carbon Footprints in SQL

In this code-along, we’ll use SQL to explore data of product carbon footprints.


Hands-on learning experience

Companies using DataCamp achieve course completion rates 6X higher than traditional online course providers

Learn More

Upskill your teams in data science and analytics

Learn More

Join 2,500+ companies and 80% of the Fortune 1000 who use DataCamp to upskill their teams.

Don’t just take our word for it.