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

👨‍💼📈 Mentorship/On-the-Job Support/Consulting - calendly.com/antonputra/youtube or me@antonputra.com

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: 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/tutorials/tree/main/lessons/…

#sql #sqljoins #rdbms