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

Share this & earn $10
Socratica
Published at : 11 Nov 2021
407461 views
15325
249

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:
http://bit.ly/Socratica_SQL

Be sure to SUBSCRIBE for more SQL!
http://bit.ly/SocraticaSubscribe

You may also enjoy our Python playlist:
http://bit.ly/PythonSocratica

♦♦♦♦♦♦♦♦♦♦

Ways to support our channel:

►  Join our Patreon : https://www.patreon.com/socratica
►  Make a one-time PayPal donation: https://www.paypal.me/socratica
►  We also accept Bitcoin @ 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9

Thank you!

♦♦♦♦♦♦♦♦♦♦

Connect with us!

Facebook: https://www.facebook.com/SocraticaStudios/
Instagram: https://www.instagram.com/SocraticaStudios/
Twitter: https://twitter.com/Socratica

♦♦♦♦♦♦♦♦♦♦

SQL instructor: Ulka Simone Mohanty (@ulkam on Twitter)
Written & Produced by Kimberly Hatch Harrison (@khhsocratica) & Michael Harrison (@mlh496)

♦♦♦♦♦♦♦♦♦♦

SocraticaSocraticaCSSQL

entree NET   The Salesperson Experience

entree NET The Salesperson Experience

Friendly Conservative Convo BLOWS UP Into HEATED 1v3 CNN Debate

Friendly Conservative Convo BLOWS UP Into HEATED 1v3 CNN Debate

Apart From

Apart From

Mr. No Problem by The d.e.p

Mr. No Problem by The d.e.p

Europe - The Final Countdown (Official Video)

Europe - The Final Countdown (Official Video)

देखिये Factory में सिगरेट कैसे बनाया जाता है | Cigarette manufacturing |Cigarette Making in factory

देखिये Factory में सिगरेट कैसे बनाया जाता है | Cigarette manufacturing |Cigarette Making in factory

Nastya finds out how smart and creative she is. Story for kids

Nastya finds out how smart and creative she is. Story for kids

How Effective is Sinovac? | And which Covid Vaccines are Best?

How Effective is Sinovac? | And which Covid Vaccines are Best?

The Ancient in HD by Yes

The Ancient in HD by Yes

Dido - Thank you (Slowed + Reverb)

Dido - Thank you (Slowed + Reverb)

🔵 Prevalent - Prevalent Meaning - Prevalent Examples - Formal English

🔵 Prevalent - Prevalent Meaning - Prevalent Examples - Formal English

Thorchain Returns!! RUNE Price Potential!? ⚒

Thorchain Returns!! RUNE Price Potential!? ⚒

cute songs to help you cope with depression

cute songs to help you cope with depression

Pegasus: the spyware technology that threatens democracy

Pegasus: the spyware technology that threatens democracy

The Four Personality Types and How to Deal with Them

The Four Personality Types and How to Deal with Them

DEAD END! Meghan BANNED Using Title In Both UK&US As Utilizing For Self-Interest INFLAMING RAGE

DEAD END! Meghan BANNED Using Title In Both UK&US As Utilizing For Self-Interest INFLAMING RAGE

Queen - Under Pressure (Official Video)

Queen - Under Pressure (Official Video)

Pre-intermediate English - No article - inglés pre intermedio

Pre-intermediate English - No article - inglés pre intermedio

Regard, Troye Sivan, Tate McRae - You (Live Performance)

Regard, Troye Sivan, Tate McRae - You (Live Performance)

What are dentists generally known as in America?

What are dentists generally known as in America?

Turned To Reacting To Negative Comment instead of Things to Consider in marrying a Nigerian Man

Turned To Reacting To Negative Comment instead of Things to Consider in marrying a Nigerian Man

Stereophonics - Handbags And Gladrags

Stereophonics - Handbags And Gladrags

Solander - Book Of Advice

Solander - Book Of Advice

Enio - On a Regular Basis (Official Music Video)

Enio - On a Regular Basis (Official Music Video)

How to Write a Research Methodology in 4 Steps | Scribbr 🎓

How to Write a Research Methodology in 4 Steps | Scribbr 🎓

Top 10+ Best Upcoming Mobile Phone Launches ⚡ October 2021

Top 10+ Best Upcoming Mobile Phone Launches ⚡ October 2021

Burglary Theft Act 1968 UK law

Burglary Theft Act 1968 UK law

"Overpassed The Test" | CS:GO Funny Moments

"Overpassed The Test" | CS:GO Funny Moments

Phước Lành Giả Tạo | Oneway Radio - Tĩnh Nguyện Hằng Ngày 20/11/2021

Phước Lành Giả Tạo | Oneway Radio - Tĩnh Nguyện Hằng Ngày 20/11/2021

Doctor Who Specials Disc 2 - 12 The Master Suite

Doctor Who Specials Disc 2 - 12 The Master Suite

APC - Scoren van consulten - Consult 2

APC - Scoren van consulten - Consult 2

Casting Crowns - Nobody (Official Music Video) ft. Matthew West

Casting Crowns - Nobody (Official Music Video) ft. Matthew West

For This Purpose - by Graham Kendrick

For This Purpose - by Graham Kendrick

CNCO - Pretend (Letra)

CNCO - Pretend (Letra)

MIMS - This Is Why I'm Hot (Official Music Video)

MIMS - This Is Why I'm Hot (Official Music Video)

Gentle Bones - Sixty Five

Gentle Bones - Sixty Five

Kendrick Lamar - ELEMENT.

Kendrick Lamar - ELEMENT.

THE HOUSE’S BUDGET RECONCILIATION PACKAGE WOULD PROVIDE PATH TO CITIZENSHIP FOR MANY IMMIGRANTS

THE HOUSE’S BUDGET RECONCILIATION PACKAGE WOULD PROVIDE PATH TO CITIZENSHIP FOR MANY IMMIGRANTS

DEAD BY DAYLIGHT | Tấu hài đêm khuya =))  (27/10/2021)

DEAD BY DAYLIGHT | Tấu hài đêm khuya =)) (27/10/2021)

Dark Souls: Ceaseless Discharge Boss Fight (4K 60fps)

Dark Souls: Ceaseless Discharge Boss Fight (4K 60fps)

THAT'S MY MOM?!?! (Among the Sleep)

THAT'S MY MOM?!?! (Among the Sleep)

Grace VanderWaal - Clearly (Lyrics)

Grace VanderWaal - Clearly (Lyrics)

AWW New Funny Videos 2021 ● People doing funny and stupid things Part 44

AWW New Funny Videos 2021 ● People doing funny and stupid things Part 44

2nu - This Is Ponderous

2nu - This Is Ponderous

Company: Tiny Desk (Home) Concert

Company: Tiny Desk (Home) Concert

What is a Treatment Plan & how do we make one?

What is a Treatment Plan & how do we make one?

6. Implementation

6. Implementation

The Fundamentals

The Fundamentals

Anfa Rose - Nicely (VISUALISER)

Anfa Rose - Nicely (VISUALISER)