Learn SQL Joins

An easy-to-follow SQL joins tutorial, with lots of examples. Covers the main types of SQL joins, namely:

- INNER JOIN
- LEFT OUTER JOIN
- RIGHT OUTER JOIN
- FULL OUTER JOIN
- CROSS JOIN

0:00 Introduction
0:40 INNER JOINs
9:08 LEFT OUTER JOINs
13:04 RIGHT OUTER JOINs
15:36 FULL OUTER JOINs
17:10 Tailoring the matching criteria
18:40 CROSS JOINs
19:24 Joining a table to itself
21:06 Conclusion

[decomplexify]

CONTENTS
0:00 Introduction
0:40 INNER JOINs
9:08 LEFT OUTER JOINs
13:04 RIGHT OUTER JOINs
15:36 FULL OUTER JOINs
17:10 Tailoring the matching criteria
18:40 CROSS JOINs
19:24 Joining a table to itself
21:06 Conclusion

[ginadouglas]

Thank you so much! You are my favorite YouTube teacher. Your video on normalization saved me in my first SQL class! So glad to see new content.

I know these must be incredibly time consuming to make, thank you so much for doing them!

[tomcrusade]

Such a well prepared explanation 👍. This makes me not to rely on just "pattern recognition" to do database stuff, but has an actual sequence of logical thinking behind it that i finally understand from your videos

[sillycoder]

If I had teachers like you in college, I would become a billionaire by now!

[BMG]

Wow, this is absolutely incredible! I gained so much valuable insight from this video, and I truly appreciate the credibility of the information presented. Thank you so much for sharing your knowledge! I also have to mention how pleasant your voice is to listen to—it truly adds an extra layer of enjoyment to the experience!

[b-]

You have great presentation skills! Thank you so much for what you do. I'm doing a database management course that I've been struggling with and you're normalization video really helped!

[alexandrafaria]

Thank you so much! I have watched several of your videos now, and they are excellent explanations! I love your animations and your format. I was able to pause the videos, stop and think how I would create the Query, and then continue to see the syntax.

This has been so helpful. I hope you continue to make new content. I will be eager to see it!

[icreesmom]

Just over 5 minutes in and I am understand so much better. I have done joins before, but wasn't really able to picture it so it made more sense to me. Thank you.

[arkansharif]

Loved it! Perfect and concise explaination to a very complex topic

[lunaloynaz-lopez]

I could literally cry you broke it down perfectly. I was hopelessly confused

[RawShogun]

I keep coming back to these videos and learning something new every time!

[farah]

please continue with this course, you're the best!

[pavannikumbh]

your videos are really helpful. liked the way you explain the concepts. keep going, looking forward to watch more of your videos.

[pmmeurcatpics]

I am a total stranger to databases in any professional/formal context, even though I have engaged in what I now (after watching your videos) realize was table normalization a couple of times, e.g. while using Dataview in Obsidian, or Notion.

After watching this video in particular, it occurred to me that those massive Excel spreadsheets, which some companies base their entire operations on, seem strikingly similar to SQL-based databases with all the JOINs, WHEREs and whatnot.

But anyway, I wanted to thank you for all the excellent videos with clear explanations, helpful examples and great visuals. Really looking forward for the video(s) about the 4th&5th Normal Forms :)

[lilyaamieur]

definetly my favorite youtube teacher !!

[rusyst]

Great stuff! This tutorial deserves million views.

[muhammetmelikkolgesiz]

Right the time I was looking for Join videos. I met your videos with database normalisation. I think your methodology works best for me. Keep it up!

[AnkitDevelops]

I was having hard times understanding joins, thanks for this amazing video it helped me grasp the concept better.

[je.ro.me_]

Awesome video. Loved it. Fully understood 👏👏

[jaytea]

Please keep it up! You will have a large subscriber base if you do!