Hi guys, Welcome to the Advanced Video Search Engine, and you are watching SQL JOINS Interview Question | What does different SQL Joins return?. That video is uploaded by techTFQ at 2022-10-24T06:30:12-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [xUsY2jWQa1w]
| Name | SQL JOINS Interview Question | What does different SQL Joins return? |
| Video Uploader | Video From techTFQ |
| Upload Date | This Video Uploaded At 24-10-2022 13:30:12 |
| Video Discription | 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/?ref=thoufiqmohammed โ Practice SQL Queries: https://www.stratascratch.com/?via=techTFQ โ Learn Python: https://codebasics.io/courses/python-for-beginner-and-intermediate-learners?refId=70170e4c-7511-4c83-b769-c5cc8339c731 โ Learn Power BI: https://codebasics.io/courses/power-bi-data-analysis-with-end-to-end-project?refId=4b1e1886-3252-4bf1-86f4-7d603dab692f ๐ด WATCH MORE VIDEOS HERE ๐ โ SQL Tutorial - Basic concepts: https://www.youtube.com/playlist?list=PLavw5C92dz9HQQ_COgGb7kf_1H8UWUBxO โ SQL Tutorial - Intermediate concepts: https://www.youtube.com/playlist?list=PLavw5C92dz9FD9XspliRM_HZM_jK7tkii โ SQL Tutorial - Advance concepts: https://www.youtube.com/playlist?list=PLavw5C92dz9GbmgiW4TWVnxhjMFOIf0Q7 โ Practice Solving Basic SQL Queries: https://www.youtube.com/playlist?list=PLavw5C92dz9F66P3GFo5O6nJ4DfZNhVsp โ Practice Solving Intermediate SQL Queries: https://www.youtube.com/playlist?list=PLavw5C92dz9EIYmNXJ8ZtQ1bmLIpt0SpV โ Practice Solving Complex SQL Queries: https://www.youtube.com/playlist?list=PLavw5C92dz9Fahr7taauUx5RnTfuGyL-- โ Data Analytics Career guidance: https://www.youtube.com/playlist?list=PLavw5C92dz9FDsr995DjwCy9XNaIukb8P โ SQL Course, SQL Training Platform Recommendations: https://www.youtube.com/playlist?list=PLavw5C92dz9GqF1Q_zn8KnYvFgtEOh-2n โ Python Tutorial: https://www.youtube.com/playlist?list=PLavw5C92dz9FePZXIo4jpsupqp3X0w2SW โ Git and GitHub Tutorial: https://www.youtube.com/playlist?list=PLavw5C92dz9EI1MPlqqDpe3bgr8RJZE0b โ Data Analytics Projects: https://www.youtube.com/playlist?list=PLavw5C92dz9HwT_uStsDdJbuBOt_XD0ch THANK YOU, Thoufiq xUsY2jWQa1w |
| Category | Education |
| Tags | sql | sql joins | sql interview questions and answers | sql queries interview questions and answers | sql interview questions | sql joins interview question | joins in dbms | sql types of joins | sql join 3 tables | sql joins with example | sql interview questions for beginners | sql left joins | sql join statements | sql questions | sql joins tutorial for beginners | sql interview questions and answers for experienced |
