SQL Joins: Difference Between Inner/Left/Right/Outer Joins

  Рет қаралды 222,069

JomaClass

JomaClass

3 жыл бұрын

Join Jomaclass for full-length videos like this: joma.tech/dsa

Пікірлер: 312
@j.deluca8824
@j.deluca8824 3 жыл бұрын
You made me understand this in 10 minutes, whereas I had no idea what was going on in my university lectures. Thanks lol
@sebastianvalenzuela3762
@sebastianvalenzuela3762 3 жыл бұрын
same!
@sagardubey3800
@sagardubey3800 2 жыл бұрын
same this side even........Universities have pro max teachers and he is just a teacher that's the reason we are not understanding anything from there
@Stavros33GR1
@Stavros33GR1 2 жыл бұрын
same
@azimrahman3584
@azimrahman3584 2 жыл бұрын
Yes this one cleared the doubt in only 10 min
@naimaaqeel8092
@naimaaqeel8092 8 ай бұрын
Same here
@LaughinLoneStar
@LaughinLoneStar 9 ай бұрын
Join/Inner Join = Keep only that which matches Left join = Keep every thing from left table, only matches from right table Right join = Keep everything from right table, only matches from left table Outer join = Keep everything
@Hoppensagen
@Hoppensagen 2 жыл бұрын
Seriously, why do teachers not explain it simply like this, I was so confused, they just like explained in words what join is, and then write sql and show it and then I just have no idea what happened. Great visual.
@LoXena
@LoXena 3 жыл бұрын
Thank you this is the best explanation I've found so far!
@michellekelly1220
@michellekelly1220 2 жыл бұрын
I agree, thank you :)
@Chandni_geet
@Chandni_geet 2 жыл бұрын
Totally agree 👍
@BronProject
@BronProject 2 жыл бұрын
Agreed!! Simple and easy to remember.
@blindhydra
@blindhydra 2 жыл бұрын
This is probably one of the best data analysis videos i've seen on youtube, thanks man I really appreciate it
@thanhsangto8603
@thanhsangto8603 3 жыл бұрын
That was such an easy guide to understand. I hope your channel will early expand more. thank you so much.
@sparrowXXIII
@sparrowXXIII 2 жыл бұрын
🙏!!! I desperately needed a visual explanation like this. Going to dive in your other videos and see what other magic visualizations you have up your sleeve!
@solojohno1
@solojohno1 2 жыл бұрын
Outstanding video. Sub'd. This was explained so well that, by about 3 or 4 minutes into the video, I could anticipate the explanation of everything coming. And that's on a topic that I had previously found confusing. Nice work. I really appreciate it!
@programmingwww
@programmingwww 3 жыл бұрын
This guy explained joins and gave us perfect website about it 👏👏👏 Thank you!
@keylanshannon9492
@keylanshannon9492 2 жыл бұрын
This is really great content! Your visual break down solved about a week of my frustration!!
@fndfgbberb
@fndfgbberb 3 жыл бұрын
Thanks Joma! The visualization is awesome for JOIN explanations. Totally stealing that haha
@meme1033
@meme1033 2 жыл бұрын
This is the best explanation and visualization of how joins work on youtube - thank you!
@Ray-xl9iz
@Ray-xl9iz 2 жыл бұрын
Best join guide ive seen, and i feel like ive seen dozens of them. Thank you
@dalitsobotha7932
@dalitsobotha7932 Жыл бұрын
Short, sweet and straight to the point... Great stuff!
@Rextirant
@Rextirant 3 жыл бұрын
YOYOYO these be very educational, keep it up Joma!~!~
@Sebochan
@Sebochan Жыл бұрын
You explained it in the best way possible. I hope we could see more of this (SQL) from you!
@milindsagar3630
@milindsagar3630 2 жыл бұрын
I really love the way you teach, its just amazing.
@melissaduran6319
@melissaduran6319 2 жыл бұрын
I know people say this in nearly all programming/comp sci videos but yours was hands down the best explanation for this concept! I was only finding videos explaining the SQL but I am not learning that yet in my class so I didn't find it useful watching tutorials on it. Thank you so much for this detailed and thorough explanation!
@luisgaxiola-baqueiro6105
@luisgaxiola-baqueiro6105 2 жыл бұрын
Exactly, I have seen these boring theoretical explanations which make me be more confused at the end than I was at the beginning, but this explanation is just easy and so well explained.
3 жыл бұрын
Awesome Joma, very clearly explained, keep the good SQL stuff content!!!
@user-dc7oj3el7o
@user-dc7oj3el7o 2 жыл бұрын
Hey Joma, this is the best explanation I found about Join so far! Thank you!!
@krissstories5586
@krissstories5586 2 жыл бұрын
OMG, I spent 2 weeks hitting my head in the wall. These 10 minutes made me understand that joins..... Thank you man
@rahulmahbubani1392
@rahulmahbubani1392 Жыл бұрын
Best Video i have seen on joins, you did it better than any 1 hour video
@ayoubbellaoui5833
@ayoubbellaoui5833 2 жыл бұрын
simple and understood way to explain things that I have make me hate SQL one time but now anything is easy. Thank you !
@mohamedsuhailirfankhazi6628
@mohamedsuhailirfankhazi6628 7 ай бұрын
Very simple, concise and to the point. Exactly the way a tech tutorial is meant to be. Thank you!
@DanielLopez-gi8oy
@DanielLopez-gi8oy 2 жыл бұрын
omg this video made me understand thissss. Finally, I love u man
@backendadmin1217
@backendadmin1217 10 ай бұрын
The way you explain things in detail is fabulous, you just made my day.... This video is most amazing on entire youtube.
@jafetcalderon9505
@jafetcalderon9505 2 жыл бұрын
Man, this was so dam good!
@001tolky
@001tolky 2 жыл бұрын
That is the absolute best explanation I've found on this topic, print or video, including even Socratica's (which is saying something).
@VeronicaAngryPolak
@VeronicaAngryPolak Жыл бұрын
THANK YOU!! oh my gosh this finally set in, i finally get it after this video!!! thank you so much!!
@rubenkanya7342
@rubenkanya7342 2 жыл бұрын
Very well done, you covered in 10 minutes what I never grasped in years! Well Done!
@hanmuhammetbahtiyarov1644
@hanmuhammetbahtiyarov1644 2 жыл бұрын
truly awesome! you made it look way easier than i thought, thank you
@shigriasif1316
@shigriasif1316 4 ай бұрын
You did an amazing work. Before watching your video I haven't any idea about joins and Thanku so much for this content.
@Exceltech810
@Exceltech810 Жыл бұрын
Omg. This video is veryyyyy clear for joins. Thanks you!! It's better than most of similar video about joins
@stol3nsoul504
@stol3nsoul504 2 жыл бұрын
my teacher spend literally 3 full hours trying to explain this as complicated as he could, I didnt understand a single word. 10 minute video from you and boom i got it. Thanks so much buddy!!
@michaelkalu918
@michaelkalu918 Жыл бұрын
The most simplified and relateable tutorial on Join
@zayonnieves7035
@zayonnieves7035 3 жыл бұрын
Fantastic explanation! Thank you so much for making it so simple and clear.
@Morexod999
@Morexod999 2 жыл бұрын
Pretty good visualization of joining procedure, it gives more mean than just writting querys. Thank you, man, good presentation
@ghaziali3504
@ghaziali3504 2 жыл бұрын
Interactive content and you made it so easy to learn! Thanks
@proCode10
@proCode10 2 жыл бұрын
This is one of the best explanation videos I've seen on youtube.
@lppap9774
@lppap9774 3 жыл бұрын
Hey man, This was the best explanation after so many videos. 💯 THANK YOU!
@ahlamazam6211
@ahlamazam6211 2 жыл бұрын
also tell good website for triggers ans stored procedures for visualization
@basavarajpatil9821
@basavarajpatil9821 3 жыл бұрын
Great joma loved it
@michealbailey6372
@michealbailey6372 2 жыл бұрын
Man, great tutorial on joins. This explanation definitely helped my understanding on the subject.
@chrisnandasaputra2708
@chrisnandasaputra2708 2 жыл бұрын
THANK YOU SENPAI, this is awesome!!!!!!
@danielcortes4057
@danielcortes4057 3 жыл бұрын
Thank you, it was very useful, cheers from Mexico!
@melsmakeup9133
@melsmakeup9133 Жыл бұрын
Best video on youtube, thank you so much
@siamimam2109
@siamimam2109 2 жыл бұрын
I love how you explain!! Wish my professors were like u
@alpha-mf9rh
@alpha-mf9rh Ай бұрын
The visuals are so helpful!
@hobbyboy218155
@hobbyboy218155 3 жыл бұрын
Thank you for making this! Your explanation was clutch for my SQL exam tomorrow
@iuliannegoescu9887
@iuliannegoescu9887 8 ай бұрын
Best video ! Thank you I understand all about joins!
@hipman21
@hipman21 Жыл бұрын
This is such an amazing explanation, so simple and clear! Thankyou
@yanivshabi288
@yanivshabi288 2 жыл бұрын
It was very clear. Good job keeping it simple !
@melvinwookiee2696
@melvinwookiee2696 Жыл бұрын
I can't thank you enough... hands down the best video for beginnners
@_thattallguy__
@_thattallguy__ 3 жыл бұрын
This is actually helping me thankx👍
@fg0611
@fg0611 2 жыл бұрын
The best and simplest explanation about table joins in sql so far
@billnye7252
@billnye7252 3 ай бұрын
Thank you so much for the easy to understand video. My a whole lecture of class understandable in 10 minutes. The visuals helped a LOT.
@TheAjayTyler
@TheAjayTyler 2 жыл бұрын
Fantastic job breaking this down 👍
@FleeurFleeur
@FleeurFleeur 8 ай бұрын
This was the best explanation I've heard! Thank you
@Roodementary
@Roodementary 3 жыл бұрын
Thank you! This was 10 times easier than trying to read about it.
@namphantech
@namphantech Жыл бұрын
It's extremly visualize.I got uderstanding about all of type join in sql.Thanks bro
@azhar6055
@azhar6055 3 жыл бұрын
thank you Joma , this is extremely helpful
@MdForhad-fy7vx
@MdForhad-fy7vx Жыл бұрын
This is the video that um looking for...Thanks for this video
@eliasalvarez6881
@eliasalvarez6881 5 ай бұрын
Best JOINs video ever!!!
@Milen.Yodanov
@Milen.Yodanov Жыл бұрын
WOW that was amazing thanks brother!
@mzamomahaeng268
@mzamomahaeng268 Жыл бұрын
I honestly couldn't visual understand this concept until your explanation 🙏🤗👍best ever explanation thank you
@hasanozdemir1067
@hasanozdemir1067 2 жыл бұрын
Thank you so much for the video. It is super clear!
@mraprilonempeno
@mraprilonempeno 2 жыл бұрын
This is really good explanation of joins. Thank you! 👏🏼
@pallavishah6665
@pallavishah6665 2 жыл бұрын
Amazing man, thank you!
@fahadjavaid7126
@fahadjavaid7126 Жыл бұрын
You have explained these complex topics so nicely Cheers mate
@bhushanssable9641
@bhushanssable9641 2 жыл бұрын
The best video ever for joins ❤️
@itgetsdajobdone
@itgetsdajobdone 3 жыл бұрын
Thank you for this quick refresher!!
@djung8667
@djung8667 3 жыл бұрын
Congrats for this very good video!!
@roman_mf
@roman_mf Жыл бұрын
Great visualization, thank you so much :)
@parasarora5869
@parasarora5869 3 жыл бұрын
sir, you made it look so easy and fun 🔥🔥 ... great video 😇✌️...also thanks for the great reference site ❤️
@syhbeats
@syhbeats 3 жыл бұрын
great video! helped me refresh my knowledge of joins!!
@kukkakaali1751
@kukkakaali1751 Жыл бұрын
Best explanation of joins that I've seen, finally understood it now :)
@gevon1520
@gevon1520 Жыл бұрын
Thank you so much! I now understand it.
@rahulvaish3034
@rahulvaish3034 3 жыл бұрын
Thanks for posting this video !!
@codealong2456
@codealong2456 2 жыл бұрын
WOW! thanks reading the same thing confused me a lot, just so easy this way!
@missstella1584
@missstella1584 2 жыл бұрын
Best video about joins so far
@kalocsaymate8838
@kalocsaymate8838 3 жыл бұрын
Damn so clear video and so underreated. Thank you.
@ridexdie4012
@ridexdie4012 3 жыл бұрын
thank you for this, very helpful I refer back to the website from time to time
@omyni
@omyni Жыл бұрын
THANK YOU Sincerely, All visual learners everywhere
@Sean-uo9kw
@Sean-uo9kw 3 жыл бұрын
Super informative and easy to watch. Thanks!
@ugonmaajie2240
@ugonmaajie2240 8 ай бұрын
You're the best. Wow!!! I got it and well understood. ❤
@shubhampendbhaje9976
@shubhampendbhaje9976 2 жыл бұрын
I'll mark this tutorial as the easiest amongst all out there... It was so easy to understand everything 😲
@SzrIsTaken786
@SzrIsTaken786 2 жыл бұрын
clutching me up in my databases class actual plug
@zzang-boogie
@zzang-boogie 2 жыл бұрын
한 번에 이해가네요. 고맙습니다
@pranavkrishna6835
@pranavkrishna6835 3 жыл бұрын
Amazing lessons brother 🔥🙏
@robingrunsberg9572
@robingrunsberg9572 2 жыл бұрын
Greatly explained! Thank you so much for saving my a** :D You've just earned a new sub!
@biggyk87
@biggyk87 2 жыл бұрын
Thanks dude, much appreciated.
@daniellukyanchuk4642
@daniellukyanchuk4642 2 жыл бұрын
Maan, such a great explanation! Keep on the good work!
@pauloxavier3033
@pauloxavier3033 3 ай бұрын
Perfect explanation!! Simple and easy to understand!!
@tabithae3679
@tabithae3679 2 жыл бұрын
This was SUPER helpful! Thank you! 🥺
@thatomotaung6891
@thatomotaung6891 2 жыл бұрын
Such a good teacher, thanks for this.
@gloriyathomas
@gloriyathomas 2 жыл бұрын
The best intuitive explanation of joins! Thanks a lot..
@nymrod6620
@nymrod6620 2 жыл бұрын
Great explanation Joma ! , You should consider doing the entire SQL
@christiansailor2880
@christiansailor2880 8 ай бұрын
This video is excellent!
@mohamedlellah8318
@mohamedlellah8318 2 жыл бұрын
Thank you. This is a great video
@zalmonvorkjad
@zalmonvorkjad Жыл бұрын
Just perfect, thanks!
@twoadventureus
@twoadventureus 4 ай бұрын
Gold. Pure gold. lol Thanks for the summary. Great job!
6 SQL Joins you MUST know! (Animated + Practice)
9:47
Anton Putra
Рет қаралды 120 М.
Heartwarming moment as priest rescues ceremony with kindness #shorts
00:33
Fabiosa Best Lifehacks
Рет қаралды 13 МЛН
THE POLICE TAKES ME! feat @PANDAGIRLOFFICIAL #shorts
00:31
PANDA BOI
Рет қаралды 25 МЛН
Database Indexing for Dumb Developers
15:59
Laith Academy
Рет қаралды 46 М.
SQL "difference between" interview questions (part 1)
8:20
Crack Concepts
Рет қаралды 609 М.
What is Recursion? A Python Example
13:28
JomaClass
Рет қаралды 12 М.
Poison Wine Problem: Understanding Bits
7:49
JomaClass
Рет қаралды 20 М.
Learn SQL Joins
21:38
Decomplexify
Рет қаралды 44 М.
Learn Database Normalization - 1NF, 2NF, 3NF, 4NF, 5NF
28:34
Decomplexify
Рет қаралды 1,8 МЛН
Roadmap for Learning SQL
4:52
ByteByteGo
Рет қаралды 321 М.
Heartwarming moment as priest rescues ceremony with kindness #shorts
00:33
Fabiosa Best Lifehacks
Рет қаралды 13 МЛН