Data Analysis Data Engineering SQL Data Analyst

Using Joins to Analyze Book Sales in SQL

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

Tim Sangster

2023년 4월 3일

무료 계정 만들기

실습 문제하고 트랙하세요.

Google로 계속하기계속 진행하시면 다음 사항에 동의하는 것으로 간주됩니다: 이용약관 및 개인정보 처리방침 그리고 귀하의 데이터가 미국에 저장된다는 점에 동의하는 것으로 간주됩니다.

함께 코드 따라하기

코드 따라하기 ↗

데이터셋 보기 ↗

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:

Intermediate SQL

Resources

Instructions to set up the sample book store database

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.