From the course: SQL Tips and Tricks for Data Science

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

Join tables

Join tables - SQL Tutorial

From the course: SQL Tips and Tricks for Data Science

Start my 1-month free trial Buy for my team

Join tables

“

- [Instructor] So let's talk about joining tables together. Tables are isolated containers of data in a database. Joining them together allows you to combine multiple data sets for more comprehensive results and analysis. Now a database design, also known as data modeling, there are specific guidelines or rules when to separate data into their own tables. At the most basic level, you can think of a table like a sheet in Excel. Each tab or sheet would be a separate table containing separate, but related, e.g. relational data. By joining these tables using SQL, we can create more complete results sets as well as perform look-ups and comparisons. Joining tables is a fundamental concept in SQL. Let's take a look deeper as to why we should do this. The three basic use cases for why we would join tables is starting with the idea of combining related datasets. In databases, relational or dimensional, often data elements are…

Contents