Learn SQL Joins

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

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!

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!

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!

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.

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

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

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!

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

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 :)

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

Your videos are truly awesome, thank you for making them

Thank you! I love the explanation in simple examples If I can suggest one topic it would be the one you alluded to in the denormalization video about things we can do for processing layer optimization: sharding, indexes, and statistics

Great stuff! This tutorial deserves million views.

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

Your videos are great. Can you do some advanced SQL stuff please like procedural function,triggers etc

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

definetly my favorite youtube teacher !!

This is top notch quality. Loved it

Amazing Video! Keep making more on databases!