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

👨‍💼📈 Mentorship/On-the-Job Support/Consulting - https://calendly.com/antonputra/youtube or [email protected] 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: https://www.linkedin.com/in/anton-putra ► Twitter/X: https://twitter.com/antonvputra ► GitHub: https://github.com/antonputra ► Email: [email protected] ▬▬▬▬▬▬ Related videos 👨‍🏫 ▬▬▬▬▬▬ 👉 [Playlist] Database Tutorials: https://www.youtube.com/playlist?list=PLiMWaCMwGJXnhmmh5pu9sdWekdRwAzV5f ▬▬▬▬▬▬▬ 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: https://github.com/antonputra/tutorials/tree/main/lessons/169 #sql #sqljoins #rdbms