SQL JOINS Interview Question What does different SQL Joins return?

Channel Avatar
Comment
X
Share
SQL JOINS Interview Question What does different SQL Joins return?
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:
https://techtfq.com/blog/sql-joins-interview-question-what-does-different-sql-joins-return

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: https://learnsql.com/?refthoufiqmohammed

Practice SQL Queries: https://www.stratascratch.com/?viatechTFQ

Learn Python: https://codebasics.io/courses/python-for-beginner-and-intermediate-learners?refId70170e4c-7511-4c83-b769-c5cc8339c731

Learn Power BI: https://codebasics.io/courses/power-bi-data-analysis-with-end-to-end-project?refId4b1e1886-3252-4bf1-86f4-7d603dab692f

WATCH MORE VIDEOS HERE

SQL Tutorial – Basic concepts:
https://www.youtube.com/playlist?listPLavw5C92dz9HQQ_COgGb7kf_1H8UWUBxO

SQL Tutorial – Intermediate concepts:
https://www.youtube.com/playlist?listPLavw5C92dz9FD9XspliRM_HZM_jK7tkii

SQL Tutorial – Advance concepts:
https://www.youtube.com/playlist?listPLavw5C92dz9GbmgiW4TWVnxhjMFOIf0Q7

Practice Solving Basic SQL Queries:
https://www.youtube.com/playlist?listPLavw5C92dz9F66P3GFo5O6nJ4DfZNhVsp

Practice Solving Intermediate SQL Queries:
https://www.youtube.com/playlist?listPLavw5C92dz9EIYmNXJ8ZtQ1bmLIpt0SpV

Practice Solving Complex SQL Queries:
https://www.youtube.com/playlist?listPLavw5C92dz9Fahr7taauUx5RnTfuGyL–

Data Analytics Career guidance:
https://www.youtube.com/playlist?listPLavw5C92dz9FDsr995DjwCy9XNaIukb8P

SQL Course, SQL Training Platform Recommendations:
https://www.youtube.com/playlist?listPLavw5C92dz9GqF1Q_zn8KnYvFgtEOh-2n

Python Tutorial:
https://www.youtube.com/playlist?listPLavw5C92dz9FePZXIo4jpsupqp3X0w2SW

Git and GitHub Tutorial:
https://www.youtube.com/playlist?listPLavw5C92dz9EI1MPlqqDpe3bgr8RJZE0b

Data Analytics Projects:
https://www.youtube.com/playlist?listPLavw5C92dz9HwT_uStsDdJbuBOt_XD0ch

THANK YOU,
Thoufiq

Take the opportunity to connect and share this video with your friends and family if you find it useful.

Read Also

Leave a Reply

Your email address will not be published. Required fields are marked *