Ryan McBeth
@RyanMcBethProgramming·1.1M subscribers·2K videos
SQL Joins Explained For Job Interviews
Posted
December 23, 2021
Views
890
Likes
49
Comments
5
Engagement
6.07%
December 23, 2021
890
49
5
6.07%
Every word spoken in this episode is indexed. Type any phrase to jump straight to the moment it was said.
Type any word or phrase that may have been spoken. Click a result to seek the player to that exact moment.
Try a name, a topic, or a quoted line
5:12Now PlayingThe SQL code to generate this database is available here:
ryanmcbeth.com
Part 1 of Basic SQL Questions for C# developers is available here:
When it comes to SQL Joins:
AN INNER JOIN lists all FRATBOYS and their BEER.
A LEFT OUTER JOIN lists all FRATBOYS and their BEER whether or not they have one.
A LEFT OUTER JOIN WITH WHERE CLAUSE lists all FRATBOYS with no BEER.
A RIGHT OUTER JOIN Lists all BEERS unclaimed by FRATBOYS.
And a FULL JOIN lists FRATBOYS and all BEERS.
Sentinel Indexing in Progress
Metadata and chapters are available. Claim extraction for this episode is pending.
All video content is delivered via YouTube embedded players in accordance with the YouTube Terms of Service. Sentinel provides research tools that promote discovery and accountability across political media.
