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
Nesta página do site você pode assistir ao vídeo on-line SQL Joins: A Guide and Examples duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Database Star 13 Setembro 2021, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 41,775 vezes e gostou 1 mil espectadores. Boa visualização!
