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

Our SQL playlist starts here:

Be sure to SUBSCRIBE for more SQL!

You may also enjoy our Python playlist:

♦♦♦♦♦♦♦♦♦♦

Ways to support our channel:

►  We also accept Bitcoin @ 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9

Thank you!

♦♦♦♦♦♦♦♦♦♦

Connect with us!

♦♦♦♦♦♦♦♦♦♦

♦♦♦♦♦♦♦♦♦♦

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

[JoeWong]

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

[shoebsultan]

4 dislikes? I think they are from Mercury

[dhruvamalekar]

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

[Krm]

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

[terrancekayton]

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

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

[michaelvigato]

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

[fbuxtgx]

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!

[ALOKIKYADAV]

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

[TheSoulCrisis]

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

[yincheng]

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

[avi.chan]

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

[marinav.]

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!

[tinam]

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

[michaelcdarby]

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

[rocioarmstrong]

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

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

[marcwa]

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

[ThalassaMavri]

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