T-SQL, query optimization, database design, and stored procedures
Write confident queries with SELECT, JOIN, GROUP BY, and subqueries.
Window functions, CTEs, query plans, and performance tuning.