Truly the most beautiful way "EXPLAINING THE CONCEPT OF JOINS ". Its a treasure for those who want to learn effectively, precisely and accurately about the concept. The best of best series. Thank for the free sessions #Summitmittal sir.
🔰Completely understood and absorbed I'd say. I learn Join for the first time and got enormous insights throughout the session. Thank you very much Sumit sir🙏🏻💜💚
Thanks for the video !! 1.) Could you also explain why JOINS are not better performant ? Instead, Is it that JOINS are performant but not scalable ? 2.) Could you also explain about ordering of GROUP BY, HAVING, SORT, JOIN ?(Just like the way you explained in Session 7)
Hello Sumit Sir, I am really enjoying your courses. Thea way you explain the things in much simpler way. Alot much thanks to you. and Please answer which join is fast amongs all the joins you explained?
Thank you sir for this amazing series. Please explain why we need right join when we already have left join. We have to interchange only the tables in order to get the right join from left join then why we need the right joint specifically could you please share any industry use case in this regards thank you sir
SUMMET SIR KINDLY REQUEST YOU TO PLS LAUNCH FURTHER SESSION ON SQL ON RUclips AS I HAVE COMPLETED ALL TILL SESSION 11 ALONG WITH HANDS ON. NEED MORE VIDEOS ON COMPLEX JOIN FOR 3 TABLES, MINUS OPERATOR EXAMPLE, VIDEO ON MAINLY FACT AND DIMENSION TABLE WITH EXAMPLE, RANK , DENSE RANK WINDOW NEED TO BE COVERED PLEASE ITS MY REQUEST FROM YOU BRING MORE VIDEOS ON SQL ASAP I AM WAITING SINCE YESTERDAY.
I am a student of computer science. My dream is to be an data engineer. I saw your new course. Please tell me about the cost of the program. And any discount..
can you show select * from students (students table), i need to understand inner join between course table and students. you didnt showed student table in this video
According to google and w3schools, there is keyword 'FULL OUTER JOIN' for full outer join, and you are saying there is not. Instead of, we are using UNION operator for this purpose. Can you please it and clarify this confusion. Thank you
Full outer join doesn't work in mysql database that is the reason we use union to perform the same operation, different flavours/types of dbms have some differences in syntax depends on which one you are using.
Checkout the Big Data course details here: trendytech.in/?referrer=youtube_sql12
Truly the most beautiful way "EXPLAINING THE CONCEPT OF JOINS ". Its a treasure for those who want to learn effectively, precisely and accurately about the concept. The best of best series. Thank for the free sessions #Summitmittal sir.
🔰Completely understood and absorbed I'd say. I learn Join for the first time and got enormous insights throughout the session.
Thank you very much Sumit sir🙏🏻💜💚
Thanks for the video !!
1.) Could you also explain why JOINS are not better performant ? Instead, Is it that JOINS are performant but not scalable ?
2.) Could you also explain about ordering of GROUP BY, HAVING, SORT, JOIN ?(Just like the way you explained in Session 7)
yes yes, will be coming up with these in upcoming sessions.
Best SQL tutorial I have seen yet
Detailed explanation. Very much Helpful.
Glad it was helpful!
Fantastic explaination.
Please provide class regularly without any gaps in between it will help us more
Excellent ,working on it and learning ,thanks sir.
Hello Sumit Sir, I am really enjoying your courses. Thea way you explain the things in much simpler way. Alot much thanks to you.
and Please answer which join is fast amongs all the joins you explained?
How many videos are left now? Eagerly waiting for the next one. your way of teaching is wonderful.
Crisp explanation!!
Happy that you liked my explanation.
Thank you sir for this amazing series.
Please explain why we need right join when we already have left join. We have to interchange only the tables in order to get the right join from left join then why we need the right joint specifically could you please share any industry use case in this regards thank you sir
Sir, really very simple and wonderful description. Please share the notepad document for reference of queries
Thank you, Sir. Its really a great course
SUMMET SIR KINDLY REQUEST YOU TO PLS LAUNCH FURTHER SESSION ON SQL ON RUclips AS I HAVE COMPLETED ALL TILL SESSION 11 ALONG WITH HANDS ON. NEED MORE VIDEOS ON COMPLEX JOIN FOR 3 TABLES, MINUS OPERATOR EXAMPLE, VIDEO ON MAINLY FACT AND DIMENSION TABLE WITH EXAMPLE, RANK , DENSE RANK WINDOW NEED TO BE COVERED PLEASE ITS MY REQUEST FROM YOU BRING MORE VIDEOS ON SQL ASAP I AM WAITING SINCE YESTERDAY.
Next video tomorrow evening
Fantastic, Thank you!!
Will you teach window function?
please explain self joins as well
I am a student of computer science. My dream is to be an data engineer. I saw your new course. Please tell me about the cost of the program. And any discount..
What happens with an INNER JOIN when many to one relationship is present?
Hi Sumit Sir, Thank you for sharing. Do we have any sessions for complex joins involving many tables?
Don't we use self join in any scenario?
can u explain joining more than 3 tables please
can you show select * from students (students table), i need to understand inner join between course table and students. you didnt showed student table in this video
Thanks a lot
Self joins??
Thank you sir
Need to understand INSERT OVERWRITE using more than one type of join , Can u pleass help?
According to google and w3schools, there is keyword 'FULL OUTER JOIN' for full outer join, and you are saying there is not. Instead of, we are using UNION operator for this purpose. Can you please it and clarify this confusion. Thank you
It's depends on database you use. Atleast whatever I am using does not support it.
For Hive/Impala we have FULL OUTER JOIN to join tables with all data which is doing similar operation for UNION.
Full outer join doesn't work in mysql database that is the reason we use union to perform the same operation, different flavours/types of dbms have some differences in syntax depends on which one you are using.
Hi,
From where can we get the test file used for writing queries please?
26:07
Where can I get a pdf documentation of this playlist?
can we have a notes of the videos sir
Hi @sumitmittal07 Sir
The notes which you are writing, can we get it?
Can we use CASE END in joins ? I'm getting error
Thanks sir🥲
Joints are a very easy concept in SQL but you make it very difficult....
Thanks Sir