Advanced SQL Tutorial

In this tutorial I will cover many advanced SQL concepts like full outer joins, coalesce, cross apply, outer apply, intersect, except and pivot.
NOTE: The database I use for this tutorial is MS SQL Server and the syntax can vary depending on the database.