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

Подписаться 47 тыс.

Просмотров 109 тыс.

50% 1

🔴 - 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

Наука

Опубликовано:

25 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 108

@AntonPutra 11 месяцев назад

🔴 - To support my channel, I’d like to offer Mentorship/On-the-Job Support/Consulting - me@antonputra.com

@2009nn 18 дней назад

@AntonPutra, what tool are you using to draw these awsome visualization that flow so beautifully. I'd really appreciate if you share the tool or the link where you can find this tool. Thanks in advance!

@AntonPutra 17 дней назад

@@2009nn sure, it's adobe suite

@OdalyMontoya 2 месяца назад

The animation is a GAME CHANGER! im a visua learner so this is perfect ! thanks!

@AntonPutra 2 месяца назад

Thanks!!

@EmpySoul 3 месяца назад

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!!!!!!!!!!!!!!

@Supershocky 9 месяцев назад

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!

@AntonPutra 9 месяцев назад

Thank you, Supershocky!

@HarshPatel-vy6lc 5 месяцев назад

Thank you so much! The dynamic visualization showing how data is pulled and related to the output helped a ton!

@AntonPutra 5 месяцев назад

thanks!

@Tinaisspooky 4 месяца назад

Thank you for this!!! Your graphics helped so much.

@AntonPutra 4 месяца назад

thanks!

@D_Ladybug 22 дня назад

You just gained my fellowship. You did a terrific explanation. Especially that visual representation, Awesome!

@AntonPutra 21 день назад

thank you!!

@malek0311 6 месяцев назад

Great explanation! Thank you so much.

@vishal_parajuli 18 дней назад

love this type of visual explanation, saved my time , thank you so much..

@AntonPutra 18 дней назад

thanks!

@embarrassed_dodo 7 месяцев назад

Great explanation! Animation really made it more clear

@AntonPutra 7 месяцев назад

Thank Dodo!

@ieatcrayons3322 7 месяцев назад

ty so much!!! please make more like these!!

@AntonPutra 7 месяцев назад

Will do!

@k.chriscaldwell4141 15 дней назад

Superb. Thank you.

@isme364 6 месяцев назад

great explanation thank you !

@alexsg7433 4 месяца назад

Well explained. Thank you!!🙏🏼

@AntonPutra 4 месяца назад

thanks!

@moody_moon_coder 8 месяцев назад

Great video Mr Putra!

@AntonPutra 8 месяцев назад

Thanks!

@pasinduvinsuka 6 месяцев назад

Thank you so much Anton ❤

@AntonPutra 6 месяцев назад

Any time!

@lucashoww 4 месяца назад

Really well explained dude! Cheers

@AntonPutra 4 месяца назад

thanks!

@a.v7998 3 месяца назад

Very interesting video!! Thanks for the explanation

@davdeveloper 3 месяца назад

This was great.

@whattheydoexactly7794 8 месяцев назад

very amazing docker image, it helped me a lot. Thank you so much.

@AntonPutra 8 месяцев назад

welcome!

@amuthansakthivel3648 Месяц назад

Give this man an award!

@AntonPutra Месяц назад

❤

@surajwaghmare4653 2 месяца назад

Loved it ❤🎉

@AntonPutra 2 месяца назад

thanks!

@pabitrakb5291 8 месяцев назад

Cleared all doubts Thank you ❤

@AntonPutra 8 месяцев назад

Thanks for visiting pabitra!

@drcharupandey 8 месяцев назад

Awesome content bro❤

@AntonPutra 8 месяцев назад

🤗

@mnasirkhanctl Месяц назад

Marvelous work!

@AntonPutra Месяц назад

thanks!

@sudip7949 2 месяца назад

Very nice explanation with examples, i had hard time remembering these commands

@AntonPutra 2 месяца назад

thanks!

@akshittyagi171 Месяц назад

Thanks man... I always had problem understanding joins.. Thanks a lot. ❤

@AntonPutra Месяц назад

welcome!

@Teezy-ny9im 2 месяца назад

This was so helpful! Thank you.

@AntonPutra 2 месяца назад

thanks!

@more-uv4nl 25 дней назад

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 !

@AntonPutra 25 дней назад

thank you!

@bossgd100 11 месяцев назад

Wow explanations are so clear

@AntonPutra 11 месяцев назад

Thanks :)

@maryodogwu4272 Месяц назад

Great explanation. Thank you

@AntonPutra Месяц назад

thanks!

@quest3604 3 месяца назад

excellent explanation, thanks

@AntonPutra 3 месяца назад

thank you!

@rafi_45 Месяц назад

Thank you for explain this

@AntonPutra Месяц назад

my pleasure!

@USA_to_Asia_in_2024 Месяц назад

Thank you and God Bless!

@AntonPutra Месяц назад

❤️

@mehmetoz886 5 месяцев назад

perfect explanations

@AntonPutra 5 месяцев назад

thanks!

@raiyan22 3 месяца назад

SOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO HELPFUL!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! THANKS A LOTTTTTTTTTTTTTT!!!!!!!!!!!!!!!!

@attiladren6990 4 месяца назад

Congratulations to you Anton. This is a fantastic presentation. May I ask what software you used to make it? Thank you.

@jimmyfavereau 7 месяцев назад

thanks Anton : )

@AntonPutra 7 месяцев назад

my pleasure :)

@elmirahadidian5051 2 месяца назад

thanks for this video

@AntonPutra 2 месяца назад

welcome

@Rockduds-ee2se 4 месяца назад

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.

@Kulec88 2 месяца назад

круто сделано, визуальная составляющая очень помогает в ваших видео

@AntonPutra 2 месяца назад

spasibo!

@ysgurjar 4 месяца назад

Subscribed ! What do you use for such a great animation?

@AntonPutra 4 месяца назад

thanks! adobe

@densstutorial9175 4 месяца назад

hey anton thanks for the explanation, btw do your parent from Indonesia?

@Alexpudow 5 месяцев назад

Спасибо 🙂

@AntonPutra 5 месяцев назад

pojaluysta :)

@mearnest91 5 месяцев назад

Great video. Can I asked what you used for the animations?

@AntonPutra 5 месяцев назад

thanks, adobe suite

@samuelpartouche5931 11 месяцев назад

Hello Anton, what software you are using to make your animation ? Thanks

@AntonPutra 11 месяцев назад

Hi, Adobe suite

@Aslamkaztro 24 дня назад

❤❤

@AntonPutra 24 дня назад

❤

@GabrielPozo 11 месяцев назад

👏🏾👏🏾👏🏾👏🏾

@AntonPutra 11 месяцев назад

🙏

@b.f.9484 5 месяцев назад

отлично

@AntonPutra 5 месяцев назад

spasibo

@padmavatitallapareddy8148 Месяц назад

This is really nice and clear video where can we practice SQL ? Thank you🙂

@AntonPutra Месяц назад

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

@padmavatitallapareddy8148 Месяц назад

@@AntonPutra thank you

@billionairepodcast 6 месяцев назад

are you related to indonesia by any chance ?

@jetowl57 2 месяца назад

ништяк объяснил, надеюсь начнёшь на русском выпускать видосы.

@AntonPutra 2 месяца назад

spasibo, da sdelau kak nibud v budushem

@burhanuddinasgarali7678 Месяц назад

the video was great but if you could just look away when teaching, kinda creeps me out

@AntonPutra Месяц назад

ok :)

@user-zw6vz4ec7n 11 месяцев назад

Nice explanation, but don't use Venn diagrams to explain joins, please. It does not clarify the situation, but introduces another layer of confusion.

@AntonPutra 11 месяцев назад

Noted

@jasonxb2998 11 месяцев назад

@@AntonPutra Funnily enough, the diagrams make a lot more sense after you understand joins. Not before. haha

@jirehla-ab1671 7 месяцев назад

@@AntonPutrathe problems with postgres database continers is that not all extensions are installable

@atlantic_love 6 месяцев назад

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.