Sessions Select statement basics Filtering and sorting data Joins, subqueries, and set operators Grouped queries, pivoting, unpivoting, and window functions Querying full text data Querying and managing XML Creating tables and enforcing data integrity Designing and creating views, inline functions, and synonyms Inserting, updating, and deleting data Other data modification aspects Transactions, error handling, and dynamic SQL Designing and implementing TSQL routines Analyzing Query Performance Implementing Indexes and Statistics Cursors, sets, and temporary tables Further optimization aspects