this is the best explain i ever seen about sql. thanks for video
@RishabhMishraOfficial Жыл бұрын
Glad it was helpful! :)
@praveenjoshi9289 ай бұрын
I was struggling with joins in SQL, but after watching this video I've completely understood it. This is by far the best explanation of Joins on KZbin. Thanks.🙏
@RishabhMishraOfficial9 ай бұрын
Glad it helped! ✅️
@YourGirlPratiksha Жыл бұрын
The visualization of joins is too accurate in this video. It helped me a lot to understand the whole concept and fix it in my mind forever. Thanks!!
@RishabhMishraOfficial Жыл бұрын
Glad it helped! ✅️
@nabinbist1220 Жыл бұрын
Hyyy
@pritamchougale Жыл бұрын
I appreciate the effort you put into breaking down the complex concepts of joins and presenting them in a clear and easily digestible manner. Your explanations were detailed yet concise, making it much easier for me to grasp the nuances of inner joins, outer joins, left joins, and right joins. Thanks for this video man!
@RishabhMishraOfficial Жыл бұрын
Glad you liked it ✅️ n thanks for your encouragement 🚀
@aman.x Жыл бұрын
@pritamchougale looks like you pasted your comment directly from chat gpt😂😂
@ritesh958410 ай бұрын
HI rishabh which Mike you used for vedio
@vandanadevda71106 ай бұрын
Your way of explanation is too good it will be easy to understand specially for every beginner
@AyanKhan-nx3in4 ай бұрын
W3 par padhne jaa rha tha lekin you tube pe aaya socha dekh lu. To ap aa gye or pehli baar itna deeply join smj aaya hai
@smkrr6949Ай бұрын
This is what I expected from a person to teach and elevate me, not the other thing, I see this as a great thing.
@RishabhMishraOfficialАй бұрын
Glad you liked
@sahilarora718614 күн бұрын
Easiest explanation Rishabh brother. I was scared of JOINS. and now I learnt joins just within 21 mins.
@RishabhMishraOfficial14 күн бұрын
Glad it was helpful ✅️
@debopriyomukherjee3400 Жыл бұрын
The visualizations and the effort you made to make us understand is truly appreciable sir. Understood the whole things very easily.
@RishabhMishraOfficial Жыл бұрын
Glad it was helpful ✅️
@poojababar87464 ай бұрын
I think on YT nobody explained JOINS topic like the way you have explained. Gonna see all other SQL videos from your channel Thanks for this tutorial😇
@akshara29293 ай бұрын
So simple to understand! Best video of joins on youtube
@RishabhMishraOfficial3 ай бұрын
Glad it was helpful! ✅️
@jagrutipatil1020 Жыл бұрын
This was my last video for SQL joins.... Totally understand in one go only 🙏 Thanks sir🙂🙂
@RishabhMishraOfficial Жыл бұрын
Glad you liked ✅️
@MubarakAli-qs9qq3 ай бұрын
Me too
@smj006 Жыл бұрын
hands down the best video I have come across for learning SQL joins
@RishabhMishraOfficial Жыл бұрын
Glad you liked ✅️
@KamranHasanKhan Жыл бұрын
You do not know brother how much pressurize I was under, but really you r the hero of teaching, you always teach with basic ........ u do not know how happy i am....Thanks you so much..
@RishabhMishraOfficial Жыл бұрын
Glad it was helpful ✅️
@ashishvaghela9563 Жыл бұрын
Best explanation ever....isse simple way me koi sikha hi nhi sakta
@RishabhMishraOfficial Жыл бұрын
Glad you liked ✅️
@adityakumarchahal285210 ай бұрын
I can bet iss topic ko koi isse jyada easy poore youtube mein koi explain nhi kiya hoga🙂. Your efforts are really appreciable
@RishabhMishraOfficial10 ай бұрын
Glad you liked it ✅️
@adityaneve34825 ай бұрын
thank you sir. aapne jo smjaya hai. sab ekdam dimag mai gya hai. or koi video dekhne ki jaraurat nahi padi.
@musicyouneed.5.2 Жыл бұрын
i was trying to learn joins bt no one was explaining properly....and thank god i found you
@RishabhMishraOfficial Жыл бұрын
Glad it was helpful, all the best :)
@VIVAX51512 күн бұрын
I am learning from chatgpt but first time I am satisfied with yt video
@RishabhMishraOfficial10 күн бұрын
Glad you liked ✅️
@RizwanaAnjum.S2 ай бұрын
I watched many videos, but I didn't understand anything ...this video make sense how to use joins... very good explanation ... thank you for this clear explanation😊...
@RishabhMishraOfficialАй бұрын
Glad you liked the content ✅️
@GAURAV-v9u9 ай бұрын
AAJ MERA DOUBT CLEAR HUA YOU ARE THE BEST TEACHER ON KZbin.
@RishabhMishraOfficial9 ай бұрын
Glad it's helpful ✅️
@mohdmuzammil96588 ай бұрын
Thnqq soo much sir aaj tak joins ka topic koi shi se samjha nhi paya but apne kitne simple way m har doubt clear Kiya well done 👍 sir
@RishabhMishraOfficial8 ай бұрын
Glad you liked ✅️
@AnnaPaul-zw3jd6 ай бұрын
Whenever I came to you, never gone empty hand 😄, Tons of thanks
@RishabhMishraOfficial6 ай бұрын
Glad you liked the content ✅️
@anshuman.nagayach7 ай бұрын
This is undoubtedly the best explanation of joins I have ever seen.
@RishabhMishraOfficial7 ай бұрын
Glad you liked ✅️
@ppriyansh2327 Жыл бұрын
tum bahut mast kaam karta hai Rishabh bhai Apun ko tumko thank you bolne ka hai
@ayushdixit43459 ай бұрын
Samjhi me aa gya ak hi baar me thank you sir 👍
@RishabhMishraOfficial9 ай бұрын
Glad you liked ✅️
@codingwithzunaira6968 Жыл бұрын
Ya chez MN doond rhi thyi or khaii b smajh nhi arhi thyi thnku so much ❤
@khatrisinlondon2323 Жыл бұрын
Bhai bahot sahi tarike se samjhaya Joins ka concept with examples.....Thanks a lot...!!
@RishabhMishraOfficial Жыл бұрын
Glad you liked it ✅️
@rekhamalik3663 Жыл бұрын
One of the best videos on SQl i have found on KZbin. Thank you for such a great explanation
@RishabhMishraOfficial Жыл бұрын
Glad it was helpful! ✅️
@Travelling_With_Kamalu Жыл бұрын
Rishabh bhai. i am fully understand this concept ( inner join ,Left join ,Right join ,Full Outer join ) Thanku again you are explanation osam ..........N/
@RishabhMishraOfficial Жыл бұрын
Glad you liked it ✅️
@triptipal584 ай бұрын
Amazing explanation..I was struggling hard to understand the concept of sql joins but you made it very easy.. thanks a lot❤
@sandeeprajput76974 ай бұрын
The way He demonstrate 🔥🔥 ## 2024 LIKE 👉👉
@muhasawa5 ай бұрын
In 6:50 you stated that if column names in two tables aren't the same INNER JOIN wouldn't work. But that actually works. I have checked.
@nishantvats905 Жыл бұрын
I found it by mistake, but this is awesome content on SQL. Thank you Sir for a very good explanation.
@RishabhMishraOfficial Жыл бұрын
Glad it was helpful! ✅️ keep learning n keep growing 🚀
@vipinjadon7163 Жыл бұрын
Kya explain kiya. Hai sir with animation example .....,👌👌👌👌👌👌
@RishabhMishraOfficial Жыл бұрын
Glad you liked ✅️
@rajatdixit6720 Жыл бұрын
bhai mujhe kisi bhi channel pe samajh ni aya..but u made it..thanks a lot
@RishabhMishraOfficial Жыл бұрын
Glad it was helpful ✅️
@harshgaur_it_2864 Жыл бұрын
You explained these UNION concept in the most simplest way. Keep creating such content.👼
@RishabhMishraOfficial Жыл бұрын
Glad it was helpful ✅️
@makarsh29 Жыл бұрын
bhai , aapne bahut badiya s smajhaya hai sabhi vdos m , honestly never felt ki aur koi vdo dekhni pdegi....... bhai meko syntax bahut badiya s samaz aat hai ... but, jb practicle kro toh error bahut aate hai .. koi sugesstion/opinion for beginners ??? to how to deal it ,fluently.......
@Unfiltered-Travel-Tales Жыл бұрын
Mishraji, nicely done. As a QA its always hard to start on JOINS concept, but you made it very easy for me. Thank you so much..!!
@RishabhMishraOfficial Жыл бұрын
Glad you liked it ✅️
@Userm2040 Жыл бұрын
Hi Rishabh ! Just watched the full video 2 times. Thank you for your kindness and genorosity. Thank you for mentioning bits and pieces , detailed. God bless you !
@RishabhMishraOfficial Жыл бұрын
Glad it was helpful ✅️
@nabinbist1220 Жыл бұрын
BEST VIDEO OVER ALL KZbin OF DBMS ...LOVE VAI. Yaisai batana you wiI'll be rise one day.. Wau animation ,diagram of example ..love you yr
@RishabhMishraOfficial Жыл бұрын
Glad you liked ✅️
@user-wi9de9md2lАй бұрын
Inner join : matching records from both the tables Left join : inner join + remaining records in the left table Right join : inner join +remaining records in the right table
@sureshkamble15262 ай бұрын
i was struggling to understand this in simple easy way , this is the best video
@RishabhMishraOfficial2 ай бұрын
Glad it's helpful ✅️
@AnkiYouTube05Ай бұрын
this is the best explanation on Joins in KZbin 🙌🏻🙌🏻🙌🏻🙌🏻🙌🏻.... God bless you sir thank you so much ❤🤗😇🤟🏻👏🏻✨
@RishabhMishraOfficialАй бұрын
Glad it's helpful ✅️
@monikanishad87507 ай бұрын
Best and Simplest way to explain the typical topic of Sql .Thnankyou so much .🤗
@RishabhMishraOfficial7 ай бұрын
Glad you liked ✅️
@PurpleRainbow7 Жыл бұрын
Aap mere college me as a teacher lag jaao plzz 😩👍
@anupamsingh_______________5378 Жыл бұрын
Aap kya krte ho College m course
@AkashSingh-vloger10 ай бұрын
Tere college Wale afford nhi kr payege😂
@vinodbenda18607 ай бұрын
Shi baat 😅😅@@AkashSingh-vloger
@akshaymorey89866 ай бұрын
😂😂
@sayednizam63413 ай бұрын
Pyasa kuen ke pass jata hai, Kuan pyase ke pass nahi
@bhrtsinghal7 ай бұрын
Well explained. Anyone can understand in this layman's language. Thank You so much :)
@RishabhMishraOfficial7 ай бұрын
Happy to help ✅️
@RupeshDigheVlogs14 күн бұрын
sorted the joins in SQL..Thanks!!
@RishabhMishraOfficial14 күн бұрын
Glad you found it helpful ✅️
@sayanbiswas770 Жыл бұрын
Maza a gaya bhai dekh ke, 🙏🙏🙏🙏. Animations were really helpful.
@RishabhMishraOfficial Жыл бұрын
Glad you liked it ✨️
@hirdayram4437 Жыл бұрын
position depends on "payments p LEFT JOIN customers c" not on "c.customer_id = p.customer_id" , changing in "c.customer_id = p.customer_id" does not make any changes in output
@satyamusic1382 Жыл бұрын
I didn't learned this concept from udemy but from your video Thank a lot
@RishabhMishraOfficial Жыл бұрын
Happy to help ✅️
@Manojkumar-uh2fz7 күн бұрын
Finally got video. Best video on joins ever I see
@freefirelover-dj6stАй бұрын
Great Explanation i watch many vidoe on youtube of sql but you make my all doubt clear tnq❤
@RishabhMishraOfficialАй бұрын
Glad it helped ✅️
@AnujKumar-ux8vz19 күн бұрын
super explanation you have explained it soo well with the diagrams that it is easy to remember the joins.. thank you sooo much .. keep uploading more videos on SQL
@RishabhMishraOfficial18 күн бұрын
Glad it helped! Keep learning and growing 🚀
@archanarkumar97545 ай бұрын
Well explained. I was struggling to understand as I am a beginner but now its clear.
@RishabhMishraOfficial5 ай бұрын
Glad it's helpful ✅️
@HassanAli-x4o5 ай бұрын
Good❤❤
@omkarpharate9530 Жыл бұрын
Such an amazing explanation with Theory, Animation as well as practically query. I have seen lots of videos to understand this topic but no one can have a better explanation like this. Thanks a lot🙏
@RishabhMishraOfficial Жыл бұрын
Glad you liked it ✅️
@kp-vt6kt11 ай бұрын
I was able to tackle first round of interview after this session..thank u .. ❤
@RishabhMishraOfficial11 ай бұрын
Keep it up 🚀
@rickycsaecАй бұрын
Thanks for the video, but one most important point that you should clear. The order in which columns are listed in the ON condition does not affect which table is considered the "left" table. The left table is determined solely by its position in relation to the LEFT JOIN keyword.
@HK-nd9fe9 ай бұрын
Honestly speaking I never came across such a great explanation. Keep up your great work sir 😊
@RishabhMishraOfficial9 ай бұрын
Glad it's helpful ✅️
@himankshu Жыл бұрын
09:00 In joins, the column values should be the same. If column names are different, that doesn't matters. What matters is the values we are matching should be the same.
@RishabhMishraOfficial Жыл бұрын
yes that's correct (y). values should match not column names- what i mentioned in the video was an example
@mathematicsbyshraddha50509 ай бұрын
Thanks bhaiya apne bahot acche se explain kiya thanks a lot !!
@Engineer_Trader_01 Жыл бұрын
I think this is the perfect way of teaching. Keep doing great work
@RishabhMishraOfficial Жыл бұрын
Glad it was helpful ✅️
@MrKathuАй бұрын
You teaching skill better than all college teacher bro very clearly explain each and every point with real world example god bless you brother ❤🤩
@anjalihingu8708 Жыл бұрын
The best explanation i have ever seen for joins
@RishabhMishraOfficial Жыл бұрын
Glad you liked it ✅️
@rahulchhetija7297 Жыл бұрын
You're Genius, very well explained.
@RishabhMishraOfficial Жыл бұрын
Glad it was helpful! ✅️
@MuhammadWaseem-fw5tr Жыл бұрын
Thanks bro Amazing explanation 💗
@RishabhMishraOfficial Жыл бұрын
Glad you liked it ✅️
@amitdehraj82832 ай бұрын
A very nice way to explain and good demonstration of joins.. Thanks👍
@RishabhMishraOfficial2 ай бұрын
Glad it was helpful! ✅️
@GameGeekVishal Жыл бұрын
simplify explained with easy language so good
@RishabhMishraOfficial Жыл бұрын
Glad it was helpful ✅️
@akashmooke394924 күн бұрын
Nice explanation it helped me in my work . Where I am searching chat gpt to understand really appreciated good visualisation and explanation 👍
@RishabhMishraOfficial23 күн бұрын
Glad it's helpful! ✅️ Keep learning and growing🚀
@anupam44467 ай бұрын
column name doesn't need to be same. As you are writing `ON c.customer_id = p.customer_id`, is it not already specifying which columns to match? 6:50
@DanishKhan-u2c1l9 ай бұрын
One of the best explanations I have ever seen, thank you, sir.
@RishabhMishraOfficial9 ай бұрын
Glad it was helpful! ✅️
@ShamimKhan.17 Жыл бұрын
Please make a video on Subqueries problem solving in SQL. there is not available a single video on this topic well precise and Structured as u covered JOINS follow the same steps and please upload it. my doubts are perfectly cleared by watching this video thank you ☺
@Monika-c5n1y8 ай бұрын
Thanks for sharing this video. Way of explaining is very simple and understanding. Thanks again
@RishabhMishraOfficial8 ай бұрын
Glad it was helpful! ✅️
@jeenapatel43232 ай бұрын
thank you so much, i was very confused after watching this video I completly understood.
@RishabhMishraOfficial2 ай бұрын
Glad it's helpful ✅️
@UtkarshMishra-o5qАй бұрын
Thnkss sir this video eas really helpful. I did good at my exams
@RishabhMishraOfficialАй бұрын
Glad to hear it helped! Keep practicing and learning. 💪
@shahrukhchaus0000 Жыл бұрын
Very very Thank you sir for teaching us Join Concept in very easy way...🙂
@RishabhMishraOfficial Жыл бұрын
Glad you liked it ✅️
@AmitRana-us1tl7 ай бұрын
you have a calming personality, Sir. Good work.
@RishabhMishraOfficial7 ай бұрын
Glad you liked ✅️
@theofficialbakait50073 ай бұрын
Excellent and easy explanation brother...!
@RishabhMishraOfficial3 ай бұрын
Glad you liked ✅️
@SHB_short_videos7 ай бұрын
thank you sir.. One of the best video for understand joins....
@RishabhMishraOfficial7 ай бұрын
Glad you liked ✅️
@HassanShahbaz-r3s2 ай бұрын
Yar excellent sequence ma video bnai ha bahtreen samaj aai ha A1
@RishabhMishraOfficialАй бұрын
Glad you liked it ✅️
@hamzarauf320 Жыл бұрын
Outstanding Tutorial , I really appreciate your efforts and teaching methodology
@RishabhMishraOfficial Жыл бұрын
Glad it was helpful! ✅️
@kunalthorat93365 ай бұрын
Thank you boss ❤ bahut shandar explain Kiya apne ❤
@salonibhalla8622 Жыл бұрын
How would I thankyou. Your videos makes me believe that I can do it. Thanks Rishab🎉❤
@RishabhMishraOfficial Жыл бұрын
Glad you liked ✅️ to thank me it's very simple.. just get a good job 🚀
@reon_fernandes3 ай бұрын
Awesome video, your content was straight to the point. Thank you !
@RishabhMishraOfficial3 ай бұрын
Glad you liked ✅️
@ParasJain-s9o8 ай бұрын
Sir your teach method is very good I seen this video first time and really i understand in first time