Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft TSQL JOIN Types
Course Introduction
Introduction (1:07)
Venn Diagram and JOIN Types Poster (0:43)
Why These are Important
What You'll Learn (0:40)
How to Get the Most Out of This Course (0:32)
Prerequisites
Sample Code Download
Your Goal for This Course
Top SQL JOIN Interview Question (0:46)
Lesson 1: Basic SELECT
Video Training (2:39)
Sample Code
Try it yourself
Lesson 2: INNER JOIN
Inner Join Overview
What is the Join Predicate?
Video Lesson - Inner Join (4:22)
Sample Code
Try it yourself
Inner Join Quiz
Lesson 3: LEFT OUTER JOIN
Left Outer Join Overview
Video Lesson - Left Outer Join (2:17)
Sample Code
Assignment
Left Outer Join Quiz
Lesson 4: RIGHT OUTER JOIN
Right Outer Join Overview
Video Lesson - Right Outer Join (2:27)
Sample Code
Assignment
Difference Between LEFT OUTER JOIN and RIGHT OUTER JOIN
Lesson 5: SEMI JOIN
Video Lesson - Semi Join (1:45)
Sample Code
Try it yourself
Lesson 6: ANTI SEMI JOIN
Video Lesson - Anti Semi Join (0:36)
Sample Code
Try it yourself
Lesson 7: LEFT OUTER JON with exclusion
Video Lesson (1:16)
Sample Code
Try it yourself
Lesson 8: RIGHT OUTER JOIN with exclusion
Video Lesson (0:49)
Sample Code
Try it yourself
Lesson 9: FULL OUTER JOIN
Overview - Full Outer Join
Video Lesson - Full Outer Join (1:00)
Sample Code
Try it yourself
Lesson 10: FULL OUTER JOIN with exclusion
Video Lesson (1:08)
Sample Code
Try it yourself
Lesson 11: CROSS JOIN
Cross Join Overview
Video Lesson - Cross Join (1:57)
Sample Code
Try it yourself
Lesson 12: APPLY Intro & CROSS APPLY
Cross Apply Overview
Video Lesson - Cross Apply (6:24)
Sample Code
Try it yourself
Quiz - Cross Apply
Lesson 13: OUTER APPLY
Video Lesson - Outer Apply (0:50)
Sample Code
Try it yourself
Lesson 14: EQUI JOIN vs. NON EQUI JOIN
Overview Equi and Non Equi Join
Video Lesson Equi and Non Equi Join (3:10)
Sample Code
Try it yourself
Lesson 15: Two INNER JOINS
Two Inner Joins - Why?
Video Lesson - Two Inner Joins (2:13)
Sample Code
Try it yourself
Lesson 16: Two LEFT OUTER JOINS
Video Lesson - Two Left Outer Joins (0:57)
Sample Code
Try it yourself
Lesson 17: INNER and OUTER JOIN
Video Lesson - Inner and Outer (0:51)
Sample Code
Try it yourself
Lesson 18: Two FULL OUTER JOINS
Video Lesson - Two Full Outer Joins (0:56)
Sample Code
Try it yourself
Lesson 19: Except, Intersect & Union
Video Lesson (1:57)
Sample Code
Try it yourself
Congratulation!
End of course Wrap-up (2:58)
How to Get The Most Out of This Course Going Forward (0:44)
Top SQL JOIN Interview Question (2:02)
Other Interview Questions
End of Course Comprehension
Quiz 1 (1:02)
Quiz 2 (1:30)
Quiz 3 (1:39)
Course Completion Certificate
Teach online with
Cross Join Overview
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock