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
@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
3 жыл бұрын
same!
@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
2 жыл бұрын
same
@azimrahman3584
2 жыл бұрын
Yes this one cleared the doubt in only 10 min
@naimaaqeel8092
8 ай бұрын
Same here
@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.
@blindhydra
2 жыл бұрын
This is probably one of the best data analysis videos i've seen on youtube, thanks man I really appreciate it
@LoXena
3 жыл бұрын
Thank you this is the best explanation I've found so far!
@michellekelly1220
2 жыл бұрын
I agree, thank you :)
@Chandni_geet
2 жыл бұрын
Totally agree 👍
@BronProject
2 жыл бұрын
Agreed!! Simple and easy to remember.
@thanhsangto8603
3 жыл бұрын
That was such an easy guide to understand. I hope your channel will early expand more. thank you so much.
@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!
@keylanshannon9492
2 жыл бұрын
This is really great content! Your visual break down solved about a week of my frustration!!
@programmingwww
3 жыл бұрын
This guy explained joins and gave us perfect website about it 👏👏👏 Thank you!
@Ray-xl9iz
2 жыл бұрын
Best join guide ive seen, and i feel like ive seen dozens of them. Thank you
@fndfgbberb
3 жыл бұрын
Thanks Joma! The visualization is awesome for JOIN explanations. Totally stealing that haha
@meme1033
2 жыл бұрын
This is the best explanation and visualization of how joins work on youtube - thank you!
@dalitsobotha7932
Жыл бұрын
Short, sweet and straight to the point... Great stuff!
@mohamedsuhailirfankhazi6628
7 ай бұрын
Very simple, concise and to the point. Exactly the way a tech tutorial is meant to be. Thank you!
@rubenkanya7342
2 жыл бұрын
Very well done, you covered in 10 minutes what I never grasped in years! Well Done!
@Sebochan
Жыл бұрын
You explained it in the best way possible. I hope we could see more of this (SQL) from you!
@user-dc7oj3el7o
2 жыл бұрын
Hey Joma, this is the best explanation I found about Join so far! Thank you!!
@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!
3 жыл бұрын
Awesome Joma, very clearly explained, keep the good SQL stuff content!!!
@krissstories5586
3 жыл бұрын
OMG, I spent 2 weeks hitting my head in the wall. These 10 minutes made me understand that joins..... Thank you man
@rahulmahbubani1392
Жыл бұрын
Best Video i have seen on joins, you did it better than any 1 hour video
@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!!
@Rextirant
3 жыл бұрын
YOYOYO these be very educational, keep it up Joma!~!~
@michaelkalu918
Жыл бұрын
The most simplified and relateable tutorial on Join
@milindsagar3630
2 жыл бұрын
I really love the way you teach, its just amazing.
@Exceltech810
Жыл бұрын
Omg. This video is veryyyyy clear for joins. Thanks you!! It's better than most of similar video about joins
@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 !
@Roodementary
3 жыл бұрын
Thank you! This was 10 times easier than trying to read about it.
@proCode10
2 жыл бұрын
This is one of the best explanation videos I've seen on youtube.
@ghaziali3504
2 жыл бұрын
Interactive content and you made it so easy to learn! Thanks
@VeronicaAngryPolak
Жыл бұрын
THANK YOU!! oh my gosh this finally set in, i finally get it after this video!!! thank you so much!!
@hanmuhammetbahtiyarov1644
2 жыл бұрын
truly awesome! you made it look way easier than i thought, thank you
@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
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.
@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).
@backendadmin1217
10 ай бұрын
The way you explain things in detail is fabulous, you just made my day.... This video is most amazing on entire youtube.
@danielcortes4057
3 жыл бұрын
Thank you, it was very useful, cheers from Mexico!
@zayonnieves7035
3 жыл бұрын
Fantastic explanation! Thank you so much for making it so simple and clear.
@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.
@Morexod999
2 жыл бұрын
Pretty good visualization of joining procedure, it gives more mean than just writting querys. Thank you, man, good presentation
@yanivshabi288
2 жыл бұрын
It was very clear. Good job keeping it simple !
@michealbailey6372
2 жыл бұрын
Man, great tutorial on joins. This explanation definitely helped my understanding on the subject.
@DanielLopez-gi8oy
2 жыл бұрын
omg this video made me understand thissss. Finally, I love u man
@melvinwookiee2696
Жыл бұрын
I can't thank you enough... hands down the best video for beginnners
@billnye7252
4 ай бұрын
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.
@jafetcalderon9505
2 жыл бұрын
Man, this was so dam good!
@fg0611
2 жыл бұрын
The best and simplest explanation about table joins in sql so far
@FleeurFleeur
8 ай бұрын
This was the best explanation I've heard! Thank you
@tabithae3679
2 жыл бұрын
This video is so helpful that I've come back to watch it 4 separate times.
@iuliannegoescu9887
8 ай бұрын
Best video ! Thank you I understand all about joins!
@chrisnandasaputra2708
2 жыл бұрын
THANK YOU SENPAI, this is awesome!!!!!!
@azhar6055
3 жыл бұрын
thank you Joma , this is extremely helpful
@basavarajpatil9821
3 жыл бұрын
Great joma loved it
@itgetsdajobdone
3 жыл бұрын
Thank you for this quick refresher!!
@markovujanic
10 күн бұрын
Thanks for all animations and grate narration, I think we can improve on the mental model of your presentation, especially for outer joins. Inner Join 1. Cartesian product created 2. Keep rows matching condition (USING/ON) Left Join 1. Cartesian product created 2. Keep rows matching condition (USING/ON) 3. Left join (add back left table unmatched rows, assign them to null) Most important part is that every JOIN starts with Cartesian product, then some filtering + variation
@mraprilonempeno
2 жыл бұрын
This is really good explanation of joins. Thank you! 👏🏼
@eliasalvarez6881
6 ай бұрын
Best JOINs video ever!!!
@Sean-uo9kw
3 жыл бұрын
Super informative and easy to watch. Thanks!
@TheAjayTyler
2 жыл бұрын
Fantastic job breaking this down 👍
@siamimam2109
2 жыл бұрын
I love how you explain!! Wish my professors were like u
@jaymanzoom
2 жыл бұрын
Didn't matter how I asked my teacher I couldn't understand what the hell the differences between the joins were. Thank you for making it so easy and showing visual examples.
@gloriyathomas
2 жыл бұрын
The best intuitive explanation of joins! Thanks a lot..
@syhbeats
3 жыл бұрын
great video! helped me refresh my knowledge of joins!!
@lppap9774
3 жыл бұрын
Hey man, This was the best explanation after so many videos. 💯 THANK YOU!
@gentleechoes6
2 жыл бұрын
also tell good website for triggers ans stored procedures for visualization
@kukkakaali1751
2 жыл бұрын
Best explanation of joins that I've seen, finally understood it now :)
@missstella1584
2 жыл бұрын
Best video about joins so far
@hobbyboy218155
3 жыл бұрын
Thank you for making this! Your explanation was clutch for my SQL exam tomorrow
@djung8667
3 жыл бұрын
Congrats for this very good video!!
@MdForhad-fy7vx
Жыл бұрын
This is the video that um looking for...Thanks for this video
@hipman21
Жыл бұрын
This is such an amazing explanation, so simple and clear! Thankyou
@hasanozdemir1067
2 жыл бұрын
Thank you so much for the video. It is super clear!
@codealong2456
2 жыл бұрын
WOW! thanks reading the same thing confused me a lot, just so easy this way!
@roman_mf
2 жыл бұрын
Great visualization, thank you so much :)
@alpha-mf9rh
Ай бұрын
The visuals are so helpful!
@pauloxavier3033
4 ай бұрын
Perfect explanation!! Simple and easy to understand!!
@shubhampendbhaje9976
2 жыл бұрын
I'll mark this tutorial as the easiest amongst all out there... It was so easy to understand everything 😲
@Milen.Yodanov
Жыл бұрын
WOW that was amazing thanks brother!
@ridexdie4012
3 жыл бұрын
thank you for this, very helpful I refer back to the website from time to time
@twoadventureus
5 ай бұрын
Gold. Pure gold. lol Thanks for the summary. Great job!
@fahadjavaid7126
Жыл бұрын
You have explained these complex topics so nicely Cheers mate
@Gn0ume
Жыл бұрын
I didn't know you know actually anything about coding! Good job!
@bhushanssable9641
2 жыл бұрын
The best video ever for joins ❤️
@ugonmaajie2240
9 ай бұрын
You're the best. Wow!!! I got it and well understood. ❤
@melsmakeup9133
Жыл бұрын
Best video on youtube, thank you so much
@zzang-boogie
2 жыл бұрын
한 번에 이해가네요. 고맙습니다
@pallavishah6665
2 жыл бұрын
Amazing man, thank you!
@robingrunsberg9572
2 жыл бұрын
Greatly explained! Thank you so much for saving my a** :D You've just earned a new sub!
@tabithae3679
2 жыл бұрын
This was SUPER helpful! Thank you! 🥺
@kalocsaymate8838
3 жыл бұрын
Damn so clear video and so underreated. Thank you.
@gevon1520
Жыл бұрын
Thank you so much! I now understand it.
@rahulvaish3034
3 жыл бұрын
Thanks for posting this video !!
@thatomotaung6891
2 жыл бұрын
Such a good teacher, thanks for this.
@shadynit
Жыл бұрын
this website you mentioned is perfect. Thanks
@mohamedlellah8318
2 жыл бұрын
Thank you. This is a great video
@manavdubey7670
5 ай бұрын
very nicely explained . Thanks for the video !
@natalevelardi1585
2 жыл бұрын
Best explanation i've ever seen by far thank you!
@namphantech
Жыл бұрын
It's extremly visualize.I got uderstanding about all of type join in sql.Thanks bro
@_thattallguy__
3 жыл бұрын
This is actually helping me thankx👍
@caesarcastro9583
Жыл бұрын
simple and straight forward. Thanks
@martinamilitello3893
2 жыл бұрын
Best explanation ever? Best explanation ever! Thanks a lot!
@nymrod6620
2 жыл бұрын
Great explanation Joma ! , You should consider doing the entire SQL
Пікірлер: 314