From the course: Querying Microsoft SQL Server 2012
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Understanding JOINs - SQL Server Tutorial
From the course: Querying Microsoft SQL Server 2012
Understanding JOINs
Up until this point we've taken a look at splitting our tables out into multiple tables through the use of normalization in our database. Knowing that our tables contain related information there has to be a way for us to get that information back from these related tables into a single result set. We talked about the ability to use the primary keys and foreign keys to join those tables or to bring that data into the relationship. And we're going to take a look at the JOINS here and how we go through the process of joining our tables in our database. The JOINS are used to create that single result set of records from those multiple tables. And because most of you are relational database management systems use normalization and split that table into multiple tables. These JOINS will be required to get your queries to extract the appropriate data from the different tables in the database. So, when we look at the concept of a JOIN essentially it's the mechanism that tells SQL which…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.