SQL JOINS Interview Question | What does different SQL Joins return?

Given 2 tables, identify the no of records returned using different type of SQL Joins. This is a very frequently asked SQL Interview questions especially when a recruiter wants to test your knowledge on SQL joins, this is the kind of questions you can expect.

In this video, we shall look at 2 different datasets. Each dataset contains 2 tables which has duplicate data, null values etc. You are required to identify the no of records returned using INNER Join, LEFT Join, RIGHT Join, FULL JOIN, Natural Join and Cross Join. And you need to answer them without querying the tables.

Hence in order to answer such questions, you need to understand clearly how SQL internally performs different type of joins.

Download the dataset used in the video from my blog. Link below:

Timestamp:
00:00 Intro
00:48 Understanding dataset from Scenario 1
01:35 Understanding INNER JOIN
06:03 Understanding LEFT JOIN
09:48 Understanding RIGHT JOIN
12:03 Understanding FULL OUTER JOIN
14:33 Understanding CROSS JOIN
15:58 Understanding NATURAL JOIN
19:35 Answering all JOINS result from Scenario 2 dataset

🔴 My Recommended courses 👇

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

✅ Git and GitHub Tutorial:

✅ Data Analytics Projects:

THANK YOU,
Thoufiq

[archkrishna]

Have seen so many SQL videos on joins, no one has explained it like you. Will never forget the concept. Thanks so much for your hardwork and effort.

[dracoreeper]

I just came across this video, i figured out a internal logic of this on my own, did not know that this video existed. proud of figuring that out now

[abhisheknakate]

The way you explain joins is more concise than any of the SQL videos I've seen... I finally understand how Joins work .... thanks to your explanation..!

[TussharPatnaik]

Explanation is "at par". I don't think I'm gonna forget this JOINS concept in this lifetime. Thanks Taufiq !!

[vikramamin]

I have seen quite a few videos on Joins but this is probably the simplest and easiest way of understanding Joins. Kudos!!!
This will help in explaining joins in an Interview.
Keep up the good work 😀

[sampadatamhankar]

I generally dont comment on any videos, But I have to say i will never ever be confused about joins here onwards!! Gratitude!!

[priyankachaparala]

Before I was very confused with JOINTS but after watching the video with the formulas, examples and explanation I’m very much clear now. Hat’s off and thank you.

[jagnyaseni]

I was searching for this type of join video with example from so many days . Thank you for how wonderfully u have explained...I didn't find anyone who is explaining like you... 🙏🙏

[harsha]

The way you explain SQL even layman can understand SQL kudos to your explanation

[MUSTAFA]

Sometimes topics are simple but you need a right guy to deliver it for you in a simple way.
You got a subscriber ❤

[sureshsekar]

I never seen this kind of clear explanation. After 7 years I am clear join concept. Thank you so much.

[MdRizwan-uudv]

The way you explain the concepts it becomes easier to understand. which shows that the effort and hard work you put in to master the SQL.

[technicalraman]

Salute Sir. I watched hundreds of videos on sql join but only ur video clear all concepts on Joins. Salute Sir.

[khalid]

I love how you explain how SQL works, It's so clear anyone can understand it. I'm hoping that your next video would be on SQL optimization?

[shlokvishwasrao]

I was just watching this video randomly, just to brush up my concepts but I'd like to admit one thing for sure that when I learnt joins for the first time, I learned it in the Hard way.This is just some Brilliant stuff with extraordinary explanation👏

[vasanthalakshmi]

Thanks, searched for this content forever and finally after so long u made this video, one of its kind in most basic rules, really appreciate and please keep doing more of these videos, also nice that duplicate removing video has been made 😀

[nimeelyamattluru]

I have come across so many SQL joins video but this has very keen explanation, we cannot forget that in life time Thank you for your valuable teaching

[poulamidas]

I feel so good that I have come across your channel. These small concepts are nowhere described in the way you have brought in front of us. So minutely explained and all the concepts are becoming clear day by day. Thank you so much for all that you are doing ❤

[shantanumandal]

Please keep posting interview questions and concepts like these frequently..these are very helpful..and please start tutorials on power bi also if possible..❤️

[yshu]

Thank you so much no one other has explained it so well it has been around 3 months i was learning SQL but got to know today that my understanding for inner join was very wrong .

Feeling glad that i came across you tutorials