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

[@AntonPutra]

🔴 - To support my channel, I’d like to offer Mentorship/On-the-Job Support/Consulting - [e-mail]

[@AntonPutra]

@@nnmm0001 sure, it's adobe suite

[@OdalyMontoya]

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

[@AntonPutra]

Thanks!!

[@EmpySoul]

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]

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]

Thank you, Supershocky!

[@HarshPatel-vy6lc]

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

[@AntonPutra]

thanks!

[@alexsverenyak9150]

I don't leave comments often, but this is an amazing explanation! Thank you!

[@AntonPutra]

thank you!!

[@embarrassed_dodo]

Great explanation! Animation really made it more clear

[@AntonPutra]

Thank Dodo!

[@devanarayanababu1996]

tbh i just saw the picture and remembered what they were, came here for a refresher.
thanks, gold

[@AntonPutra]

thank you!

[@Tinaisspooky]

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

[@AntonPutra]

thanks!

[@Tubeytime]

THANK YOU for including animations while you explain, this is exactly what I was looking for!

[@D_Ladybug]

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

[@AntonPutra]

thank you!!

[@szymonjakubowski3574]

Bro. What an awesome resource! I couldn't quite grasp it but you cleared it for me. Cheers! Great stuff

[@OZTutoh]

So very helpful! Can't wait to test this out on my project server. Thank you!

[@AntonPutra]

thank you!

[@abhask01]

You deserve way more subscribers my guy. Keep up these videos :)

[@AntonPutra]

thank you! :)

[@laurenceuwimana4521]

From your amazing video which is animated well, i can even explain those types to someone else! thank you so much for this video

[@vishal_parajuli]

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

[@AntonPutra]

thanks!

[@samtadros8454]

Thanks a lot Anton, it's amazing.. crystal clear now 👍🙏

[@AntonPutra]

Thank you!!

[@blibohafix9898]

You’re called to teach bro. Keep it up👍🏽

[@AntonPutra]

thank you! :)

[@victoryu1066]

Cool! Thank you. The animation is amazing! From Philippines

[@AntonPutra]

thank you!

[@malek0311]

Great explanation! Thank you so much.

[@ieatcrayons3322]

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

[@AntonPutra]

Will do!

[@amuthansakthivel3648]

Give this man an award!

[@AntonPutra]

❤

[@sudip7949]

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

[@AntonPutra]

thanks!

[@more-uv4nl]

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]

thank you!

[@lucashoww]

Really well explained dude! Cheers

[@AntonPutra]

thanks!

[@moody_moony123]

Great video Mr Putra!

[@AntonPutra]

Thanks!

[@k.chriscaldwell4141]

Superb. Thank you.

[@akshittyagi171]

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

[@AntonPutra]

welcome!

[@freakmascot891]

Good job Anton it is so helpful

[@AntonPutra]

thank you!!

[@surajwaghmare4653]

Loved it ❤🎉

[@AntonPutra]

thanks!

[@VSN-yz7zx]

So full outer join which is union basically performs both left join + right join without duplicates and union all removes duplicates as well. ALso Unions essential function is to join multiple ROWS based on condition, Full outer join purpose is to join TABLES

[@allhailalona]

Excellent, thank you very much!

[@AntonPutra]

my pleasure!

[@amrut13]

Nicely articulated - thank you very much from Bharat

[@AntonPutra]

thank you!

[@pasinduvinsuka]

Thank you so much Anton ❤

[@AntonPutra]

Any time!

[@Nachiket_upadhye_23]

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

[@AntonPutra]

welcome!

[@EdchelStephenNini]

Wonderful! Thank you sir! :)

[@pabitrakb5291]

Cleared all doubts
Thank you ❤

[@AntonPutra]

Thanks for visiting pabitra!

[@mnasirkhanctl]

Marvelous work!

[@AntonPutra]

thanks!

[@Teezy-ny9im]

This was so helpful! Thank you.

[@AntonPutra]

thanks!

[@isme364]

great explanation thank you !

[@chaaruupandey]

Awesome content bro❤

[@AntonPutra]

🤗

[@mcmasters3000]

Bravo!

[@AntonPutra]

thank you!

[@enrique27yt]

Muchas gracias los ejemplos visuales me fueron de mucha ayuda, excelente video !

[@AntonPutra]

thank you!!

[@davdeveloper]

This was great.

[@SHIVAGARCÍACHUMKHWAN]

Explendid work👏

[@EternalWind22]

thank you for this!

[@AntonPutra]

my pleasure

[@aburaihan-py4vi]

Excellent!!!!

[@a.v7998]

Very interesting video!! Thanks for the explanation

[@Chinmayimanvi]

Amazing presentation and explanation using perfect animations!
Really helpful for visual learners.
Thank you.
Btw, which software is that?

[@AntonPutra]

thank you!! adobe suite

[@bossgd100]

Wow explanations are so clear

[@AntonPutra]

Thanks :)

[@maryodogwu4272]

Great explanation. Thank you

[@AntonPutra]

thanks!

[@Aziz-kw6ct]

You're the best

[@Rockduds-ee2se]

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]

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

[@AntonPutra]

spasibo!

[@samuelpartouche5931]

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

[@AntonPutra]

Hi, Adobe suite

[@camilarueda1919]

Hi Anton! This is great🙌 thank you so much for your dedication and for sharing your work with us. I was wondering if on minute 4:04 you meant to select 1 instead of 3 since you mentioned "SQL then starts with the first value of the specified column in the first table (customer.customer_id). Thank you in advance 🙏

[@AntonPutra]

Thank you! I may have misspoken

[@mehmetoz886]

perfect explanations

[@AntonPutra]

thanks!

[@quest3604]

excellent explanation, thanks

[@AntonPutra]

thank you!

[@rryann088]

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

[@kasir-barati]

Thanks for the video

[@EarthDarkSide]

Thanks man

[@karanshende3910]

Thank you so much 😊

[@USA_to_Asia_in_2024]

Thank you and God Bless!

[@AntonPutra]

❤️

[@talhasial5502]

Great video but try adding a pause of half a second after every second so it doesn't seem like the video is getting rushed. Since you are also explaining the concepts behind joins the audience needs to fully grasp what you are saying as well as seeing it on the screen.

[@AntonPutra]

thanks for the feedback

[@attiladren6990]

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

[@rafi_45]

Thank you for explain this

[@AntonPutra]

my pleasure!

[@juancarlossalgado4334]

Thanks 😊

[@AntonPutra]

always!

[@Francisco-j1e]

I feel dumb but this is basics for people in IT!!!

[@ysgurjar]

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

[@AntonPutra]

thanks! adobe

[@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

[@atomicboy8067]

thank you

[@AntonPutra]

my pleasure!

[@santhoshss23]

I have doubt in right join. in video at 6.18mins u have mentioned as customer, action as primary key(visual written) . But while you explaining u mentioned as foreign key here i got confused
I hope you will read this message and reply back or anyone plz share your thoughts i will get clarity on this
overall video is very good. thank you for providing this valuable lessons for the analytics community

[@AntonPutra]

thanks, I may have misspoken

[@carlosaugustorj]

thanks !!! is there a diff on cost from left and right joins ?

[@AntonPutra]

i don't think so

[@mearnest91]

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

[@AntonPutra]

thanks, adobe suite

[@SHAKTIPRIYA-h7s]

referenced table is the one that holds the primary key

[@AntonPutra]

Did I make a mistake somewhere or misspeak?

[@jimmyfavereau]

thanks Anton : )

[@AntonPutra]

my pleasure :)

[@elmirahadidian5051]

thanks for this video

[@AntonPutra]

welcome

[@RyanAnimations-uo8jt]

wow great animations, i wonder what software he uses

[@AntonPutra]

thanks, adobe suite

[@ayushmathur5984]

Let's say for inner join will it performs on condition then it will do inner join or vice Versa

[@densstutorial9175]

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

[@Alexpudow]

Спасибо 🙂

[@AntonPutra]

pojaluysta :)

[@AjayYadav-ev2ej]

Nice one

[@AntonPutra]

thanks!

[@harshitgoswami2423]

thanks

[@AntonPutra]

welcome!

[@laurenceuwimana4521]

and i was expecting self join! can anyone help me about it?

[@billionairepodcast]

are you related to indonesia by any chance ?

[@Starmanfansunofficial]

❤❤

[@AntonPutra]

❤

[@amirmehdihosseini]

❤

[@GabrielPozo]

👏🏾👏🏾👏🏾👏🏾

[@AntonPutra]

🙏

[@dinamid92]

отлично

[@AntonPutra]

spasibo

[@alanoperate6982]

Здорово

[@AntonPutra]

thanks! :)

[@ebtihajabdullah800]

Content one side, why tf are there so many frickin ads

[@AntonPutra]

🤷‍♂

[@KinderGuardian]

Возвращайся на родину. Всё видео ждал что вот вот скажет что то на родном.

[@AntonPutra]

❤️

[@shayorshayorshayor]

No idea the dude was Ai

[@AntonPutra]

?

[@jetowl57]

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

[@AntonPutra]

spasibo, da sdelau kak nibud v budushem

[@ИванАхременко]

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]

Noted

[@jasonxb2998]

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

[@jirehla-ab1671]

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

[@atlantic_love]

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.

[@AntonPutra]

@opprogram8620 i know :)

[@Animix4uu]

Why do you speak like an AI bot?

[@AntonPutra]

need more practise

[@Animix4uu]

@@AntonPutraplease practice because your content is really good

[@burhanuddinasgarali7678]

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

[@AntonPutra]

ok :)

[@nu7bla]

best explanation thank u

[@AntonPutra]

❤

[@alexsg7433]

Well explained. Thank you!!🙏🏼

[@AntonPutra]

thanks!

[@mrsdhuha]

Many thanks for this video!