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]

[@OdalyMontoya]

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

[@AntonPutra]

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!

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

[@HarshPatel-vy6lc]

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

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

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

[@amuthansakthivel3648]

Give this man an award!

[@AntonPutra]

❤

[@ieatcrayons3322]

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

[@AntonPutra]

Will do!

[@isme364]

great explanation thank you !

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

[@moody_moon_coder]

Great video Mr Putra!

[@AntonPutra]

Thanks!

[@lucashoww]

Really well explained dude! Cheers

[@AntonPutra]

thanks!

[@alexsg7433]

Well explained. Thank you!!🙏🏼

[@AntonPutra]

thanks!

[@davdeveloper]

This was great.

[@pasinduvinsuka]

Thank you so much Anton ❤

[@AntonPutra]

Any time!

[@sudip7949]

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

[@AntonPutra]

thanks!

[@akshittyagi171]

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

[@AntonPutra]

welcome!

[@surajwaghmare4653]

Loved it ❤🎉

[@AntonPutra]

thanks!

[@drcharupandey]

Awesome content bro❤

[@AntonPutra]

🤗

[@pabitrakb5291]

Cleared all doubts Thank you ❤

[@AntonPutra]

Thanks for visiting pabitra!

[@maryodogwu4272]

Great explanation. Thank you

[@AntonPutra]

thanks!

[@mnasirkhanctl]

Marvelous work!

[@AntonPutra]

thanks!

[@Teezy-ny9im]

This was so helpful! Thank you.

[@AntonPutra]

thanks!

[@Kulec88]

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

[@AntonPutra]

spasibo!

[@muhammadrafiuddin8319]

Thank you for explain this

[@AntonPutra]

my pleasure!

[@quest3604]

excellent explanation, thanks

[@AntonPutra]

thank you!

[@USA_to_Asia_in_2024]

Thank you and God Bless!

[@AntonPutra]

❤️

[@bossgd100]

Wow explanations are so clear

[@AntonPutra]

Thanks :)

[@elmirahadidian5051]

thanks for this video

[@AntonPutra]

welcome

[@raiyan22]

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

[@attiladren6990]

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

[@mehmetoz886]

perfect explanations

[@AntonPutra]

thanks!

[@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.

[@jimmyfavereau]

thanks Anton : )

[@AntonPutra]

my pleasure :)

[@ysgurjar]

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

[@AntonPutra]

thanks! adobe

[@Alexpudow]

Спасибо 🙂

[@AntonPutra]

pojaluysta :)

[@densstutorial9175]

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

[@mearnest91]

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

[@AntonPutra]

thanks, adobe suite

[@samuelpartouche5931]

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

[@AntonPutra]

Hi, Adobe suite

[@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

[@Aslamkaztro]

❤❤

[@AntonPutra]

❤

[@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]

❤