SQL Server Masterclass for Data Analysis

This repository contains code from exercises I did in the advanced SQL course on Udemy by instructor Travis Cuzick. The SQL language used is T-SQL, from the SQL Server database.

Exercises

• OVER
• PARTITION BY
• ROWNUMBER
• RANK & DENSE_RANK
• LEAD & LAG
• SCALAR SUBQUERIES
• CORRELATED SUBQUERIES
• EXISTS
• FOR XML PATH WITH STUFF
• PIVOT
• CTEs
• TEMP TABLES
• OPTIMIZATION
• LOOKUP TABLES
• VARIABLES
• FUNCTIONS
• STORED PROCEDURES
• CONTROL FLOW WITH IF
• USING MULTIPLE IF STATEMENTS
• DYNAMIC SQL