TRY...CATCH, Dynamic Sql, Sql, Lag, window functions, RANK, GROUPING SETS, NTILE, recursive queries, analytic functions, Indexing, Pivot, ROW NUMBER, CASE, aggregation techniques, DENSE RANK, ROLLUP, performance optimization, Statistics, partitioning, Lead, error handling, UNPIVOT, HAVING