Microsoft TSQL
JOIN Types Course
Welcome to a comprehensive exploration of JOIN types in Microsoft TSQL, brought to you by Steve Stedman of Stedman Solutions, LLC. This course is designed to impart a deep understanding of JOIN types in TSQL, their differences, and optimal use cases.
What is Covered
The course kickstarts with a basic understanding of the SELECT statement, serving as a cornerstone for the learning journey.
You will be introduced to various JOIN types, including but not limited to INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, and FULL OUTER JOIN. Delve into more complex JOIN types such as SEMI JOIN, ANTI SEMI JOIN, CROSS JOIN, CROSS APPLY, and OUTER APPLY, and familiarize yourself with the contexts and scenarios where these may come in handy.
In this course, you'll also learn how to enhance your query performance by replacing the NOT IN clause with a JOIN. Get comfortable with exclusions in LEFT OUTER JOIN, RIGHT OUTER JOIN, and FULL OUTER JOIN and understand the unique usage of EQUi versus NON-EQUI JOIN.
To round up your knowledge, you'll discover the use of multiple INNER JOINS in a single query and the combination of INNER and OUTER JOINS. We will also be looking at the SET operations EXCEPT, INTERSECT, and UNION to give you a 360-degree view of TSQL JOIN operations.
Your Instructor, Steve Stedman
With over 34 years of SQL Server experience, Steve has done his share of performance tuning.
This course is taught by Steve Stedman with some help from other team members. A majority of the lessons are taught by Steve.
If you are having trouble grasping a concept, you can reach out to Steve through his mentoring program for help or more details.
Curriculum
(Click down arrow below to view full curriculum)
Intended Audience
Database programmers and DBA's 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.
For the most junior SQL programmer, or the more experienced DBA this class will have something for you.
As a bonus, this course includes a free PDF poster detailing JOIN types, providing you with a ready reference for your future TSQL endeavors. Dive in, and unlock the power of JOINs in TSQL!