Create an account to use AI

Create a free account to unlock all features:

Ask questions about videos with AI
Use smart search (AI)
Save your favorite videos
Bookmark your favorite categories
Organize your favorite subcategories
Access your personalized favorites page
Access your conversation history
Personalize your homepage with your favorites

Create an account

Already have an account? Log in

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

Anton Putra

UPDATED video - https://youtu.be/9prkapPewGs

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

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