The way you explain joins is more concise than any of the SQL videos I've seen... I finally understand how Joins work .... thanks to your explanation..!
Before I was very confused with JOINTS but after watching the video with the formulas, examples and explanation I’m very much clear now. Hat’s off and thank you.
Most Helpful video ever. I have been trying to study SQL for the past 6 years and no one and I mean no one from Kudvent to Udemy Courses taught this concept so beautifully. Thanks a lot. can't thank you enough,.
I was just watching this video randomly,just to brush up my concepts but I'd like to admit one thing for sure that when I learnt joins for the first time,I learned it in the Hard way.This is just some Brilliant stuff with extraordinary explanation👏
I was searching for this type of join video with example from so many days . Thank you for how wonderfully u have explained...I didn't find anyone who is explaining like you... 🙏🙏
I have seen quite a few videos on Joins but this is probably the simplest and easiest way of understanding Joins. Kudos!!! This will help in explaining joins in an Interview. Keep up the good work 😀
Man you've explained exactly what i needed to know. You've no idea how relieved i feel after finally understanding the concept of joins. I needed to understand how sql works with each record of each table and you've explained that really well. Thanks a lot brother for this video. I'll definitely subscribe to your channel.
Thank you so much no one other has explained it so well it has been around 3 months i was learning SQL but got to know today that my understanding for inner join was very wrong . Feeling glad that i came across you tutorials
I feel so good that I have come across your channel. These small concepts are nowhere described in the way you have brought in front of us. So minutely explained and all the concepts are becoming clear day by day. Thank you so much for all that you are doing ❤
Hi sir, I was not able to get clear understanding about joins even I've watched and referred so many websites and UA-cam videos but finally I'm very glad and confident about joins after watching this video the way you explain with formula makes the whole scenario easy. Thankyou so much for making great efforts to make the concepts understand easily
Thanks , searched for this content forever and finally after so long u made this video, one of its kind in most basic rules , really appreciate and please keep doing more of these videos, also nice that duplicate removing video has been made 😀
Please keep posting interview questions and concepts like these frequently..these are very helpful..and please start tutorials on power bi also if possible..❤️
Hats off Toufiq. No one can explain better than this. We have a great teacher in the form you, who will help us with more information even for the small inputs which we have given to you. Kudos 👌👌🤞🤞. Thank you once again...
Likes * Infinity. Very Simple and easy to understand. also providing the tables is a great idea as anyone can practice it without getting lazy to write insert query.
FORMULAS FOR JOINS 💢 INNER JOIN = Inner join will only fetch the matching record from the opposite table you mentioned. LEFT JOIN = Inner join + fetch any additional records from the left table which is not present in the right table. RIGHT JOIN = Inner join + fetch any additional records from right table which is not present in left table. FULL JOIN = Inner join + fetch any additional records from left table which is not present in right table + fetch any additional records from right table which is not present in left table.
Cross Join = Match each record in the left table to each record in the right table Irrespective of the values.(Number of records in the left table * Number of records in the right table)
Thank you soo much for wonderful explanation, Actually I came across that question in my interview but I'm not able to answer that, but now I have confidence to answer that kind of question.
Thank you so much @TechTFQ, this same question was asked in my interview today and I was able to answer it very easily. It boosted my confidence too. Thank you 😊
@@techTFQ Could you please start some videos on Datawarehouse databases with 6-10TB sizes and how to handle them.. Please share if any of your tutorial videos exists will take membership or subscription to watch
Have seen so many SQL videos on joins, no one has explained it like you. Will never forget the concept. Thanks so much for your hardwork and effort.
Couldn't agree more
@@thepratikjoshi44 +1
@@thepratikjoshi44 y so ?
Very true.
indeed, this video practically settles it all. I can be sure that I now understand SQL joins
I never seen this kind of clear explanation. After 7 years I am clear join concept. Thank you so much.
same here
I generally dont comment on any videos, But I have to say i will never ever be confused about joins here onwards!! Gratitude!!
Salute Sir. I watched hundreds of videos on sql join but only ur video clear all concepts on Joins. Salute Sir.
The way you explain SQL even layman can understand SQL kudos to your explanation
Thank you very much bro
Great help 😊 sir
I totally agree. It’s very clear. I would like to learn all filer/ criteria such as exclude some data in the table. Can you share the video? Thanks
I just came across this video, i figured out a internal logic of this on my own, did not know that this video existed. proud of figuring that out now
The way you explain joins is more concise than any of the SQL videos I've seen... I finally understand how Joins work .... thanks to your explanation..!
After 10 years of my career, Now I understand the concepts behind Joins clearly. Thank you :)
Before I was very confused with JOINTS but after watching the video with the formulas, examples and explanation I’m very much clear now. Hat’s off and thank you.
as i was a non IT student , after watching this video , will nvr forget this concept. thank you for your detailed explanation .
I have come across so many SQL joins video but this has very keen explanation ,we cannot forget that in life time Thank you for your valuable teaching
Explanation is "at par". I don't think I'm gonna forget this JOINS concept in this lifetime. Thanks Taufiq !!
Most Helpful video ever. I have been trying to study SQL for the past 6 years and no one and I mean no one from Kudvent to Udemy Courses taught this concept so beautifully. Thanks a lot. can't thank you enough,.
Cannot be more comprehensive than this. Thank You so much, Taufiq.
I was just watching this video randomly,just to brush up my concepts but I'd like to admit one thing for sure that when I learnt joins for the first time,I learned it in the Hard way.This is just some Brilliant stuff with extraordinary explanation👏
Sach ma phle bar mujhe join thik sa clear hua hai ...bahut bahut shukriya aapka....ma 3-4 video dekha pr utna badhiya samjha nahi ,,
I was searching for this type of join video with example from so many days . Thank you for how wonderfully u have explained...I didn't find anyone who is explaining like you... 🙏🙏
I swear to God this explanation of Joins is the best one I've ever watched
Seriously , You are best SQL teacher i have seen ever.
I have seen quite a few videos on Joins but this is probably the simplest and easiest way of understanding Joins. Kudos!!!
This will help in explaining joins in an Interview.
Keep up the good work 😀
Man you've explained exactly what i needed to know. You've no idea how relieved i feel after finally understanding the concept of joins. I needed to understand how sql works with each record of each table and you've explained that really well. Thanks a lot brother for this video. I'll definitely subscribe to your channel.
You saved me!! I have faced this question so many times in interviews but the concept never got clear..this video is Messiah for me!
best sql channel, I must say,
I have failed the interview at noon, I wish i have seen your videos before the interview.
Finally my joins concept are clear, thanks a lot. Appreciated😊
I have answered 2nd table by pausing the video.and I checked with you I got the results same thank you so much guruji
Best video ever made to explain SQL joins in a very simple and subtle way. Thankyou.
Correct brother ✅✔☑
Thank you so much no one other has explained it so well it has been around 3 months i was learning SQL but got to know today that my understanding for inner join was very wrong .
Feeling glad that i came across you tutorials
I have been so confused regarding when to use which one, this gave me so much clarity. Thank you for this wonderful lecture.
This is called a true education.... Thanks is a small word...❤❤
This is I suppose my first comment in years and years of using UA-cam. Just want to thank you provided such good explanation for joins . Thankyou ☺️
Thank you! I have never seen so amazing and yet simple explanation about how join works.
I got exact idea on how joins are performed. I'm showing you gratitude sincerely. Thank you so much for this kind of explanation💥
I bet no interviewer can confuse me with this sort of question anymore. Thanks TFQ!!
Asked similar question in my recent interview (inner, left, right, full outer, union, union all, intersect, minus). Thanks for sharing this video
The way you explain the concepts it becomes easier to understand. which shows that the effort and hard work you put in to master the SQL.
I got this same question in my interview 5 years ago!! 👍👍very good explanation! Thank you!
The you explained is exceptional. I will never forget the concept of joins in my life.
you are seriously oms , you are giving knowledge which is not present anywhere over the internet and about concept salute sir 🙋♂
I feel so good that I have come across your channel. These small concepts are nowhere described in the way you have brought in front of us. So minutely explained and all the concepts are becoming clear day by day. Thank you so much for all that you are doing ❤
Trust me i got this concept cleat after alot of months. Bro u rocks.
Just awesome. I will never forget this explanation again. Great job!
This was seriously needed. After watching this video my all doubts in joins got clear .
This is my default question from last few years to all whom I interviewed to find if they are good at fundamentals.
best way to explain joins i will never forget them in life time now
Even the one who created sql can't teach better than you about these concepts tq bro
Hi sir,
I was not able to get clear understanding about joins even I've watched and referred so many websites and UA-cam videos but finally I'm very glad and confident about joins after watching this video the way you explain with formula makes the whole scenario easy.
Thankyou so much for making great efforts to make the concepts understand easily
Best explanation of sql joins I have seen so far. Thank you for amazing content
Your content quality is very precise. Hope you run by this comment. Your contribution to the content world is much appreciated. Thankyou.
Best explanation on UA-cam for Joins
After watching many videos I have concluded that this is a good and simple explanation on joins, it is easy to understand. thank you friend
Glad to hear that
Thanks , searched for this content forever and finally after so long u made this video, one of its kind in most basic rules , really appreciate and please keep doing more of these videos, also nice that duplicate removing video has been made 😀
Very clear I came across many SQL videos but this one could able to understand the right concept.
Have been seeeing so many sql videos to learn joins but no one can teach like this❤ kudoooooooos🎉
Sometimes topics are simple but you need a right guy to deliver it for you in a simple way.
You got a subscriber ❤
JUST WOW!!! THIS EXPLANATION IS UNBEATABLE ❤❤❤❤ I AM LOST WITH WORDS 😊😊
Best ever video ….and literally now i am clear with this natural join …thank you for sharing.
Please keep posting interview questions and concepts like these frequently..these are very helpful..and please start tutorials on power bi also if possible..❤️
Hats off Toufiq. No one can explain better than this. We have a great teacher in the form you, who will help us with more information even for the small inputs which we have given to you. Kudos 👌👌🤞🤞. Thank you once again...
I love how you explain how SQL works, It's so clear anyone can understand it. I'm hoping that your next video would be on SQL optimization?
Nice explanation. Everyone should understand easily. Thanks fot uploading the vedio on joins
Thank you so much....I am attending interviews...I have faced same scenario....I am more clear now... Thank you again
After watching this video i have cleared the join concepts. Thank You So much
thank you so much for this, i am actively giving interview for sql but this question was asked in mostly all the interviews and was tricky. :D
best video for sql joins, hands down... Thank you
After this video , no need to see other video on join concept, clear explanation, thank you 🙏
'techTFQ' My favorite SQL teacher.
just stumbled onto your video.. Siifuuu!! abang, i owe you a good nasi lemak when i visit KL. terima kasih
Likes * Infinity.
Very Simple and easy to understand. also providing the tables is a great idea as anyone can practice it without getting lazy to write insert query.
FORMULAS FOR JOINS
💢
INNER JOIN = Inner join will only fetch the matching record from the opposite table you mentioned.
LEFT JOIN = Inner join + fetch any additional records from the left table which is not present in the right table.
RIGHT JOIN = Inner join + fetch any additional records from right table which is not present in left table.
FULL JOIN = Inner join + fetch any additional records from left table which is not present in right table + fetch any additional records from right table which is not present in left table.
TQ devraj
that was an ez and understandable explanation to grasp the concept at once :D
Cross Join = Match each record in the left table to each record in the right table Irrespective of the values.(Number of records in the left table * Number of records in the right table)
Thank you for this explanation Devraj 🙌🏻
Just say Wow. I have shared this video to many of my friends.
thank you . i had been struggling to understand the concept for a while .its crystal clear
man this video was simply awesome ! made me super confident about joins for my upcoming SQL interview !
Very Good Explanation, i have this doubt from many years, you have cleared this doubt easy way. Tha k you brother
Glad this helped 🙏🏼
I randomly find these video and after watching it was nice explanation and explain everything that was good no doubts remaining .Thanks
Your teaching style is superb. Very nicely explained. Thank you so much Taufiq.
seriously i have seen many videos on joins concept this the best video bro keep it up and THANK YOU
You have explained SQL JOIN extremely well in details, thumbs up with thanks.
Thank you very much 😊
For me.. you are the bahubali of SQL🎉
No confusion, very well explained.
Wow the way Toufiq explains is flawless 🤩
Much appreciated efforts. In my life, I will always remember the joins calculation :) . Thank you . Formula which u have given its Game changer :).
Finally cleared my concept of Joins.
Thanks
Thank you so much for this explanation. Never understood joins better than this!!
That was the best explaination, the formulas and how SQL works internally, thank you so much, please keep up the good work!
Thank you soo much for wonderful explanation, Actually I came across that question in my interview but I'm not able to answer that, but now I have confidence to answer that kind of question.
special teacher excellent teaching! we are lucky for watching your video brother
All cleared now....thank u so much for this great video.
Very simply way and with proper examples, joins are are explained here.Thanks for sharing.
Welcome
Your way of explanation is awesome sir. Thank you
This is one of the best videos on joins. I cannot thank you enough for this. 😊
Really awesome explanation, I was confused in Joins but you made it crystal clear sir. Thankyou, and keep posting more wonderful videos 😊
Bro, you're a lifesaver...
Thank you so much @TechTFQ, this same question was asked in my interview today and I was able to answer it very easily. It boosted my confidence too.
Thank you 😊
Wow amazing thank you for the explanation I finally understand the way Joins work!!!! I'm super excited and thankful thank you again!!
Sir I Love your teaching the way you explained with good understanding English... Thanks
Much awaited video. Please also make some videos on optimization of SQL query.
Thank you and performance tuning will cover in the future
performance tuning is requested from my side also
Noted
@@techTFQ Could you please start some videos on Datawarehouse databases with 6-10TB sizes and how to handle them.. Please share if any of your tutorial videos exists will take membership or subscription to watch
It will also be helpful if the way to read data from explain plan is also explained.
Best ever explanation I came across, on joins.
Thank you very much 😊
Very clear no one can explain like you
The boss of explaining SQL
Bro thank you so much you are awesome... Finally i understand completely these joins which i was dicey before during solving problems....