SQL JOINS Tutorial for beginners | Practice SQL Queries using JOINS - Part 2

This is the SQL JOINS Tutorial for complete beginners. This is the second part of the series. In this video we shall cover FULL OUTER Join, CROSS Join, NATURAL Join and SELF Join. In the first part of this video series, I had covered INNER Join, LEFT join and RIGHT Join.

I start this video by discussing about FULL OUTER Join. But in order to understand FULL OUTER Join, we need to first look at the difference in output from INNER, LEFT and RIGHT JOIN. So we go through the difference in these 3 joins first and then I explain the concept of FULL OUTER Join.
We then cover CROSS join and I explain a scenario where you may need to use CROSS join.
We then talk about NATURAL join. I'll tell you the difference between NATURAL join and INNER join and also tell you why you should not be using NATURAL Join.
Finally, we cover one of the most important JOINS in SQL which is the SELF JOIN. I explain SELF join by taking a real world example.
Every concept is explained by writing SQL queries so hopefully this video along with the first part of this video, should help you to completely understand JOINS in SQL.

Joins are the most fundamental concepts in SQL and having a clear understanding of Joins is very essential to write good SQL queries.

Timeline:
00:00 Intro
00:54 FULL OUTER JOIN in SQL
10:20 CROSS JOIN in SQL
16:44 NATURAL JOIN in SQL
21:51 SELF JOIN in SQL

Watch the first part of this SQL JOINS Tutorial Series:

Join my FREE live SQL training session:
Batch 1 - Started on 03-Jan-2022 (08:00 pm Malaysian Time / 05:30 pm Indian Time)
Day: Monday, Tuesday, Thursday, Friday

Batch 2 - Starts on 17-Jan-2022 (09:30 pm Malaysian Time / 07:00 pm Indian Time)
Day: Monday, Tuesday, Thursday, Friday

Note: Both batch 1 and batch 2 will cover the exact same topics. Just the date and time are different based on the convenience of everyone.

How to Join the sessions:
2) Click the subject "Data Science"
3) Find my session and click on it. The sessions will automatically start 4 mins prior to the scheduled time.

Please do subscribe and like this video if you found it useful.

🔴 WATCH MORE VIDEOS HERE 👇

✅ SQL Tutorial - Basic concepts:

✅ SQL Tutorial - Intermediate concepts:

✅ SQL Tutorial - Advance concepts:

✅ Practice Solving Basic SQL Queries:

✅ Practice Solving Intermediate SQL Queries:

✅ Practice Solving Complex SQL Queries:

✅ Data Analytics Career guidance:

✅ SQL Course, SQL Training Platform Recommendations:

✅ Python Tutorial:

THANK YOU,
Thoufiq

[VITORB]

After 5 centuries i finnaly understand what Cross Joins are. You deserve a Cookie!

[venkatpullalarevu]

Never understood SQL joins as much as I did with this video. Thoufiq, your teaching ability is beyond comparison. Great work.

[anchal_diary]

I rarely comment because I am so lazy but your teaching skills forced me to write something for you as an appreciation you are a great teacher . so simple and straight Thankyou so much. Preparing for Data Analyst Role wish me luck!!!

[crap]

I can't believe I'm paying college fees with profs that can't even teach this well...

[sabyasachimukherjee]

Best explanations of JOINS in YouTube. Hands down!

[adeebazia]

I've watched multiple videos on joins before, but this is the last video I'm watching as from today onwards all my concepts on joins will be crystal clear.
Thankyou Thoufiq ♥️

[nikitarai]

Once you start watching his videos. There's no going back seriously. This guy is the OG!

[daminichatta]

Your way of explaining the concepts is very clear and easily understandable. The other best thing is that you explain the use cases that other videos lack. Good work Thoufiq.

[vijayadivakar]

Great teaching thank you sir....I'm continuously fallowing your SQL videos..

[faizanwar_]

How can you be so good at teaching? this is amazing...salute to people like you who provide such valuable contents for free

[worldofnature]

TOUFIK you did a fantastic job simplifying SQL joins! I used to find them confusing, but his explanations really made it clear. Great job and very understandable!

[monikadewani]

I struggled with the self join especially when I had to write the condition. You made it crystal clear to me. Thank you so much

[varshithreddy]

Keep posting different difficult concepts in SQL.

No need to think of joins again after watching ur videos

[ashishagnihotri]

explanation = 100%
efforts = 100%
content quality = 100%
our concept clear after watching this = 100%
thanks = 100%

[johnwayne]

Mate, I've viewed multiple videos explaining self-joins and yours is the one that pieced it together for me. Kudos to you - keep up the amazing content!

[julianasdiaryy]

I have just signed up on the Learn SQL using your affiliate link, it has been great, but when it comes to Join it gets confusing, so coming to watch your tutorial here makes everything understandable now. I just wanted to say thank you so much for your teaching and we look forward to more videos from you.

[shravyak]

Best tutorial on the concept of SQL joins.

[srivithya]

finally i found a clear explanation. thanks thoufig

[ehsanellahi]

I very rarely make comment's on any videos but today, I felt like if, I wouldn't like or subscribe to you that you be injustice to this wonderful and very simplified explanation.

[girishbawaskar]

The way you explain I will never confused between any join …. Perfect explanation I have never get from any tutorial.. simple explanation not confusion♥️ all the best 👏