Sessions • Creating Tables and Enforcing Data Integrity • Inserting, Updating, and Deleting Data • Select Statement • Joins and Subqueries • Filtering and Sorting Data • Grouping, and Windowing • Designing and Creating Views, Inline Functions, and Stored Procedures • Implementing Transactions, Error Handling, and Dynamic SQL • Designing and Implementing TSQL Routines • Understanding Cursors, Sets, and Temporary Tables • Using Tools to Analyze Query Performance • Implementing Indexes and Statistics • Security and User Management • Backup and Recovery • Scaling, Monitoring, and HA