Today’s training will be on JOINs. Here is the outline for the training.
- Basic SELECT
- INNER JOIN
- LEFT OUTER JOIN
- RIGHT OUTER JOIN
- LEFT OUTER JOIN with exclusion
- RIGHT OUTER JOIN with exclusion
- SEMI JOIN
- ANTI SEMI JOIN
- CROSS JOIN
- FULL OUTER JOIN
- FULL OUTER JOIN with exclusion
- CROSS APPLY
- OUTER APPLY
- Multiple combinations of JOINs.
I will post the video here after the training is complete.
If you are participating in the training, be sure to download my Join Types Poster to follow along with the presentation. http://stevestedman.com/2015/03/tsql-join-types-poster-version-3/
Here is the recording of the training session: