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.
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)
🔰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🙏🏻💜💚
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
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?
SUMMET SIR KINDLY REQUEST YOU TO PLS LAUNCH FURTHER SESSION ON SQL ON UA-cam 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..
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.
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
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.
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.
🔰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🙏🏻💜💚
Excellent ,working on it and learning ,thanks sir.
Detailed explanation. Very much Helpful.
Glad it was helpful!
Thank you, Sir. Its really a great course
Best SQL tutorial I have seen yet
Crisp explanation!!
Happy that you liked my explanation.
Fantastic, Thank you!!
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
Fantastic explaination.
Please provide class regularly without any gaps in between it will help us more
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?
Will you teach window function?
How many videos are left now? Eagerly waiting for the next one. your way of teaching is wonderful.
SUMMET SIR KINDLY REQUEST YOU TO PLS LAUNCH FURTHER SESSION ON SQL ON UA-cam 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
Thanks a lot
please explain self joins as well
Hi Sumit Sir, Thank you for sharing. Do we have any sessions for complex joins involving many tables?
Hi,
From where can we get the test file used for writing queries please?
Thank you sir
Hi @sumitmittal07 Sir
The notes which you are writing, can we get it?
Don't we use self join in any scenario?
What happens with an INNER JOIN when many to one relationship is present?
Self joins??
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..
Where can I get a pdf documentation of this playlist?
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.
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
can u explain joining more than 3 tables please
Need to understand INSERT OVERWRITE using more than one type of join , Can u pleass help?
Can we use CASE END in joins ? I'm getting error
can we have a notes of the videos sir
Thanks sir🥲
Joints are a very easy concept in SQL but you make it very difficult....
Thanks Sir