6 SQL Joins you MUST know! (Animated + Practice)
ฝัง
- เผยแพร่เมื่อ 16 พ.ค. 2024
- 🔴 - To support my channel, I’d like to offer Mentorship/On-the-Job Support/Consulting - me@antonputra.com
▬▬▬▬▬ Experience & Location 💼 ▬▬▬▬▬
► I’m a Senior Software Engineer at Juniper Networks (12+ years of experience)
► Located in San Francisco Bay Area, CA (US citizen)
▬▬▬▬▬▬ Connect with me 👋 ▬▬▬▬▬▬
► LinkedIn: / anton-putra
► Twitter/X: / antonvputra
► GitHub: github.com/antonputra
► Email: me@antonputra.com
▬▬▬▬▬▬ Related videos 👨🏫 ▬▬▬▬▬▬
👉 [Playlist] Database Tutorials: • Database Tutorials
▬▬▬▬▬▬▬ Timestamps ⏰ ▬▬▬▬▬▬▬
0:00 Intro
0:33 Primary and Foreign keys
2:39 Inner Join
5:00 Left Join
5:47 Right Join
7:07 Full Join
8:09 Union
9:00 Cross Join
▬▬▬▬▬▬▬ Source Code 📚 ▬▬▬▬▬▬▬
► GitHub: github.com/antonputra/tutoria...
#sql #sqljoins #rdbms - วิทยาศาสตร์และเทคโนโลยี
🔴 - To support my channel, I’d like to offer Mentorship/On-the-Job Support/Consulting - me@antonputra.com
The animation is a GAME CHANGER! im a visua learner so this is perfect ! thanks!
Thanks!!
I always had a bit of confusion about how joins worked and how the resulting rows were formed, but the animations make it very clear. Thanks Anton!
Thank you, Supershocky!
OMG, this videos is absolutely incredible. I've been working with SQL for years but now I really understand JOINs. Such a great didactic explanation. Thanks!!!!!!!!!!!!!!
Thank you so much! The dynamic visualization showing how data is pulled and related to the output helped a ton!
thanks!
Great explanation! Thank you so much.
Thank you for this!!! Your graphics helped so much.
thanks!
great explanation thank you !
Great explanation! Animation really made it more clear
Thank Dodo!
ty so much!!! please make more like these!!
Will do!
Well explained. Thank you!!🙏🏼
thanks!
very amazing docker image, it helped me a lot. Thank you so much.
welcome!
This was great.
Very interesting video!! Thanks for the explanation
Thank you so much Anton ❤
Any time!
Awesome content bro❤
🤗
Thanks man... I always had problem understanding joins.. Thanks a lot. ❤
welcome!
Cleared all doubts
Thank you ❤
Thanks for visiting pabitra!
Really well explained dude! Cheers
thanks!
This was so helpful! Thank you.
thanks!
Loved it ❤🎉
thanks!
Very nice explanation with examples, i had hard time remembering these commands
thanks!
Great video Mr Putra!
Thanks!
Marvelous work!
thanks!
Great explanation. Thank you
thanks!
Thank you for explain this
my pleasure!
Congratulations to you Anton. This is a fantastic presentation. May I ask what software you used to make it? Thank you.
perfect explanations
thanks!
excellent explanation, thanks
thank you!
Wow explanations are so clear
Thanks :)
thanks for this video
welcome
Anton thank you, your video helped me a lot. You said that computer read and compare the fields in a different way, that is not visible for the user. Will be great if you make a video explain it or recommends some great book that teach it.
SOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO HELPFUL!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! THANKS A LOTTTTTTTTTTTTTT!!!!!!!!!!!!!!!!
hey anton thanks for the explanation, btw do your parent from Indonesia?
thanks Anton : )
my pleasure :)
круто сделано, визуальная составляющая очень помогает в ваших видео
spasibo!
Спасибо 🙂
pojaluysta :)
Hello Anton, what software you are using to make your animation ?
Thanks
Hi, Adobe suite
Subscribed ! What do you use for such a great animation?
thanks! adobe
Great video. Can I asked what you used for the animations?
thanks, adobe suite
are you related to indonesia by any chance ?
👏🏾👏🏾👏🏾👏🏾
🙏
отлично
spasibo
ништяк объяснил, надеюсь начнёшь на русском выпускать видосы.
spasibo, da sdelau kak nibud v budushem
Nice explanation, but don't use Venn diagrams to explain joins, please. It does not clarify the situation, but introduces another layer of confusion.
Noted
@@AntonPutra Funnily enough, the diagrams make a lot more sense after you understand joins. Not before. haha
@@AntonPutrathe problems with postgres database continers is that not all extensions are installable
Venn diagrams (in another video) were just what I needed to understand what was going on at the database level of the scheme. The venn showed one table having something in common with another.
@@AntonPutradon’t listen to him. It’s extremely common to use these vent diagrams with joins.