In this video we will discuss in depth full outer join in SQL and its challenges. We will also see 2 better alternatives of full outer join specially when you need to join more than 2 tables.
00:00 setting up the context
03:35 Challenges with full outer join
16:40 alternative 1 (traditional)
23:15 alternative 2 (super cool trick)
scripts:
create table product_master
(
product_id int,
product_name varchar(100)
);
insert into product_master values(100,'iphone5'),(200,'hp laptop'),(300,'dell laptop');
create table orders_usa
(
order_id int,
product_id int,
sales int
);
create table orders_europe
(
order_id int,
product_id int,
sales int
);
create table orders_india
(
order_id int,
product_id int,
sales int
);
--delete from orders_india
insert into orders_usa values (1,100,500);
insert into orders_usa values (7,100,500);
insert into orders_europe values (2,200,600);
insert into orders_india values (3,100,500);
insert into orders_india values (4,200,600);
insert into orders_india values (8,100,500);
Zero to hero(Advance) SQL Aggregation:
https://youtu.be/5Ighj_2PGV0
Most Asked Join Based Interview Question:
https://youtu.be/xR87ctOgpAE
Solving 4 Trick SQL problems:
https://youtu.be/Ck1gQrlS5pQ
Data Analyst Spotify Case Study:
https://youtu.be/-YdAIMjHZrM
Top 10 SQL interview Questions:
https://youtu.be/Iv9qBz-cyVA
Interview Question based on FULL OUTER JOIN:
https://youtu.be/KQfWd6V3IB8
Playlist to master SQL :
https://youtube.com/playlist?list=PLBTZqjSKn0IeKBQDjLmzisazhqQy4iGkb
Rank, Dense_Rank and Row_Number:
https://youtu.be/xMWEVFC4FOk
#sql #fullouterjoin #unionall