Please give a thumbs up 👍 to the video if you really like the video. My next zero to hero live SQL bootcamp starting August 1st. Check out the link below for a detailed curriculum and register your seat. www.namastesql.com/courses/Think-SQL-Go-from-Zero-to-Hero-Hindi-649011dde4b0f88fddc27a7b
i can say this is a really advanced concept which comes from experience truly. I faced similar question in Data Analyst interview of Target and was thrown out for even saying outer join :) and I asked chat GPT same question and it answered pretty well/ Find uncommon records from two tables , join two different tables and remove duplicated entries,Get all the Matched and Unmatched Rows From one Table, fetch unmatching records from two SQL tables,
Thanks for the video. I used a similar approach for solving this. with cte as ( select *,'e' as region from orders_europe union select *,'i' from orders_india union select *,'u' from orders_usa ) select product_id , sum(case when region = 'u' then sales end) as sales_usa , sum(case when region = 'e' then sales end) as sales_europe , sum(case when region = 'i' then sales end) as sales_india from cte group by product_id
Mind Blowing explanation and last 1-2 mins were the best.. However, Iwould have approached the problem in similar way.. but a great explanation of fullouter and left join and product master use
Ankit you have beautifully interlaced concepts, slowly and methodically increased the pitch in each way that you've solved this problem. It is simply awesome. Excellent example of story telling BIIIIG Thanks Bro
It is so amazing which I have learned in this video especially the last trick to handle the null. And I would like to Thank you a lot because due to your channel I have learned tips and trick to solve the queries and made my self ready to write the complex queries. It's the best channel to learn SQL.
Today i was so excited that i have really learned a new and different advanced concepts bro... with this i have done with this playlist succesfully.......Lot of thanks for youtube for introducing such a talented persons who can make sql from hard to simple for me and all who are using this style for their careers from ankit bro.. keeep going broooo.💯💯💯💯💯💯💯💯
Hi Ankit. Awesome video.. I have a query, If we have millions of record in tables then union will efficiently or outer join will work in optimized way ?
Hello Sir. I'm following your videos for a month. I can see a lot of improvement in problem-solving. However, I still need to ask a question. Let's say I complete your complex question playlist. Would that be enough for me to recognise patterns and have mastery over SQL interview-type questions? Thank you, Sir
Sir, Can you please tell us genuine Way to get a job as a Data Analyst. We have enough skills and Projects stil not getting Interview calls. Can you help us and talk about this in video.
@@shafi123 Wow. If experienced candidates not getting job then getting job as Fresher is much tough. Can you tell us any tips to getting call as fresher. We have to try hard no choice.
Hi Ankit I enrolled for your Python course. Before enrolling it was mentioned you will cover how to build data warehouse and ETL data pipelines with python. None of it is present in your course. How can we contact your support team? I joined the course specifically for that concept and its not there. Please let me know how to contact your supoort team
@@ankitbansal6 just like spotify can you add 1-2 more projects to build ETL pipelines from scratch! It would be very helpful . Something related to RETAIL domain or can you suggest from where can we practice more projects
![Lp. Сердце Вселенной #60 РОЖДЕНИЕ ЛОЛОЛОШКИ [Финал] • Майнкрафт](http://i.ytimg.com/vi/YoR0pAV9FVQ/mqdefault.jpg)
Please give a thumbs up 👍 to the video if you really like the video.
My next zero to hero live SQL bootcamp starting August 1st. Check out the link below for a detailed curriculum and register your seat.
www.namastesql.com/courses/Think-SQL-Go-from-Zero-to-Hero-Hindi-649011dde4b0f88fddc27a7b
i can say this is a really advanced concept which comes from experience truly. I faced similar question in Data Analyst interview of Target and was thrown out for even saying outer join :) and I asked chat GPT same question and it answered pretty well/ Find uncommon records from two tables , join two different tables and remove duplicated entries,Get all the Matched and Unmatched Rows From one Table, fetch unmatching records from two SQL tables,
Thanks for the video. I used a similar approach for solving this.
with cte as (
select *,'e' as region from orders_europe
union
select *,'i' from orders_india
union
select *,'u' from orders_usa
)
select product_id
, sum(case when region = 'u' then sales end) as sales_usa
, sum(case when region = 'e' then sales end) as sales_europe
, sum(case when region = 'i' then sales end) as sales_india
from cte
group by product_id
Mind Blowing explanation and last 1-2 mins were the best..
However, Iwould have approached the problem in similar way.. but a great explanation of fullouter and left join and product master use
Ankit you have beautifully interlaced concepts, slowly and methodically increased the pitch in each way that you've solved this problem. It is simply awesome. Excellent example of story telling BIIIIG Thanks Bro
Thanks a ton😊
It is so amazing which I have learned in this video especially the last trick to handle the null. And I would like to Thank you a lot because due to your channel I have learned tips and trick to solve the queries and made my self ready to write the complex queries. It's the best channel to learn SQL.
Great to hear!😊
Hi Ankit, just wanted to say thank you for all your hard work. You are doing an amazing job.
It's my pleasure
Today i was so excited that i have really learned a new and different advanced concepts bro... with this i have done with this playlist succesfully.......Lot of thanks for youtube for introducing such a talented persons who can make sql from hard to simple for me and all who are using this style for their careers from ankit bro.. keeep going broooo.💯💯💯💯💯💯💯💯
Excellent 👌👌
Enjoyed learning this super cool trick ankit sir and very excited to learn new things from the upcoming videos.
Keep watching
Wowww!! Such a knowledgeable video , worth waiting till the end and understanding the whole concept.❤
Thanks a lot 😊
Very efficient and optimized trick.
Thanks Ankit
Glad you liked it
Such valuable contents sir!!👍🙏
Thanks a ton
Great explanation of concepts sir💯
Thanks for liking
Excellent 👌👍
Thank you! Cheers!
Completed ❤
Hi Ankit. Awesome video.. I have a query, If we have millions of record in tables then union will efficiently or outer join will work in optimized way ?
Union(all) will be better.
Union all better than left join
Really helpful.. thanks
Glad it was helpful!
Too good really helpful
Thanks a lot 😊
excellent
Thank you! Cheers!
How can I handle this in Mysql
use last trick
Hi Ankit sir, can i used this question and make a LinkedIn post.?
Sure please go ahead
@@ankitbansal6 thank you sir.
Can you please start taking mock interview of people ( paid program)?
Hello Sir. I'm following your videos for a month. I can see a lot of improvement in problem-solving. However, I still need to ask a question. Let's say I complete your complex question playlist. Would that be enough for me to recognise patterns and have mastery over SQL interview-type questions?
Thank you, Sir
Yes good enough
Sir, Can you please tell us genuine Way to get a job as a Data Analyst. We have enough skills and Projects stil not getting Interview calls. Can you help us and talk about this in video.
Same here bro, are you working somewhere now.
@@narenderyadav1727 No Searching for Job.
Its not that easy as the market is not good right now. I being a experienced data analyst not getting interview calls
@@shafi123 Wow. If experienced candidates not getting job then getting job as Fresher is much tough. Can you tell us any tips to getting call as fresher. We have to try hard no choice.
Thanks mate.
I have a question
Why does your intro sound like you are fully stoned??? 😂😂😂
That's my natural 😝
❤
Hi Ankit I enrolled for your Python course. Before enrolling it was mentioned you will cover how to build data warehouse and ETL data pipelines with python. None of it is present in your course. How can we contact your support team? I joined the course specifically for that concept and its not there. Please let me know how to contact your supoort team
ETL data pipelines are there. We have also covered scd type 1 and 2 .
@@ankitbansal6 just like spotify can you add 1-2 more projects to build ETL pipelines from scratch! It would be very helpful . Something related to RETAIL domain or can you suggest from where can we practice more projects
@@ritzysquad1361 Yes I am planning to add few more topics to the course. Will add more projects as you suggested .
@@ankitbansal6 thankyou so much