MP3JOSS

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

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

Choose Download Format

Download MP3 Download MP4

Details

Title6 SQL Joins you MUST know! (Animated + Practice)
AuthorAnton Putra
Duration9:47
File FormatMP3 / MP4
Original URL https://youtube.com/watch?v=Yh4CrPHVBdE
🎵 Support the artists — buy the original for the best audio quality! 🎵

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

🎧 Just For You

🎵 Apt. - Ros & Bruno Mars 🎵 Uptown Funk - Mark Ronson Feat. Bruno Mars 🎵 - Emin & Jony 🎵 Anxiety - Doechii 🎵 Dont Stop Believin - Journey 🎵 Not Like Us - Kendrick Lamar 🎵 Party Rock Anthem - Lmfao Feat. Lauren… 🎵 Sex On Fire - Kings Of Leon 🎵 Mystical Magical - Benson Boone 🎵 Happy - Pharrell Williams 🎵 Luther - Kendrick Lamar & Sza 🎵 What I Want - Morgan Wallen Feat. Tate…