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

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 👋 ▬▬▬▬▬▬

▬▬▬▬▬▬ Related videos 👨‍🏫 ▬▬▬▬▬▬

▬▬▬▬▬▬▬ 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 📚 ▬▬▬▬▬▬▬

#sql #sqljoins #rdbms

[OdalyMontoya]

The animation is a GAME CHANGER! im a visua learner so this is perfect ! 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!

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

[alexsverenyak]

I don't leave comments often, but this is an amazing explanation! Thank you!

[HarshPatel-vylc]

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

[D_Ladybug]

You just gained my fellowship.

You did a terrific explanation.

Especially that visual representation, Awesome!

[Tinaisspooky]

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

[vishal_parajuli]

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

[samtadros]

Thanks a lot Anton, it's amazing.. crystal clear now 👍🙏

[embarrassed_dodo]

Great explanation! Animation really made it more clear

[ieatcrayons]

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

[a.v]

Very interesting video!! Thanks for the explanation

[whattheydoexactly]

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

[enriqueyt]

Muchas gracias los ejemplos visuales me fueron de mucha ayuda, excelente video !

[sudip]

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

[more-uvnl]

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 !

[akshittyagi]

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

[amrut]

Nicely articulated - thank you very much from Bharat