TSQL SQL Server Join Types

In this course you will first gain an understanding of the differences between each of these types of joins and when they should be used. Then we’ll explore some common uses for joins, such as replacing a not in clause with join to get the same results with better performance. You will take home the right foundations to get at the data that you want.

Learn more and enroll today!

Improve your SQL query skills by learning how to connect tables with different JOIN types.

Intended for database programmers and new administrators who are familiar with TRANSACT SQL, may know simple joins, who would like to know more about OUTER JOINS, LEFT JOINS, RIGHT JOINS, CROSS JOINS, and SELF JOINS.

Course Will Cover:

Basic select, inner join, left outer join, right outer join, semi join, anti semi join, left outer join w/ exclusion, right outer join with exclusion, full outer join, cross join, cross apply, outer apply, equi vs non equi join, two inner joins, full outer join w/ exclusion, inner and outer join, except, intersect and union.