6 SQL Joins you MUST know! (Animated + Practice)
122,662
Published 2023-07-23
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: www.linkedin.com/in/anton-putra
► Twitter/X: twitter.com/antonvputra
► GitHub: github.com/antonputra
► Email: [email protected]
▬▬▬▬▬▬ 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/tutorials/tree/main/lessons/…
#sql #sqljoins #rdbms
All Comments (21)
-
🔴 - 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!
-
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!
-
I don't leave comments often, but this is an amazing explanation! Thank you!
-
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!
-
You just gained my fellowship. You did a terrific explanation. Especially that visual representation, Awesome!
-
Thank you for this!!! Your graphics helped so much.
-
love this type of visual explanation, saved my time , thank you so much..
-
Great explanation! Thank you so much.
-
Great explanation! Animation really made it more clear
-
ty so much!!! please make more like these!!
-
Great video Mr Putra!
-
Superb. Thank you.
-
Muchas gracias los ejemplos visuales me fueron de mucha ayuda, excelente video !
-
great explanation thank you !
-
Really well explained dude! Cheers
-
Thank you so much Anton ❤
-
Well explained. Thank you!!🙏🏼
-
very amazing docker image, it helped me a lot. Thank you so much.