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.
@thepratikjoshi44 Жыл бұрын
Couldn't agree more
@KevinElevates Жыл бұрын
@@thepratikjoshi44 +1
@abhi_updates Жыл бұрын
@@thepratikjoshi44 y so ?
@ramkan2478 Жыл бұрын
Very true.
@ardianthaputera6970 Жыл бұрын
indeed, this video practically settles it all. I can be sure that I now understand SQL joins
@sureshsekar6788 Жыл бұрын
I never seen this kind of clear explanation. After 7 years I am clear join concept. Thank you so much.
@guruputramahalingappa6954 ай бұрын
same here
@harsha8761 Жыл бұрын
The way you explain SQL even layman can understand SQL kudos to your explanation
@techTFQ Жыл бұрын
Thank you very much bro
@kumar-vu6xy Жыл бұрын
Great help 😊 sir
@tietan867 Жыл бұрын
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
@TussharPatnaik3 ай бұрын
Explanation is "at par". I don't think I'm gonna forget this JOINS concept in this lifetime. Thanks Taufiq !!
@technicalraman8848 Жыл бұрын
Salute Sir. I watched hundreds of videos on sql join but only ur video clear all concepts on Joins. Salute Sir.
@dracoreeper8 ай бұрын
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
@sampadatamhankar44294 ай бұрын
I generally dont comment on any videos, But I have to say i will never ever be confused about joins here onwards!! Gratitude!!
@madann71543 күн бұрын
This is I suppose my first comment in years and years of using KZfaq. Just want to thank you provided such good explanation for joins . Thankyou ☺️
@abhisheknakate9347 Жыл бұрын
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..!
@priyankachaparala2360 Жыл бұрын
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.
@MUSTAFA915224 ай бұрын
Sometimes topics are simple but you need a right guy to deliver it for you in a simple way. You got a subscriber ❤
@vikramamin2853 Жыл бұрын
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 😀
@Devrajsingh-ow7pr Жыл бұрын
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.
@isaitech4602 Жыл бұрын
TQ devraj
@radheyyyyyyy Жыл бұрын
that was an ez and understandable explanation to grasp the concept at once :D
@gilbertmutai8413 Жыл бұрын
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)
@purakh_singh20 күн бұрын
Thank you for this explanation Devraj 🙌🏻
@jagnyaseni4910 Жыл бұрын
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... 🙏🙏
@nimeelyamattluru2459 Жыл бұрын
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
@guruprasad9779Ай бұрын
Nice explanation. Everyone should understand easily. Thanks fot uploading the vedio on joins
@RiteshKumar-fe8xm2 ай бұрын
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 ,,
@hnaidu.pro21 Жыл бұрын
Cannot be more comprehensive than this. Thank You so much, Taufiq.
@anjiboy579014 күн бұрын
The you explained is exceptional. I will never forget the concept of joins in my life.
@ganeshgore214720 күн бұрын
After this video , no need to see other video on join concept, clear explanation, thank you 🙏
@poulamidas3203Ай бұрын
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 ❤
@seymur.halley Жыл бұрын
I swear to God this explanation of Joins is the best one I've ever watched
@shlokvishwasrao2504 Жыл бұрын
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👏
@saisanthoshthota7687 Жыл бұрын
This is called a true education.... Thanks is a small word...❤❤
@shantanumandal2930 Жыл бұрын
Please keep posting interview questions and concepts like these frequently..these are very helpful..and please start tutorials on power bi also if possible..❤️
@NawazKhan-go3fj Жыл бұрын
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.
@tenacity8281 Жыл бұрын
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,.
@sarikakumaripandey5492 ай бұрын
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!
@vasanthalakshmi2049 Жыл бұрын
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 😀
@yshu16314 ай бұрын
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
@rameshthanikonda7027 Жыл бұрын
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...
@rajathratnakaran7893 Жыл бұрын
I bet no interviewer can confuse me with this sort of question anymore. Thanks TFQ!!
@priyanshipundir55 Жыл бұрын
Seriously , You are best SQL teacher i have seen ever.
@mytamilchannel977 Жыл бұрын
I got this same question in my interview 5 years ago!! 👍👍very good explanation! Thank you!
@MdRizwan-uu9dv Жыл бұрын
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.
@anusmitakundu23663 ай бұрын
Thank you so much for this explanation. Never understood joins better than this!!
@khalid0669 Жыл бұрын
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?
@fawadh Жыл бұрын
best sql channel, I must say, I have failed the interview at noon, I wish i have seen your videos before the interview.
@basavaj474 Жыл бұрын
Have been seeeing so many sql videos to learn joins but no one can teach like this❤ kudoooooooos🎉
@pgrana155 ай бұрын
I have been so confused regarding when to use which one, this gave me so much clarity. Thank you for this wonderful lecture.
@rahul_mohite_7 Жыл бұрын
you are seriously oms , you are giving knowledge which is not present anywhere over the internet and about concept salute sir 🙋♂
@krithickg8126 Жыл бұрын
Best video ever made to explain SQL joins in a very simple and subtle way. Thankyou.
@sanjeevehandpicks Жыл бұрын
Correct brother ✅✔☑
@shrutisharma14344 ай бұрын
This is one of the best videos on joins. I cannot thank you enough for this. 😊
@Khansarah Жыл бұрын
This was seriously needed. After watching this video my all doubts in joins got clear .
@chaitu0644429 күн бұрын
No confusion, very well explained.
@negisaab74347 Жыл бұрын
Much awaited video. Please also make some videos on optimization of SQL query.
@techTFQ Жыл бұрын
Thank you and performance tuning will cover in the future
@prabhakarkirankumar2822 Жыл бұрын
performance tuning is requested from my side also
@techTFQ Жыл бұрын
Noted
@avinash8535 Жыл бұрын
@@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
@shraddhagupta2522 Жыл бұрын
It will also be helpful if the way to read data from explain plan is also explained.
@swapnadhuleАй бұрын
Thank you so much Thoufiq .kudos this is the best explanation on KZfaq🎉. Will never these concepts going forward for sure after watching this. 🎉
@kiran6466 ай бұрын
I got exact idea on how joins are performed. I'm showing you gratitude sincerely. Thank you so much for this kind of explanation💥
@yogeshchaudhary23332 ай бұрын
Really awesome explanation, I was confused in Joins but you made it crystal clear sir. Thankyou, and keep posting more wonderful videos 😊
@sujaa10008 ай бұрын
That was the best explaination, the formulas and how SQL works internally, thank you so much, please keep up the good work!
@unnatijaswani4832 Жыл бұрын
Awesome session @Toufiq! Ur videos are always really informative!! I was asked 2nd scenario in an interview & at that time, I did not know that 2 nulls are never same & I gave the wrong answer. 😒 Hats off! 👍💓😍😍😍😍😍😍
@priyajamuna5403 Жыл бұрын
Very clear I came across many SQL videos but this one could able to understand the right concept.
@ramakrishnapothuraju Жыл бұрын
seriously i have seen many videos on joins concept this the best video bro keep it up and THANK YOU
@raghavindersirkha656311 ай бұрын
best way to explain joins i will never forget them in life time now
@dasubabu5210 Жыл бұрын
Your way of explanation is awesome sir. Thank you
@rkkcode Жыл бұрын
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.
@user-ij3wt9cb2h3 ай бұрын
Bhai, video mast Laga🙏, all concepts are fully cleared. Love you bhai.... Laxmikant T.
@Babayagaom3 ай бұрын
What an explanation. I was looking for such video. Great💯
@kalaraniV-s4c16 күн бұрын
special teacher excellent teaching! we are lucky for watching your video brother
@mahi-che Жыл бұрын
Really excellent teaching. 🎈🎁🎉 Vera level bro
@Radhe_kanha0 Жыл бұрын
Best ever video ….and literally now i am clear with this natural join …thank you for sharing.
@mayankgupta70786 ай бұрын
You explained it really well I watched many videos but sometimes they confuse us but boss really hats off to you ... Hope you will make more such videos 😊
@ajinkyaadhotre5336 Жыл бұрын
man this video was simply awesome ! made me super confident about joins for my upcoming SQL interview !
@jaivalsartandmore....11995 ай бұрын
Much appreciated efforts. In my life, I will always remember the joins calculation :) . Thank you . Formula which u have given its Game changer :).
@G-R-O-O-T Жыл бұрын
Hi sir, I was not able to get clear understanding about joins even I've watched and referred so many websites and KZfaq 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
@relaxwithxane6878 Жыл бұрын
Trust me i got this concept cleat after alot of months. Bro u rocks.
@muthusamyperiyasamy5306 Жыл бұрын
Asked similar question in my recent interview (inner, left, right, full outer, union, union all, intersect, minus). Thanks for sharing this video
@myfirstpet6813 Жыл бұрын
Bro, you are amazing, I would agree to many commenters here, the way you have explained it , joins seem so easy to understand. Do come up with many more awesome videos like this. GLAD WE ALL FOUND YOU!! hooked now sir.. :)
@vismaya39 ай бұрын
Very simply way and with proper examples, joins are are explained here.Thanks for sharing.
@techTFQ8 ай бұрын
Welcome
@anismangure8536 Жыл бұрын
Best explanation on KZfaq for Joins
@skdonsingh Жыл бұрын
Just say Wow. I have shared this video to many of my friends.
@aravinds923 Жыл бұрын
'techTFQ' My favorite SQL teacher.
@kimyangKo Жыл бұрын
Very clear no one can explain like you
@mananchoudhary9896 Жыл бұрын
Your content quality is very precise. Hope you run by this comment. Your contribution to the content world is much appreciated. Thankyou.
@crazydot81 Жыл бұрын
Very explanatory and reasonably short. Your videos are top ones. Great thanks!
@rohittrimbake-qr8gr Жыл бұрын
Sir I Love your teaching the way you explained with good understanding English... Thanks
@sakshisharma501811 ай бұрын
Toufiq ..u r a great teacher ...i literally enjoyed learning sql with you ...please make videos related to phython also
@tekimadv9 ай бұрын
Hi pls checkout my channel for both sql and python tuts
@nadya67245 ай бұрын
I have been looking out for this concept for a long time . Thank you for sharing this video
@okygy21252 ай бұрын
Ultimate video for joins. Excellent bro. 👏
@ray___19 ай бұрын
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
@techTFQ8 ай бұрын
Glad to hear that
@srinivasv3282 Жыл бұрын
This is my default question from last few years to all whom I interviewed to find if they are good at fundamentals.
@Adikes_InfoTech5 ай бұрын
Hi Sir, till now I had many confusions on Joins concept. But with your explanation my brain understood correctly, and I have created some examples like this, and I have answered the output correctly without writing the code. Thank you so much for clarifying this topic. If we can get this kind of explanations anywhere, I think we can have more coding developers right!!!!🤸♀🤸♀😎😎
@jayeshchoudhary6110 Жыл бұрын
I randomly find these video and after watching it was nice explanation and explain everything that was good no doubts remaining .Thanks
@srinathgadde55109 ай бұрын
It was the best video on youtube related to joins, Thanks for the video
@techTFQ8 ай бұрын
You're welcome :)
@prasadborra198410 ай бұрын
Best ever explanation I came across, on joins.
@techTFQ8 ай бұрын
Thank you very much 😊
@NitinKumar-wk7yz Жыл бұрын
After watching this video i have cleared the join concepts. Thank You So much
@vamsiprince9529 Жыл бұрын
Even the one who created sql can't teach better than you about these concepts tq bro
@Jasmine-zb2zd Жыл бұрын
Wow amazing thank you for the explanation I finally understand the way Joins work!!!! I'm super excited and thankful thank you again!!
@shaliniarya2025 ай бұрын
Finally cleared my concept of Joins. Thanks
@henrylokrit232 Жыл бұрын
The best explanation for SQL joins. Thank you for this video👍🏿
@harshshah9006 Жыл бұрын
Thnk u so much♥️...I have my jio saavan interview coming up . This and ur other videos helped a lot .
@g.hemanthkumar6078 Жыл бұрын
the way you explain , i liked it. thank you so much. please keep posted more SQL interview question. it will help us to crack the interview.
@clementihammock757210 ай бұрын
You have explained SQL JOIN extremely well in details, thumbs up with thanks.
@techTFQ8 ай бұрын
Thank you very much 😊
@toch8528 Жыл бұрын
just stumbled onto your video.. Siifuuu!! abang, i owe you a good nasi lemak when i visit KL. terima kasih
@prakashkoppurapu Жыл бұрын
Explained very clearly bro 😊 Till now no one explained like you thank you atlast found a good video
@BRIANYB3125 ай бұрын
Bro, you're a lifesaver...
@shivpatil-bm1nrАй бұрын
best video on youtube for joins..❤❤
@joshipodili6210 Жыл бұрын
Very Good Explanation, i have this doubt from many years, you have cleared this doubt easy way. Tha k you brother
@techTFQ Жыл бұрын
Glad this helped 🙏🏼
@AnkitSharma-pu5gc Жыл бұрын
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.
@tacijjola9 ай бұрын
Wow, wonderful! Thank you so much, extremely clear and deep explanation of the different JOINS. Thanx! :D