6 SQL Joins you MUST know! (Animated + Practice)

🔴 - To support my channel, I’d like to offer Mentorship/On-the-Job Support/Consulting - [e-mail]
To practice SQL, run the following commands:
docker run --detach --name my-postgres --env POSTGRES_PASSWORD=devops123 aputra/postgres-169:15.3
docker exec -it my-postgres psql -U postgres
▬▬▬▬▬ 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: [e-mail]
▬▬▬▬▬▬ 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

[@AntonPutra]

🔴 - To support my channel, I’d like to offer Mentorship/On-the-Job Support/Consulting - [e-mail]

[@2009nn]

@AntonPutra, what tool are you using to draw these awsome visualization that flow so beautifully. I'd really appreciate if you share the tool or the link where you can find this tool. Thanks in advance!

[@AntonPutra]

@@2009nn sure, it's adobe suite

[@OdalyMontoya]

The animation is a GAME CHANGER! im a visua learner so this is perfect ! thanks!

[@AntonPutra]

Thanks!!

[@EmpySoul]

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!!!!!!!!!!!!!!

[@Supershocky]

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!

[@AntonPutra]

Thank you, Supershocky!

[@HarshPatel-vy6lc]

Thank you so much! The dynamic visualization showing how data is pulled and related to the output helped a ton!

[@AntonPutra]

thanks!

[@olamidewilliams7670]

You just gained my fellowship.
You did a terrific explanation.
Especially that visual representation, Awesome!

[@AntonPutra]

thank you!!

[@vishal_parajuli]

love this type of visual explanation, saved my time , thank you so much..

[@AntonPutra]

thanks!

[@malek0311]

Great explanation! Thank you so much.

[@Tinaisspooky]

Thank you for this!!! Your graphics helped so much.

[@AntonPutra]

thanks!

[@embarrassed_dodo]

Great explanation! Animation really made it more clear

[@AntonPutra]

Thank Dodo!

[@k.chriscaldwell4141]

Superb. Thank you.

[@isme364]

great explanation thank you !

[@ieatcrayons3322]

ty so much!!! please make more like these!!

[@AntonPutra]

Will do!

[@amuthansakthivel3648]

Give this man an award!

[@AntonPutra]

❤

[@a.v7998]

Very interesting video!! Thanks for the explanation

[@whattheydoexactly7794]

very amazing docker image, it helped me a lot. Thank you so much.

[@AntonPutra]

welcome!

[@alexsg7433]

Well explained. Thank you!!🙏🏼

[@AntonPutra]

thanks!

[@more-uv4nl]

this video is more than amazing
it has a really good content and simplified
it is the perfect video for refreshement
thank you alot Sir !

[@AntonPutra]

thank you!

[@akshittyagi171]

Thanks man... I always had problem understanding joins.. Thanks a lot. ❤

[@AntonPutra]

welcome!

[@lucashoww]

Really well explained dude! Cheers

[@AntonPutra]

thanks!

[@pasinduvinsuka]

Thank you so much Anton ❤

[@AntonPutra]

Any time!

[@pabitrakb5291]

Cleared all doubts
Thank you ❤

[@AntonPutra]

Thanks for visiting pabitra!

[@moody_moon_coder]

Great video Mr Putra!

[@AntonPutra]

Thanks!

[@davdeveloper]

This was great.

[@sudip7949]

Very nice explanation with examples, i had hard time remembering these commands

[@AntonPutra]

thanks!

[@surajwaghmare4653]

Loved it ❤🎉

[@AntonPutra]

thanks!

[@Teezy-ny9im]

This was so helpful! Thank you.

[@AntonPutra]

thanks!

[@drcharupandey]

Awesome content bro❤

[@AntonPutra]

🤗

[@bossgd100]

Wow explanations are so clear

[@AntonPutra]

Thanks :)

[@rafi_45]

Thank you for explain this

[@AntonPutra]

my pleasure!

[@maryodogwu4272]

Great explanation. Thank you

[@AntonPutra]

thanks!

[@quest3604]

excellent explanation, thanks

[@AntonPutra]

thank you!

[@attiladren6990]

Congratulations to you Anton. This is a fantastic presentation. May I ask what software you used to make it? Thank you.

[@mnasirkhanctl]

Marvelous work!

[@AntonPutra]

thanks!

[@mehmetoz886]

perfect explanations

[@AntonPutra]

thanks!

[@raiyan22]

SOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO HELPFUL!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! THANKS A LOTTTTTTTTTTTTTT!!!!!!!!!!!!!!!!

[@USA_to_Asia_in_2024]

Thank you and God Bless!

[@AntonPutra]

❤️

[@Rockduds-ee2se]

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.

[@elmirahadidian5051]

thanks for this video

[@AntonPutra]

welcome

[@Kulec88]

круто сделано, визуальная составляющая очень помогает в ваших видео

[@AntonPutra]

spasibo!

[@jimmyfavereau]

thanks Anton : )

[@AntonPutra]

my pleasure :)

[@densstutorial9175]

hey anton thanks for the explanation, btw do your parent from Indonesia?

[@ysgurjar]

Subscribed ! What do you use for such a great animation?

[@AntonPutra]

thanks! adobe

[@samuelpartouche5931]

Hello Anton, what software you are using to make your animation ?
Thanks

[@AntonPutra]

Hi, Adobe suite

[@mearnest91]

Great video. Can I asked what you used for the animations?

[@AntonPutra]

thanks, adobe suite

[@Alexpudow]

Спасибо 🙂

[@AntonPutra]

pojaluysta :)

[@Aslamkaztro]

❤❤

[@AntonPutra]

❤

[@b.f.9484]

отлично

[@AntonPutra]

spasibo

[@padmavatitallapareddy8148]

This is really nice and clear video
where can we practice SQL ?
Thank you🙂

[@AntonPutra]

Just updated readme. I have build a custom docker image based on the Postgres that has all the data. Run the following commands to pull it
docker run --detach --name my-postgres --env POSTGRES_PASSWORD=devops123 aputra/postgres-169:15.3
docker exec -it my-postgres psql -U postgres

[@padmavatitallapareddy8148]

@@AntonPutra thank you

[@GabrielPozo]

👏🏾👏🏾👏🏾👏🏾

[@AntonPutra]

🙏

[@billionairepodcast]

are you related to indonesia by any chance ?

[@jetowl57]

ништяк объяснил, надеюсь начнёшь на русском выпускать видосы.

[@AntonPutra]

spasibo, da sdelau kak nibud v budushem

[@burhanuddinasgarali7678]

the video was great but if you could just look away when teaching, kinda creeps me out

[@AntonPutra]

ok :)

[@user-zw6vz4ec7n]

Nice explanation, but don't use Venn diagrams to explain joins, please. It does not clarify the situation, but introduces another layer of confusion.

[@AntonPutra]

Noted

[@jasonxb2998]

@@AntonPutra Funnily enough, the diagrams make a lot more sense after you understand joins. Not before. haha

[@jirehla-ab1671]

​@@AntonPutrathe problems with postgres database continers is that not all extensions are installable

[@atlantic_love]

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.

[@opprogram8620]

@@AntonPutradon’t listen to him. It’s extremely common to use these vent diagrams with joins.

[@nu7bla]

best explanation thank u

[@AntonPutra]

❤