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 👇
✅ Learn complete SQL: [ Ссылка ]
✅ Practice SQL Queries: [ Ссылка ]
✅ Learn Python: [ Ссылка ]
✅ Learn Power BI: [ Ссылка ]
🔴 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
