Join Together Now: Write T-SQL Joins to query SQL Server
4.7 (91 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
646 students enrolled

Join Together Now: Write T-SQL Joins to query SQL Server

Learn to combine data from multiple tables using inner & outer sql joins. Master database joins, write awesome queries.
4.7 (91 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
646 students enrolled
Created by Kris Wenzel
Last updated 4/2020
English
English [Auto]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • 2 articles
  • 27 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Write queries to combine data from two or more database tables.
  • Understand the difference between an inner and outer join.
  • Have the confidence to use joins in t-sql queries.
  • Learn to simplify complex SQL statement with table aliases
  • Overcome one of the major stumbling blocks stopping you from mastering SQL.
Course content
Expand all 21 lectures 02:34:21
+ Introduction
3 lectures 20:12

The ultimate goal is to help you understand joins, so you can take your database skills to the next level!

Preview 02:03

Understand what a join it, why they are needed, and how they  work.  We'll go over an example, so by the end of this lesson, you'll be able to recognize one within a SQL statement!

Preview 05:30

After completing this lecture you'll know the three step I generally take when writing a join.  The steps are:

  1. Understand Your Database
  2. Formulate a Question
  3. Write a Query

We'll practice them as we write your first!


Writing your First Join
12:39
Introduction Quiz
3 questions
+ Setup Your Learning Lab (Optional)
5 lectures 17:50

Check out the download resource.

Note:  Install SQL Server 2019 if you're running Windows 109; otherwise, use the guide and for SQL Server 2017.

Download SQL Server
02:16

Install SQL Server on your computer.

Install SQL Server
04:31

Install SQL Server Management Studio so that you can connect to the database and run queries.

Download and Install SSMS
03:45

We'll get the Microsoft sample databases.  Many of our examples are based on these. Let's get them installed on your computer so that you can also run the queries and learn by example.

Download Sample Databases
04:25

The last step!  Once complete your learning lab is complete!

Restore Sample Databases
02:53
+ Inner Joins
3 lectures 21:37

An inner join matches two or more table’s columns.  A common pattern is to join two tables by their primary and foreign keys.  Rows from tables that fail to match aren’t included in the result.

Basics
09:45

After completing this lesson you'll know what a table alias is,  appreciate the need to use table aliases in your joins, and see that joining three tables isn't that much different than joining two.

Table Aliases and multi Table Joins
11:28
Do you have any questions?
00:24
Inner Join Quiz
5 questions
Use the AdventureWorks2016CTP3 database to solve these questions. There may be more than one answer. If you come up with a different answer than I have, you can always run both in SQL Server Management Studio to compare the results. I'd love to see how you write your queries!
Inner Join Assignment
1 question
+ Cross Joins
1 lecture 08:26

After completing this lecture you'll know the difference between a cross join and an inner join.

What is a Cross Join?
08:26
Cross Join Quiz
4 questions
Use the AdventureWorks2016CTP3 database to solve these questions. There may be more than one answer. If you come up with a different answer than I have, you can always run both in SQL Server Management Studio to compare the results. I'd love to see how you write your queries!
Cross Join Assignment
1 question
+ Join Conditions
2 lectures 27:48

Learn how to use Boolean operators to join one or more columns in a join condition.

Joining Two or More Columns
10:36

Learn to use joins whose join conditions use conditional operators other than equals.

Non-Equi Joins
17:12
+ Outer Joins
4 lectures 32:57

Learn about outer joins and how row are matched from one table to the next using the join condition.

Preview 04:02

Learn about the left and right table and the huge difference there is between a RIGHT versus as LEFT outer join!

Right versus Left Outer Joins
13:26

By the itme you've watched this lesson, you'll know that an outer join is a LEFT and RIGHT outer join in one.

Full Outer Joins
03:33

Though inner joins are used in 90% of all situations, there are those cases where they come in handy.  We'll go over a couple of those use cases in this lesson.

Uses for Outer Joins
11:56
Use the AdventureWorks2016CTP3 database to solve these questions. There may be more than one answer. If you come up with a different answer than I have, you can always run both in SQL Server Management Studio to compare the results. I'd love to see how you write your queries!
Outer Join Assignment
1 question
+ Self Joins
2 lectures 24:41

Learn about joining a table to itself and the situations where it makes sense to do this.

What is a Self Join?
09:32

We’ll join the tables together to get combination of orders, this will allow us to then summarize the orders.

Calculating a Running Total using Self Joins (Intermediate)
15:09
Self Join Quiz
4 questions
Use the AdventureWorks2016CTP3 database to solve these questions. There may be more than one answer. If you come up with a different answer than I have, you can always run both in SQL Server Management Studio to compare the results. I'd love to see how you write your queries!
Self Join Assignment
1 question
+ Wrap-up
1 lecture 00:49
Bonus Lecture: Additional Resources and Course Coupons
00:49
Requirements
  • You should already be familiar with SELECT, GROUP BY, and ORDER BY clauses
  • Access to a PC running Windows 7, 8, or 10
Description

In this Course you will Learn to:

  • Use different types of joins to solve real-world query problems.   

  • Understand the key differences between inner and outer joins.

  • Use non-equi joins to solve interesting problems such as calculating running totals. 

  • Combine columns from two or more tables into a single result.   

  • Know when to use an outer join.  

Nothing is worse than   

  • Being excited to learn something new but not knowing where to start.  

  • Wasting time learning the wrong features.  

  • Being overwhelmed with options and not know which to use.  

Imagine Having...   

  • Knowledge - Knowing how to quickly use joins to take your SQL to the next level.  

  • Confidence - Feeling good that you’re on the right track.  

  • Accomplishment - Having a sense of accomplishment that you've learned something most cannot.  

  • Fun - Having fun learning SQL inner and outer joins!  

By the time you’ve completed this course you’ll have an appreciation of joins, overcome your fear, and able to write queries combining data from multiple tables.   

Now that’s cool!

Who this course is for:
  • Beginner SQL query authors curious about combining data from multiple tables using SQL joins.
  • If you're struck writing joins or baffled by outer joins, then this course is for you!