SQL Fundamentals

SQL Fundamentals Relationships & Joins

This course has been updated! We now recommend you take the Complete Intro to SQL & PostgreSQL course.

Check out a free preview of the full SQL Fundamentals course:
The "Relationships & Joins" Lesson is part of the full, SQL Fundamentals course featured in this preview video. Here's what you'd learn in this lesson:

There are five types of joins in most relational database systems, but we can get away with focusing almost entirely on the two categories: INNER and OUTER joins. Mike discusses the distinction between these two types, and when to use the appropriate join operation.

Get Unlimited Access Now