SQL Join Fundamentals

These are the "fundamentals" since almost all SQL databases implement these features, so a good grasp of each of these will put you in a good place to work with most SQL database joins. The following videos will introduce new join types and get "under the hood" of the joins to understand exactly what the database is doing! --------------------------------------------------- This is part of the Everything About Joins playlist, available at: - https://www.youtube.com/playlist?list=PLEiRgvTilK5rJilO6gc809Eg2Qajgeh02 The written version of this content is also available at: - https://billwallis.github.io/sql-learning-materials/everything-about-joins/syntax/join-fundamentals/ - https://billwallis.github.io/sql-learning-materials/everything-about-joins/syntax/more-fundamentals/ --------------------------------------------------- CHAPTERS 00:00 Intro 00:46 Sample data 01:46 LEFT JOIN 03:38 RIGHT JOIN 04:51 INNER JOIN 06:54 CROSS JOIN 10:00 FULL JOIN 13:57 The OUTER keyword 15:38 Multiple joins 16:24 Self joins 17:25 Joins with subqueries 19:58 Multiple join conditions 22:34 Warning: joins vs where 25:27 USING 28:54 USING will automatically COALESCE 31:35 NATURAL 37:24 Wrap up