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
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.
🙏!!! 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!
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
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!
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.
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!
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!!
![[#SHORTS CLIP] ครูอึ้ง กรรมการอึ้ง ฮ่าๆ l ซานิเบาได้เบา l One Playground](http://i.ytimg.com/vi/qeBTuMJs4t0/mqdefault.jpg)
You made me understand this in 10 minutes, whereas I had no idea what was going on in my university lectures. Thanks lol
same!
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
same
Yes this one cleared the doubt in only 10 min
Same here
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
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.
This is probably one of the best data analysis videos i've seen on youtube, thanks man I really appreciate it
Thank you this is the best explanation I've found so far!
I agree, thank you :)
Totally agree 👍
Agreed!! Simple and easy to remember.
That was such an easy guide to understand. I hope your channel will early expand more. thank you so much.
🙏!!!
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!
This guy explained joins and gave us perfect website about it 👏👏👏 Thank you!
This is really great content! Your visual break down solved about a week of my frustration!!
The most simplified and relateable tutorial on Join
Thanks Joma! The visualization is awesome for JOIN explanations. Totally stealing that haha
Short, sweet and straight to the point... Great stuff!
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
This is the best explanation and visualization of how joins work on youtube - thank you!
OMG, I spent 2 weeks hitting my head in the wall. These 10 minutes made me understand that joins..... Thank you man
Best join guide ive seen, and i feel like ive seen dozens of them. Thank you
YOYOYO these be very educational, keep it up Joma!~!~
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!
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.
I really love the way you teach, its just amazing.
Very well done, you covered in 10 minutes what I never grasped in years! Well Done!
You explained it in the best way possible. I hope we could see more of this (SQL) from you!
한 번에 이해가네요. 고맙습니다
Awesome Joma, very clearly explained, keep the good SQL stuff content!!!
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!
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!!
Hey Joma, this is the best explanation I found about Join so far! Thank you!!
simple and understood way to explain things that I have make me hate SQL one time but now anything is easy.
Thank you !
Best Video i have seen on joins, you did it better than any 1 hour video
Great joma loved it
Very simple, concise and to the point. Exactly the way a tech tutorial is meant to be. Thank you!
THANK YOU
Sincerely,
All visual learners everywhere
Interactive content and you made it so easy to learn! Thanks
THANK YOU!! oh my gosh this finally set in, i finally get it after this video!!! thank you so much!!
Fantastic explanation! Thank you so much for making it so simple and clear.
omg this video made me understand thissss. Finally, I love u man
truly awesome! you made it look way easier than i thought, thank you
Man, this was so dam good!
The best video ever for joins ❤️
THANK YOU SENPAI, this is awesome!!!!!!
Best video about joins so far
This is one of the best explanation videos I've seen on youtube.
Thank you for this quick refresher!!
Fantastic job breaking this down 👍
That is the absolute best explanation I've found on this topic, print or video, including even Socratica's (which is saying something).
The way you explain things in detail is fabulous, you just made my day.... This video is most amazing on entire youtube.
Omg. This video is veryyyyy clear for joins. Thanks you!! It's better than most of similar video about joins
You did an amazing work. Before watching your video I haven't any idea about joins and Thanku so much for this content.
Amazing man, thank you!
thank you Joma , this is extremely helpful
Thank you!
Best video !
Thank you
I understand all about joins!
The visuals are so helpful!
Thank you, it was very useful, cheers from Mexico!
Perfect explanation!! Simple and easy to understand!!
Thank you so much! I now understand it.
Hands down the best explanation of the history of the universe
It was very clear. Good job keeping it simple !
This was the best explanation I've heard! Thank you
Congrats for this very good video!!
Best video on youtube, thank you so much
Great visualization, thank you so much :)
Amazing lessons brother 🔥🙏
Best JOINs video ever!!!
Pretty good visualization of joining procedure, it gives more mean than just writting querys. Thank you, man, good presentation
Just perfect, thanks!
Thank you.
This is a great video
I can't thank you enough... hands down the best video for beginnners
thank you !
Super informative and easy to watch. Thanks!
The best and simplest explanation about table joins in sql so far
Thank you for the great work
WOW
that was amazing
thanks brother!
This video is excellent!
You are a great teacher.
This is such an amazing explanation, so simple and clear! Thankyou
This is really good explanation of joins. Thank you! 👏🏼
This is actually helping me thankx👍
Such a good teacher, thanks for this.
Thank you so much for the video. It is super clear!
Thanks dude, much appreciated.
great video! helped me refresh my knowledge of joins!!
This is the video that um looking for...Thanks for this video
Thank you! This was 10 times easier than trying to read about it.
Thanks for posting this video !!
I love how you explain!! Wish my professors were like u
Phenomenal, phenomenal phenomenal 👌👌👌👌.
simple and straight forward. Thanks
Thank you..!
best video of its kind!
Thank you
Hey man,
This was the best explanation after so many videos. 💯
THANK YOU!
also tell good website for triggers ans stored procedures for visualization
You're the best. Wow!!! I got it and well understood. ❤
Man, great tutorial on joins. This explanation definitely helped my understanding on the subject.
Thank you!!!!!
It's extremly visualize.I got uderstanding about all of type join in sql.Thanks bro
The best intuitive explanation of joins! Thanks a lot..
You have explained these complex topics so nicely Cheers mate
This was SUPER helpful! Thank you! 🥺
Thanks a lot!
THANK YOU