SQL Joins Examples |¦| Joins in SQL |¦| SQL Tutorial

A SQL JOIN lets you retrieve data from 2 or more tables in your database. In this video we give examples of 4 kinds of joins: INNER Joins, LEFT Joins, RIGHT Joins, and FULL Joins (also known as FULL OUTER Joins).
If you are just learning about SQL Joins, we would recommend you watch our first video: “SQL Joins Explained.” • SQL Joins Explained |...
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)
♦♦♦♦♦♦♦♦♦♦

[@Socratica]

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

[@ianmubangizi6721]

still waiting...

[@juliechen6745]

あっくぇえええt387っq0っっっっくぁぱー⁰あpーああ⁰⁰あーーーあー1っq3q5い0

[@JoeWong81]

I love this woman's attitude and sense of humor and the content is also well taught... This channel definitely deserves more likes and subscribes

[@greendsnow]

She's an sql master.

[@shoebsultan5876]

4 dislikes? I think they are from Mercury

[@alexmungai7962]

16 at the moment, we got some extra-galactic activity from Andromeda

[@thomasedwardking7286]

🤣🤣

[@switkaren]

Surely, they have a right and liberty to dislike? As for me, I like!

[@kaptainkaboom]

Lol na they some dirty belters!! Mercurians are hot!! Leave them alone!! Lol. I watch too much tv. Lol

[@bareback_3000]

😭😭

[@dhruvamalekar8522]

Such innovative style of teaching....I was scared of SQL joins till date...then I found Socratica!!

[@wjrasmussen666]

I like her doing these videos.

[@RashadPrince]

Second that

[@Krm3458]

i love when someone teaches me like im the dumbest person on earth,like this :d

[@BrianEdwardAshmore]

You joke, but that's the best way to drive home the fundamentals - the most important part

[@MrLuxNsk]

On Mars.

[@sajidmanzar]

9:38 convert NULL quantity to ZERO. Here is the full code: SELECT s.supply_id, ISNULL(i.quantity,0) AS quantity, s.name, s.description FROM (SELECT * FROM inventory WHERE base_id = 1 ) AS i RIGHT JOIN supply AS s ON i.supply_id = s.supply_id ORDER BY s.supply_id ;

[@terrancekayton007]

YA'LL ARE KILLING ME WITH THE HUMOR, I am seriously 10 seconds in and cracking up looking forward to learning the way yall deliver this information. THANKS A BILLION

[@michaelvigato3228]

Christ, this is some of the best tutorials I've seen. Thank you for sharing, keep up with the excellent work!

[@user-fb7ux7tg7x]

Educational AND highly entertaining. Love her sense of humor and smile! Never have I clicked so fast for the next tutorial video. Great work Socratica and team! The supply descriptions are hilarious 😂 and the graphics & sound effects throughout the vid are superb!

[@ALOKIKYADAV31]

Hats off to your creative ways to teaching. keep moving forward >>>

[@yincheng7246]

the amount of effort and great sense of humor this lady has put in , so much appreciated.

[@avi.chan23]

Actually you're helping me getting prepared for my exam next week. Great clips with really good examples.

[@maybach7847]

Excellent and Ha ! Ha !

[@chrismalingshu]

Replace NULL with zero: SELECT ISNULL(myColumn, 0 ) FROM myTable

[@vishnumohank1299]

You really should have used IFNULL(i.quantity, 0) rather than the ISNULL.

[@adalovelac24]

SELECT COALESCE(myColumn , 0) FROM myTable;

[@TheSoulCrisis]

THANK YOU for this awesome video series on SQL and especially JOINS! I've never had so much fun watching..........any coding video and this is such a blast. You guys rock for this.

[@tinam269]

watching these to prepare for a job interview. The cuteness factor is really helping put me in the right mindset. I appreciate this so much!!

[@Socratica]

GOOD LUCK in your interview!! 💜🦉

[@michaelcdarby]

Idk what it is that makes these tutorials better than all the others. I think it’s her way of communication

[@rocioarmstrong2675]

You are my hero!!! Never change your instructions methods, please. People like myself need you.

[@tseegiitseku2932]

this channels should be deserve millions of millions subscribe and views

[@chase36chase]

i am a fan of this channel by now. this soundtrack, the william gibson -vibes, your acting! 10/10

[@ThalassaMavri]

Thank you for the videos! Hope you will keep publishing more videos on SQL.

[@timwilcox5183]

Easily the best video concerning SQL that I have watched. Not sure what else can be done any better.

[@marinav.7332]

Very insightful video I was searching for. For years I could not understand joins and related syntaxes but now finally I got it! Thank you a lot!

[@sajidmanzar]

I love the way they teach while having fun at the same time. In a short video, they explained all the three joins and sub-query, Alias as well. Thanks for this video.

[@sheilaquan9824]

SQL is very important... thank god u have got this tutoring recorded. The best way for me to learn to learn is to watch this first.

[@jimbo5437]

The way this was put together was perfect. I get so f-ing bored in class and have a hard time paying attention. THIS taught me more than in 1 hour of lecture. THANK YOU!

[@Vintagetube310]

Am I the only one in love with this cyborg? great videos. I just have to keep up a bit faster than usual. Which is a good and bad thing.

[@datapathit1]

Wow, I was lost in sql till I clicked on these videos. Superb job

[@melissajade7717]

I used to hate building databases.... Boring... Socratica makes it enjoyable! Thank you Socratica!

[@prashantchoudhary2456]

Wow. I never imagined joins were so entertaining... thanks a lot. Finally after 12 years of completing btech I now understand how joins work.

[@PrakharBhagwat]

One of the best learning video series for SQL! Kudos to your creativity and execution :)💕

[@danielquill]

Great video, and entertaining too - now I understand how to use the JOIN functions in SQL much better, thank you!

[@zm690]

I really enjoy this SQL series, very helpful. Thank you for making it so fun !

[@marcwa9124]

Wow! This Playlist is the best I've ever seen! Thanks so much! It's unbelievable how well this is done! Are you just geniuses or do you have a ridiculously high Budget? Amazing… really… absolutely amazing...

[@djmostephens]

The best SQL tutorials ever...damn! I love this and thanks a million

[@JasperZeroes]

This lady is interesting to watch. Sometimes I catch myself smiling in between and then the other voice in my head would say "Common, I thought you were studying? So why the smiles ?" Hahaha. Thank you, Socratica.

[@Jaxxy35]

You are just what I needed! I feel much more confident that I'll pass my test! Thank You! I love the nerd humor too!

[@nielltalwar1574]

education is supposed to be entertaining. Bang on Socratica !! learnt and laughed . cheers

[@nimshisheron9846]

Absolutely in love with the videos!! Thanks a lot!! Did not expect all the fun in these videos :')))

[@asal1001]

thank you thank you that'll you had an exam and was so worried about joins. your an amazing teacher!!!

[@tabaristake144]

Seriously stellar! Humor and information are 100% Thanks for this!

[@natnaelabay670]

this is one of the best tutorials i have ever seen......thank you

[@dorcasia109]

This video was posted in my SQL class and so far it has been the thing that helps most in my lab assignment. Thank you!

[@Socratica]

This is wonderful to hear - we're so glad you're watching! Please say thanks to your instructor for us!! It helps us so much to get the word out.💜🦉

[@navitaw8876]

Thank you for these videos, they are most helpful! Looking forward to more SQL videos! :)

[@MrWabouz]

Cool vid! Your work deserves to be more known

[@GreenSlugg]

This lady is the best!

[@ishanbhatt6067]

Heyy!! This was a really nice video! Great discovery for me. GOOD JOB!

[@joshuaeirman594]

Maybe I should comment more, this an incredible futuristic professionalism that is completely amazing. Beyond compare!

[@paulodepaula4957]

Amazing content, thank you so much for helping me understand the basics of SQL!!

[@alienpuppy]

I cant believe how informative and fun this is!!

[@vzntoup]

Perfect explanation and also enjoyable ! Keep it up!

[@pantsuslayer8631]

truly, a video of the year

[@aroncasiano1796]

this the first SQL video I have watched that is not boring. this video just motivates me!!!

[@paqueteaguilera6]

You saved me, my exam is in a few days and I didn´t undertand the subject until now. Thanks a lot!

[@girish_captures]

Hello Ms Socratica, I am not kidding.. Even though I'm proficient in all computer science-related concepts, I am always confused with SQL Joins. You have explained things with soo much ease, I literally fell in love with you and your approach. I'm more confident with joins now in just 11 mins. Thank you soo much.

[@alikakavand3165]

It was incredible. Thanks Socratica.

[@lokeshsivakumar3927]

She is a Fantastic teacher. Top work on the editing guys, I am a visual person and concepts are better understood visually. I would be glad if you guys can share the csv files for the martian course as well for us to practice.

[@cliffkatiecollins9975]

Socratica, you are one of the best humans this side of Mars.

[@aara144]

Appreciate the wonderful illustration.

[@gustavosantos106]

Awesome work. I wish I had found this channel before.

[@Juan-Hdez]

This is the absolute best video on SQL joins I have watched. Most charming girl!

[@toulasantha]

What I like about Socratica.... No beating around the bush Straight to the point Videos are not too long Clear explanations Hot lady of course 👏😀

[@vigneshhendrix4447]

You just Nailed it!🔥. I've joined socratica from today! Keep it up.

[@mehekpasricha2252]

YOU ARE A LIFE SAVIOR QUEEN!!!!!

[@manu52dain13]

I love the way you explain this!

[@nicolasjimenezq369]

Congratulations on your tutorials. Really helpful, on point, entertaining.

[@JairoMorales123]

She and/or the person that wrote the script has a great sense of humor

[@Cienega32]

What a goofy, loony chick. I love it! And funny too. Makes it such a relaxed learning environment. The voice... the hypnotic, expressive eyes... the ease with which I've learned things thru these videos. What a great presentation. What a great teacher! Instead of just poking my way thru a basic 'How To' type of book until my very simple SQL usage does what I hope it to do, I'm actually learning stuff on how to do things correctly & efficiently. You, madam, are brilliant in your technique!

[@cavedon.felipe]

Love how you explain!

[@chaytanya2293]

Haven't found any better video on SQL than this.

[@Jake_cub]

This helps so much. Joins were killing me this made it simple. love it thanks.

[@mohsink4u]

i havent see many of your videos yet, but i have already started loving them

[@Socratica]

We're so glad you've found us! Thanks for your nice comment!! 💜🦉

[@terrificsuper]

Unbelievable videos! Great format. Please make many more!

[@meechiesimms3827]

I love these videos so much! Thank you for making studying easier for me!

[@mastaan1646]

The quality of your content is elite. You guys are the best💗

[@laurenmiller8237]

I freaking love this channel. Thank you!

[@ethanbourne8324]

Need more of SQL content like these

[@MARIUTSKI13897]

Amazing! Just found your channel and it's amazing, thank you!

[@jesuscruz8008]

the way she describes sql is soo satisfying

[@ajayarumugam4742]

This was the best explanation, I have seen so far!

[@danschool7969]

Extremely well done. It is a little over the top but honestly you are explaining things none of the other vids have so far which were all the difference to me in understanding this concept. Thank you!!

[@ayang315]

This channel is awesome. I am liking SQL again.

[@aviiamo]

these vids are so fun to watch!

[@3mad0s]

Great video, learning SQL quick for an interview and this video (with the previous part) helped a lot in visualizing and understanding joins...thanks a lot!

[@shervinledu9440]

Thanks ! This is so well explained !

[@gravitycuda]

Waiting for Socratica's NoSql DB tutorial. I have subscribed, liked and commented and many will follow if you make a NoSQL DB tutorial.

[@ZahidHasan-cc8tf]

Yeah. I hope she fulfills our request for NOSQL tutorials.

[@ryanfelton2325]

0:16 seconds in and smashed like, love the star wars reference!

[@redicoyote]

Google should hire you to make videos for them, because this explains SQL better than their data analytics certification courses.

[@SantiagoRodriguez-en9hi]

Loving these, thanks a lot

[@rishisrivastava2354]

loved the way you have taught SQL. Really Really AMAZING. Fun learning

[@Zhu-lw4dn]

such a creative way to teach, great video!

[@abdosalamosman6480]

You worthy respect Thanks

[@sundararajanchakravarthy39]

Excellent explanation 🙏

[@ashujadhav5457]

i like the teaching method of socratica . thank you

[@stephontreadwell1664]

Wow! This is a great explanation and not boring lol. Thank you!

[@Socratica]

Do you love Socratica Programming videos? We have a Kickstarter to make 20 Advanced Python Lessons. Support what you love! bit.ly/PythonKickstarter

[@ciocolici6739]

amazing! thanks for the videos!

[@COOKINGBIRD]

Thank you for the SQL video! It was incredibly informative. 😊🙏🎥💻

[@niaei]

I wish I could Cite to a youtube links in scientific papers. You made my data analysis really fas... Thank you....

[@josegeorge7300]

Must say awesome job. God bless

[@nejihyuga3216]

freaking love this