Table Joins | Advanced SQL Interview Questions | Data Engineer Interview Question | FAANG Interview
Video 299: This is the 6th video of the SQL Interview Question series.
00:00 - Introduction to dataset and Question
03:45 - Solution using LEFT JOIN
09:30 - Explain INNER JOIN
11:05 - Explain LEFT JOIN
15:30 - Explain RIGHT JOIN
17:25 - Explain FULL JOIN
23:30 - Conclusion
We are given two tables Person and Address. We are asked to write a solution to report the first name, last name, city, and state of each person in the Person table. If the address of a personId is not present in the Address table, report null instead.
We Use Left Join by using Person table as primary table and Address as secondary table to get the required result. Then we discuss about different joins we have in a database. The basic joins we discussed are
1. INNER JOIN
2. LEFT JOIN
3. RIGHT JOIN
4. FULL JOIN
We also discussed as an extension of getting data which are not common in both the tables
For a comprehensive understanding of these SQL methodologies and their application, please refer to this explanatory video.
code: https://github.com/jeganpillai/adv_sq...
Follow me on,
Website : https://growwithdata.co/
YouTube : / @growwithdata
TikTok : / growwithdata
LinkedIn : / growwithdata
Facebook : / growwithdata.co
FB Group : facebook.com/groups/datainterviewpreparation
twitter : / growwithdata_co
Instagram : / growwithdata.co
WhatsApp : https://whatsapp.com/channel/0029VaF8...
TheWide : https://thewide.com/profile/891
#sql #dataengineers #tablejoins #ceil #floor #bucket #meta #google #facebook #apple #paypal #netflix #amazon #deinterview #sqlinterview #interviewquestions #leetcode #faang #maanga #mysql #oracle #dbms #query #sqlserver #mysql #coderpad #aggregates #aggregation #nonaggregation #database #placementpreparation #lead #lag #windowsfunction #nullcheck #coalesce #sqlperformance #ifnull #case #lead #lag #windowsfunction #tamil #tamilpython #tamilinterview #tamilinterviewlatest #tamilinterviewquestions #sqlintamil