How To Join Tables With SQL
Channel: Data Analytics Ireland
Date: 2021-03-27

When working with databases a common question is how can I join two database tables? In this video on how to join tables with SQL, we work through four examples and explain left join, right join, inner join and full joins. When you want to learn how to join tables in SQL using the primary key you can join tables and also it is a good design to not have duplicated data across the tables, this is discussed as well. This SQL tutorial is part of a series of SQL tips and tricks which can be found here:

Blog post with code: https://dataanalyticsireland.ie/2021/02/20/how-to-join-tables-in-sql/

⏲⏲⏲TIMESTAMPS⏲⏲⏲
00:00 Beginning 
00:14 Inner join 
04:36 Left join 
07:09 Right join 
08:26 Full join 
10:34 Subscribe 

The blog post with the link to the code for this can be found here:
https://dataanalyticsireland.ie/2021/02/20/how-to-join-tables-in-sql/

Want to learn more SQL: https://dataanalyticsireland.ie/tag/sql/

################     Let's be Social!    ##################

 Website - https://dataanalyticsireland.ie/
 Twitter - https://twitter.com/dataanalyticsi1
 Facebook - https://www.facebook.com/dataanalyticsirl
 Linkedin - https://www.linkedin.com/company/data-analytics-ireland
 Pinterest - https://www.pinterest.ie/dataanalyticsireland/

#sql #dataanalytics #dataanalyticsireland #jointables #sqljoin #innerjoin #leftjoin #rightjoin #fullouterjoin