6 SQL Joins you MUST know! (Animated + Practice)
Вставка
- Опубліковано 6 чер 2024
- 🔴 - To support my channel, I’d like to offer Mentorship/On-the-Job Support/Consulting - 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: / anton-putra
► Twitter/X: / 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/tutoria...
#sql #sqljoins #rdbms - Наука та технологія
🔴 - To support my channel, I’d like to offer Mentorship/On-the-Job Support/Consulting - me@antonputra.com
The animation is a GAME CHANGER! im a visua learner so this is perfect ! thanks!
Thanks!!
I always had a bit of confusion about how joins worked and how the resulting rows were formed, but the animations make it very clear. Thanks Anton!
Thank you, Supershocky!
OMG, this videos is absolutely incredible. I've been working with SQL for years but now I really understand JOINs. Such a great didactic explanation. Thanks!!!!!!!!!!!!!!
Thank you so much! The dynamic visualization showing how data is pulled and related to the output helped a ton!
thanks!
Thank you for this!!! Your graphics helped so much.
thanks!
You just gained my fellowship.
You did a terrific explanation.
Especially that visual representation, Awesome!
thank you!!
Great explanation! Thank you so much.
Great explanation! Animation really made it more clear
Thank Dodo!
love this type of visual explanation, saved my time , thank you so much..
thanks!
ty so much!!! please make more like these!!
Will do!
great explanation thank you !
Well explained. Thank you!!🙏🏼
thanks!
Thank you so much Anton ❤
Any time!
Really well explained dude! Cheers
thanks!
This was great.
Very interesting video!! Thanks for the explanation
very amazing docker image, it helped me a lot. Thank you so much.
welcome!
Loved it ❤🎉
thanks!
Give this man an award!
❤
Great video Mr Putra!
Thanks!
Very nice explanation with examples, i had hard time remembering these commands
thanks!
Cleared all doubts
Thank you ❤
Thanks for visiting pabitra!
this video is more than amazing
it has a really good content and simplified
it is the perfect video for refreshement
thank you alot Sir !
thank you!
This was so helpful! Thank you.
thanks!
Awesome content bro❤
🤗
Thanks man... I always had problem understanding joins.. Thanks a lot. ❤
welcome!
Great explanation. Thank you
thanks!
Marvelous work!
thanks!
Wow explanations are so clear
Thanks :)
Congratulations to you Anton. This is a fantastic presentation. May I ask what software you used to make it? Thank you.
excellent explanation, thanks
thank you!
Thank you and God Bless!
❤️
Thank you for explain this
my pleasure!
thanks for this video
welcome
perfect explanations
thanks!
SOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO HELPFUL!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! THANKS A LOTTTTTTTTTTTTTT!!!!!!!!!!!!!!!!
Anton thank you, your video helped me a lot. You said that computer read and compare the fields in a different way, that is not visible for the user. Will be great if you make a video explain it or recommends some great book that teach it.
thanks Anton : )
my pleasure :)
hey anton thanks for the explanation, btw do your parent from Indonesia?
Great video. Can I asked what you used for the animations?
thanks, adobe suite
Спасибо 🙂
pojaluysta :)
Subscribed ! What do you use for such a great animation?
thanks! adobe
круто сделано, визуальная составляющая очень помогает в ваших видео
spasibo!
Hello Anton, what software you are using to make your animation ?
Thanks
Hi, Adobe suite
❤❤
❤
отлично
spasibo
are you related to indonesia by any chance ?
👏🏾👏🏾👏🏾👏🏾
🙏
This is really nice and clear video
where can we practice SQL ?
Thank you🙂
Just updated readme. I have build a custom docker image based on the Postgres that has all the data. Run the following commands to pull it
docker run --detach --name my-postgres --env POSTGRES_PASSWORD=devops123 aputra/postgres-169:15.3
docker exec -it my-postgres psql -U postgres
@@AntonPutra thank you
ништяк объяснил, надеюсь начнёшь на русском выпускать видосы.
spasibo, da sdelau kak nibud v budushem
the video was great but if you could just look away when teaching, kinda creeps me out
ok :)
Nice explanation, but don't use Venn diagrams to explain joins, please. It does not clarify the situation, but introduces another layer of confusion.
Noted
@@AntonPutra Funnily enough, the diagrams make a lot more sense after you understand joins. Not before. haha
@@AntonPutrathe problems with postgres database continers is that not all extensions are installable
Venn diagrams (in another video) were just what I needed to understand what was going on at the database level of the scheme. The venn showed one table having something in common with another.
@@AntonPutradon’t listen to him. It’s extremely common to use these vent diagrams with joins.
best explanation thank u
❤