From the course: SQL Essential Training

Joins explained

- You know, losing my mom back in 2011 was tough, but it got me very clear on how rewarding it is to live a life in line with your purpose and passion. I also became very clear on what my own passion is, and I love helping you learn and succeed at data analytics. That pep talk is needed for what we are about to get into next. So far, we've written a lot of queries and can do quite a bit with the SQL we've learned. But as we sharpen our skills, we've not yet tapped into maximizing the power of SQL. You see, we've only been getting data from one table at a time thus far. And in relational databases, data is stored across multiple tables. Each table contains some, but not all of the information about our fictional company WSDA Music. So, for instance, if the company's management wanted a list of the support reps or employees that were assigned to each customer, to answer this request, we need the data stored in both the customer and employee tables. This is a common scenario where knowing how to get data from multiple tables comes in handy. In this chapter, you'll become comfortable getting data from two or more tables with a single SQL query by using powerful tools called joins. A join is a command that connects the fields from two or more tables of a relational database. Let's take a look.

Contents