SQL Joins Explained |¦| Joins in SQL |¦| SQL Tutorial

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

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

50% 1

SQL Joins let you fetch data from 2 or more tables in your database. We will cover the more common types of Joins: Inner Joins, Left Joins, Right Joins, and Full Joins (also called ‘Full Outer Joins’). We will introduce these 4 kinds of Joins and prepare you for our next video where we will cover many examples.
Our SQL playlist starts here:
↪bit.ly/Socratica_SQL
Be sure to SUBSCRIBE for more SQL!
↪ bit.ly/SocraticaSubscribe
You may also enjoy our Python playlist:
↪bit.ly/PythonSocratica
♦♦♦♦♦♦♦♦♦♦
Ways to support our channel:
► Join our Patreon : / socratica
► Make a one-time PayPal donation: www.paypal.me/socratica
► We also accept Bitcoin @ 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9
Thank you!
♦♦♦♦♦♦♦♦♦♦
Connect with us!
Facebook: / socraticastudios
Instagram: / socraticastudios
Twitter: / socratica
♦♦♦♦♦♦♦♦♦♦
SQL instructor: Ulka Simone Mohanty (@ulkam on Twitter)
Written & Produced by Kimberly Hatch Harrison (@khhsocratica) & Michael Harrison (@mlh496)
♦♦♦♦♦♦♦♦♦♦

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

24 мар 2019

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

Комментарии : 1,3 тыс.

@Socratica 4 года назад

It's official! The Socratica Python Kickstarter was a success! Thank you to all of our supporters. Because of you, many more Python videos coming soon!! 💜🦉

@njstudio2526 4 года назад

ok thankyou but i am new in this field how we get jobs in DBA

@njstudio2526 4 года назад

as DBA

@friendlychannel100 4 года назад

is it required to make (martian-table)base id a primary key and (base-table) a foreign key?

@InspiringThings101 3 года назад

Any way we can have access to the Martian data as an XLM file somewhere? Lol I would like to practice with it.

@QuizmasterLaw 3 года назад

This could be better if you included a link to what you think is the best online busybox/play tool to practice/learn sql in practice. I still think you're really a robot ^_^

@islamelgarhi1808 3 года назад

This is saving me from getting fired

@nanoshinnnnnnnnn9953 3 года назад

what 😂😂 hope your joking bro

@SanthoshFabre 3 года назад

Buhahaha

@Alex-pd5xc 3 года назад

haha!

@xarisadmiral3614 3 года назад

@roselpadilla 3 года назад

You still workin there?

@gamezine8374 3 года назад

I actually cried because this is too good to be free. Thank you.

@RSPodcast44 Год назад

Whoever wrote, hosted, edited, directed this masterpiece, deserves a Nobel Prize, well done ❤️

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

Yes!

@josephjames2767 3 года назад

Ok 2 minutes into this explanation I'm like "This how i want to learn everything else for the rest of my life"

@JannisAdmek 3 года назад

2:25 the sound of the tables joining is sooo satisfying!

@alimertc 3 года назад

lol i agree

@user-gw5lc2ks2v 3 года назад

lmao yes I thought I was the only one

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

Acting, jokes, delivery of information, everything here is magnificent

@dingus4138 3 года назад

This is the first time I've heard someone explain the LEFT vs RIGHT join in a way that makes sense. Thank you!

@dorcasia109 3 года назад

Me too! This video was shared in my sql class and they are the most helpful I have found.

@BigBoii1369 Год назад

SAME HERE!

@anthonyogundipe9248 Год назад

Me too, first time I see an excellent explanation after over a decade of programming.

@alexanderpalm6407 3 года назад

Let's not only acknowledge the great tutorial, but also the satisfying sound effects when the rows are joined together! 🥰

@Ahmad-ww4ue Год назад

Boom!!!

@toddhodder Год назад

Another Kindred Spirit exists.

@vishalsaini6538 Год назад

yeah! Just Like Tiles

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

I liked those too!

@szabozsombor3785 4 года назад

Your style is simply hilarious. This is what great education should look like!

@mahmoudalsafty5202 5 лет назад

I can't express how much i love this series

@gadgetboynaija 5 лет назад

Same!

@racheltindoy 4 года назад

LMAO it's like watching Netflix.

@TheIronmore 3 года назад

...and the presenter, so beatuful.

@tekapowai4734 3 года назад

I can't express the amount of inner join I got from this

@e.zarate 3 года назад

MORE LIKE INNER JOY RIGHT?

@CompSciCentral 2 года назад

This is one of the most creative tutorials I've ever seen. Absolutely brilliant. Thanks for making learning fun!

@dhoneybeekingdom7889 10 месяцев назад

Totally agree!

@wogawooga 3 года назад

never seen such a well-produced SQL video

@edammen 2 года назад

I really deeply appreciate that you explained this with a theme, because I know how much time and effort editing this kind of videos take. You could just simply explain joins in a whiteboard or a regular presentation but you went beyond that and that alone deserves recognition 👏👏👏

@palficsaba1710 Год назад

That's not Socratica way

@inbalelmalech3902 2 года назад

Watched an hour ago, still laughing. You managed to make SQL funny while explaining it better than anything else I've found so far, and that's gotta be a superpower of some kind.. You guys are awesome!

@bensmith6987 3 года назад

Your explanations are simply clear, straight to the point and easy to understand - better quality than majority of university professors or boot camp trainers. Thank you

@BigBoii1369 Год назад

After just coming from a pretty good Udemy boot camp trainer, I 100% agree!

@GhostedJackal 5 лет назад

In the future, everyone uses SQL still? Oh, god, this truly is the worst timeline.

@DrShpilev 4 года назад

Don't worry. The SQL will also be encapsulated by a layer or AI. I mean... sure... the AI will probably also plot to vacate all of Earths atmosphere or something, but at least you wouldn't actually have to write the SQL yourself anymore.

@gaberondon8757 4 года назад

Or job security haha

@mykhailomikhnovych8303 3 года назад

@@rafatashrafjoy2936 no worriers. It's impossible to work with large database using NoSql.

@hacerclic1020 3 года назад

And they will still be writing articles about how AI will soon make computer programmers unnecessary.

@codevev 3 года назад

It's the future. Everyone is using NoSQL now but SQL is still around :)

@thegamerator10 4 года назад

Gotta say, this is one of the most creative ways to teach SQL and databases I've ever seen.

@TheSoulCrisis 2 года назад

OMG........this lady is amazing! The production values, comedic values, learning values, and creativity of the video are just killer. I never had so much fun watching a SQL video before and that does put a smile on my face.........

@IslamAudioStation 3 года назад

This is probably the weirdest tutorial i have ever watched, but it is absoloutely amazing and well explained.Thanks!

@Jt-xe3xi Год назад

This is absolutely a masterpiece. I usually don't comment on videos but THIS VIDEO??? I cannot pass through without how amazing and well done this video was made. I was completely lost when I was reading about the Join process, and most videos usually don't help as much. This video was not only informational but also very fun to watch. It was kind of like watching a movie. Once again, thank you to everyone who contributed in this. Subscribed.

@globaltrident5341 5 лет назад

It should have been a Dear Join Letter.

@Socratica 4 года назад

Opportunity wasted.

@HS-hr5wp 4 года назад

Yes!!

@Jewelsonn 3 года назад

No No it should have been a Dear Join Later.

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

Take a bow, the creative team behind this tutorial. You people deserve an Oscar for the R. E. Joinder thingy!

@jasonwang-wg8wu 3 месяца назад

agreed, that was high-level comedy right thurr. I chuckled.

@Andy_a7 3 года назад

finally SQL tutorial that visually demonstrates and explains how rows from different tables are joined.

@filizcamuz8119 4 года назад

Amazing! You just saved me 2 hours of reading, thank you.

@sql_mike8268 4 года назад

A SQL query goes to a bar, walks up to two tables and says, "May I join you?" Great videos Socratica!

@RussellTeapot 4 года назад

_nice_

@Antnierv 4 года назад

wow....never thought I would find SQL remotely interesting.... Thank you for making this so much less painful!

@JoshuaWilsonNZ 3 года назад

By far you've explained joins as best I've seen on YT. Using inner join as the standard and left, right, and full as different tools it helps add context for why you would utilize the joins. So many times people try to explain this stuff completely theoretically, and does my head in. I enjoy the quirkiness too

@kevalmehta1058 4 года назад

I usually don't login to the youtube. But, after hearing that "join" joke I had to subscribe and give you a like.

@CyrixLord 5 лет назад

The Venn diagram example nailed it into my head wonderfully. Thank you. Now I cannot unsee the types of joins.

@maximinus1972 Год назад

Started weird (but in a good way) and ended up being maybe the best programming tutorial I've seen.

@bonganisingo1717 4 дня назад

This is one of the best explanations I've ever seen! Tears of join running down my face right now.

@adriancelis9691 5 лет назад

Dang so far the best video explaination for beginners ive seen on youtube. Thanks.

@imrana.8370 3 месяца назад

I didn't there was any way in the entire multiverse to make SQL entertaining but you did it! Now I'm starting to understand JOINs!

@internetdrew Год назад

Yo... just me or is this the most creative way to learn this stuff? They killed this!

@DARKCOP2011 5 лет назад

Ulka you are one of the greatest teachers i ever saw in my life! no joke

@vick7848 Год назад

7:53 love it 🤗 This was extremely clear. Much love to the editing too

@milesdavis8250 Год назад

FINALLY!!! Someone who has explained joined in a way I can understand. Thank you 👏🏾👏🏾

@StevenIvoire 28 дней назад

This is by far the BEST EXPLAINATION of Join in SQL. Thank you so much!

@83jdizzle83 4 года назад

You just saved my brain... Thank you for breaking this down the way you did. I could not figure out the Join was actually doing but your formatting and starting with the * for all columns then narrowing it down made it all click for me. Thank you so much!!

@emmanuelevuazeze4729 3 года назад

Those animations are just superb. I have been looking for something like this that will give a clear visual explanation of joins but they are very rare to find or not good enough. Thank you Socratica

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

My prof spent an hour, and he succeeded in confusing 80+ students in the lecture. You spent 10 min, and it makes so much sense!

@Ville_Jay 2 года назад

I just want to let you know that you've spoiled me. I'll never watch another unenthusiastic programming tutorial without wishing you were teaching it. Thank you for actually having fun while teaching!

@actrox1 Год назад

I can't tell how these animations took my concentration, everything went easier than I thought, Thank you Socratica for your clear explanations and time, I can't wait to be where others are🥰.

@Socratica Год назад

We're so inspired by you! Thank you for sharing your motivation and excitement about learning. 💜🦉

@hoapham7389 4 года назад

I'll be watching these more in detail at the next semester

@isaachamilton2418 Год назад

I have tried to get clear information on JOINS from a few certs, and this is 1000X more clear than any of them, and quicker. I am SO thankful for this

@369jwillow 2 месяца назад

By far the most clear and concise explanation of JOINS I have seen! Thanks so much!

@raminmdn 5 лет назад

Maybe your next series can be about teaching some "words" in English language, which can help us express how much we love this series !

@smoothbeak 3 года назад

This is a really great video (and I assume course though I've not seen the other videos yet). Super clear explanation, and I love that I can use my imagination to help to solidify the concepts better, great job!

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

THIS IS EXACTLY WHAT I WAS LOOKING FOR, the tables so nicely presented instead of starting at sql server no clue what to type omg

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

This is an ACTUAL LIFE SAVER. Thank you for making a fun, silly example, and ACTUALLY VISUALLY MOVING THE ROWS and COLUMNS physically in the space to join them. I NEEEEEDED to SEEEE this. Not to HEAR it explained in fancy tech terms. You are AMAZING.

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

This is great to hear, thanks for telling us. That's the thing we're aiming for in these videos-what can you do with a video that you can't do as well with just written tutorials.

@websterwing8225 5 лет назад

It's good to know that I live in a world where glados 2.0 will patiently explain sql to me.

@yawningpheonix 3 года назад

Writing this down in my notebook: Okay, yeah this makes perfect sense. Everything is logical and clear. Testing myself with creating a customized sandwich database: What is what again?

@user-gs2xw8gm9g 3 года назад

So true🤣

@lbb2rfarangkiinok 2 года назад

The background noise giving that outer-space vibe is such a nice touch. I thoroughly enjoyed this video.

@hellohell-eo7fe 2 года назад

extremely helpful, finished my assignment and didn't cry once because of this. 10/10 gives you maidens.

@SteinGauslaaStrindhaug 5 лет назад

Good to hear that the crazy NoSQL fad has ended and we're sensibly using SQL in the future. ;)

@lalligood 5 лет назад

It's worth noting that PostgreSQL also has a USING clause for joins, which can be used in place of the ON clause when--and only when--the column(s) being joined on in both tables have the same name. So using the example in the video, "ON b.base_id = m.base_id" could be replaced with "USING (base_id)". And yes, that syntax would work for all 4 types of joins.

@jvsnyc 4 года назад

Yup. Unfortunately, there are a lot of DBMS's that do not USE USING, so it wouldn't work in code trying to be portable across DBMS choices.

@blessanmathew7893 2 года назад

I haven't written an sql query in like 5 years so just wanted to refresh my knowledge. This is so good. I wish content like this existed when I was learning how to code.

@shanujwilson1204 3 года назад

And those light hearted wits are spot on. A tech savvy person like me is enjoying this thoroughly. I cracked at "maybe the other databases will..... JOIN us..".

@Hyp3rX360 4 года назад

Just found this channel, it's really good, although sometimes the face expressions are kind of creepy, maybe that's why I like it hehe

@ginflorita2148 3 года назад

I wanna go back to college again and make perfect my exams.

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

literally the most relateable video ive seen on joins. ive been doing databases for about 10 years never had to use joins until recently, i could just write code and extract with seperate queries. or use aliases and take values and insert a function. sometimes you need to extract one value from one sql without furthersteps. thank you so much im not even finished the video and feel like i can go back and conquer the world lol

@murmelbear8507 3 года назад

This style of teaching makes the pieces of information much less painful to learn. I love it! Thank you so much for this content!

@BritishMoralHQ 5 лет назад

im doing intention yoga so i can marry this woman this life or next or the one after...

@kellingc 5 лет назад

I think the writers were having too punny of a time with this script. However, she could read the dictionary and I'd still watch and learn. Join is one concept that is vital in a relational database, yet it is the weakest of my SQL skills. Thank you for producing this course.

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

I am 5 years deep into my career in computer science and I still come back for your fun yet very informative videos. Thank you for everything

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

This video has a 90s sci fi retro gaming vibe... I would spend 100s of hours watching lectures if they were delivered like this

@SomeGuyInSandy 5 лет назад

I bought a bunch of books and none of them use Venn diagrams like you did here. I could have saved a lot of scratch. : /

@kirbymarchbarcena 5 лет назад

I'm born in March, does that mean that I'm a martian?

@andibensisva2155 5 лет назад

Nah, you're a Mariachi. Yiiihaa..

@fin4314 Год назад

Thank you, I had questions about SQL during my engineering test and learning from your videos helped me pass it

@user-vv8bp7co1m Год назад

This is the best channel...ever...I love how she is like a character from a TV series...It helps people like me who has a short attention span focus

@abhishekshah11 5 лет назад

Lmao you sound totally different from python instructor.

@damarh 5 лет назад

because SQL is fun and python is hard, you need a serious face to learn python.

@wayneswildworld 2 года назад

Not gonna lie I had my doubts in the beginning, but the space-themed examples were great and this helped me understand joins better than any of the other videos that I watched thank you so much!

@sajidamoin771 2 года назад

This free superbly helpful video not only shows how bighearted you are but also how much you love what you’re doing.. Thanks a lot. God bless you.

@davidekechi4228 Год назад

I already understood this topic in the first few minutes but I couldn't stop myself from watching till the end. I never knew I could actually enjoy a tutorial. I'm checking out the rest of your videos

@kenovate81 10 дней назад

Wow, by far the best produced and most entertaining database and/or tech in general, tutorial I've seen in a long while!

@spradflex 2 года назад

Just the right amount of interesting, visual, and quirky/goofy. 12/10 would recommend.

@teriyakov Год назад

Been a dev since 2006 and this is THE best explanation/tutorial/video I've seen on the subject. Thank you!

@itsme-oc4vl Год назад

This might be the most creative and fast forward tutorial I've ever watched !!

@DeejayRobert 2 года назад

Never thought I'd be smiling through a programming tutorial... just brilliant stuff

@Coyote8080aru Год назад

This is by far the clearest explanation of joins that I have seen. Thank you and we'll done. It motivated me to *JOIN*

@o1techacademy Год назад

I didn't understand SQL join until I watched this video. Thank you so much. Amazing socratica

@corndoggydogdog 10 месяцев назад

This reminded me of old naff educational videos from primary school, except, it was BRILLIANT and hilarious and very educational. Excellent satire and very informative. Kudos to you at Socratica!

@kadiogluorkun 3 года назад

whaaaat! to be frankly honest... this is the clearest SQL-joins video I have ever seen. a job well done! and thanks a lot, obviously :)

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

Praise the sun!!! Im doing Google Cyber cert right now learning joins in SQL. The google instructer sounded lime she was from another planet. But this right here with the visual aides made it much easier to understand.

@mrqmaya 2 года назад

Finally someone could explain me how to use different JOINs!!! Oh THANK YOU for that!!!

@BadMouton 2 года назад

This is so wholesome, smiling and learning the whole time

@kalasnikov80 2 года назад

Just had 4 hours of class about joins, didn't understand a thing, this only 10 minutes and all the dots connected...Thank you!!!

@DrinkElectrolytes Год назад

I've been a data analyst for a whole year and was missing this basic visual explaination of how JOINs work. You helped me figure some duplication stuff out I was really struggling with. Thank you!!

@goprev9715 3 года назад

I don't have any other way to express this, so excuse my language in advance. Fucking thank you!!! Clear, humourous and concise explanation. Quite simply great.

@joaopaulorodrigues8920 2 года назад

Thanks God! Finally I understand JOINS! The best video that I ever seen!

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

I'm watching this video and boy am I so blessed. Thank you for spending the time to create this video. God bless you.

@arpitsaxena9249 2 года назад

Whimsy, quality content, brevity, this playlist is the complete package. Absolutely love the effort!

@pilotbroF22 3 года назад

this is singlehandedly preventing me from failing my masters program. thank you to the digital gods for this 0101010001101000011000010110111001101011001000000111010001101000011001010010000001100111011011110110010001110011