SQL Joins: A Guide and Examples
📝 Get my free SQL Cheat Sheets: https://databasestar.mykajabi.com/lpk...
🎓 Learn and become confident with SQL joins: https://databasestar.mykajabi.com/joi...
SQL joins are a commonly used feature when writing queries. They let you combine two (or more) tables together in your SQL query and see a single set of results.
In this video, you'll learn a bit more about what SQL joins are, why they are needed, the different types of joins, and examples of each in a SELECT query.
I'll also share a few tips on working with joins and things to avoid.
Related videos:
How to Join 3 Tables: • SQL Join 3 Tables: How-To with Example
Self Joins: • Self Join in SQL
Timestamps:
00:00 Start
00:16 What is a join?
00:48 Sample tables
01:38 Start of query
01:58 Inner Join
04:49 Left Outer Join
06:10 Right Outer Join
07:10 Full Outer Join
07:38 Joins are not bad
08:16 Using keyword
08:46 Natural Join
09:17 Joins in a Where clause
On this page of the site you can watch the video online SQL Joins: A Guide and Examples with a duration of hours minute second in good quality, which was uploaded by the user Database Star 13 September 2021, share the link with friends and acquaintances, this video has already been watched 41,775 times on youtube and it was liked by 1 thousand viewers. Enjoy your viewing!
