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

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

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

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

4 dislikes? I think they are from Mercury

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

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

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

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 ;

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

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!

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

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

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

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

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

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.

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!

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.

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

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

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

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.

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

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 👏😀

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

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.

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

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

Thank you.. You are better than hollywood actor.. Kind of you.

the way she describes sql is soo satisfying

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

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!

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

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.

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!

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.

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

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

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

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

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

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!

This lady is the best!

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

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

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

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

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

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

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

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

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

this channels should be deserve millions of millions subscribe and views

YOU ARE A LIFE SAVIOR QUEEN!!!!!

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

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

It was incredible. Thanks Socratica.

You made it so easy mam, I request you to please make more videos like this, I will definitely contribute on patreon once I have a job.☺

Can you imagine if all education was themed like this? 😂😂. This is literally the most entertaining computer science video I've ever watched. "the reviews have been overwhelmingly online"😂😂😂😂

i like the teaching method of socratica . thank you

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

This is taught so well. Easier than a book

Outstanding way to teach a subject. I have never seen anything close to this. There are many good videos all around but the vídeos of this young lady are really from another world.

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

One of the best methods for teaching. Examples are easy to understand and interesting. Even a child will love and learn these clips. Please continue what you're doing. Thank you.

truly, a video of the year

Very good - reluctant to mention, that as an OOP programmer, using the words "base" and "super" for table names give me indigestion

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

You deserve more likes and viwes😍

0:08 punchline within 10 seconds? Bold move!

Honestly thought i'd get lost by the subquery bit but got an understanding of it when thinking about it.

I love the way you explain this!

Even knowledge can be entertained. Hence it proved.

the pop culture referance in these videos are good!

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

I recommend Socratica to my classmates! (:

I freaking love this channel. Thank you!

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

Your videos are hilarious. Glad to see Mark Watney returned to Mars after his mishap. Thank you!

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

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

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

I cant believe how informative and fun this is!!

This is the best video ever!I love all your videos ❤

This channel is awesome. I am liking SQL again.

I love your content!!!

Thank you so so much you helped me in my final exam.

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

Excellent explanation 🙏

these vids are so fun to watch!

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

OMGG, I'd pay for your production team ~~~~~~

Pretty easy to learn. Include this with your studies.

Thanks indeed the best video for explaining sql joins ever I can't believe it goes in details for all the concepts in less than a 12 minutes ❤️❤️😍

You worthy respect Thanks

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

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

Great Presentation thank you.

I wish you guys had uploaded these tables or the SQL codes to quickly create them. But overall, amazing tutorials!

"We are on Mars because there is a picture of mars on our screen" xD Lmao