Hoppa till huvudinnehållet

Using Joins to Analyze Book Sales in SQL

Learn how to join data together to get it into a state for analysis.
Tim Sangster
Tim Sangster

Skapa ditt gratiskonto

Öva och håll koll på dina framsteg.

Fortsätt med GoogleGenom att fortsätta godkänner du vår användarvillkor, våra integritetspolicy och att dina uppgifter lagras i USA.

Koda med oss på

Code Along ↗
Visa 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.

Ämnen

Data AnalysisData EngineeringSQLData Analyst

Relaterat

snabbguide

SQL Joins Cheat Sheet

Handledning

Introduction to SQL Joins

Se mer →