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

Details
Title | 6 SQL Joins you MUST know! (Animated + Practice) |
Author | Anton Putra |
Duration | 9:47 |
File Format | MP3 / MP4 |
Original URL | https://youtube.com/watch?v=Yh4CrPHVBdE |
Description
👨💼📈 Mentorship/On-the-Job Support/Consulting - https://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: https://www.linkedin.com/in/anton-putra
► Twitter/X: https://twitter.com/antonvputra
► GitHub: https://github.com/antonputra
► Email: me@antonputra.com
▬▬▬▬▬▬ 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