SQL JOIN explained (SQL tutorial for beginners in data science EP#4)

preview_player
Показать описание
Let’s learn how to use SQL JOIN to step up your analytics/data science projects! I'll show you the concept and the implementation of inner, full, left and right JOINs.

00:00 Intro
01:43 What is SQL JOIN?
03:34 Get some data!
09:15 The most basic JOIN type (INNER JOIN)
12:42 Same query, better syntax
14:58 FULL JOIN
16:28 LEFT JOIN AND RIGHT JOIN
20:13 Test yourself
00:00 Conclusion

PREVIOUS EPISODES:

LINKS MENTIONED IN THE EPISODE:

NEXT EPISODE:

--------------------------------------------------------

Рекомендации по теме
Комментарии
Автор

You havent mentioned nothing about PRIMARY And FOREIGN KEYS. I think it should be involved in this video ! :) Besides that its really clear and perfect reminder ! :)

maxaldo
welcome to shbcf.ru