Course Introduction
Your Goal for This Course
Lesson 1: Basic SELECT
Lesson 2: INNER JOIN
Lesson 3: LEFT OUTER JOIN
Lesson 4: RIGHT OUTER JOIN
Lesson 5: SEMI JOIN
Lesson 6: ANTI SEMI JOIN
Lesson 7: LEFT OUTER JON with exclusion
Lesson 8: RIGHT OUTER JOIN with exclusion
Lesson 9: FULL OUTER JOIN
Lesson 10: FULL OUTER JOIN with exclusion
Lesson 11: CROSS JOIN
Lesson 12: APPLY Intro & CROSS APPLY
Lesson 13: OUTER APPLY
Lesson 14: EQUI JOIN vs. NON EQUI JOIN
Lesson 15: Two INNER JOINS
Lesson 16: Two LEFT OUTER JOINS
Lesson 17: INNER and OUTER JOIN
Lesson 18: Two FULL OUTER JOINS
Lesson 19: Except, Intersect & Union
Congratulation!
End of Course Comprehension
