Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Well done!
You have completed Combining Data for Analysis!
You have completed Combining Data for Analysis!
Preview
Welcome back! In this video, I will provide an overview of the data we will use in the workshop, and review the concept of joining data.
Types of Joins
- The Inner Join returns only matching records found in both tables.
- The Outer Join returns all records from both tables (aka Full Outer Join).
- The Left Join returns all records from the left table and the matching records from the right table (aka Left Outer Join).
- The Right Join returns all records from the right table and the matching records from the left table (aka Right Outer Join).
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
If you're familiar with SQL or
relational algebra,
0:00
you're probably familiar with the term "join".
0:03
You may have seen the Venn diagram
with the two interlocking shapes, and
0:06
we'll revisit that idea.
0:10
There are four types of joins.
0:12
So, let's look at how each join
type yields a different result.
0:14
For this example, I have two tables.
0:18
The first table is the Top 10 songs
from the Billboard 100 Chart,
0:21
released on July 28, 2018.
0:26
It contains the Billboard rank
along with the song information.
0:28
You need to sign up for Treehouse in order to download course files.
Sign upYou need to sign up for Treehouse in order to set up Workspace
Sign up