Introduction
1. Foundations of Querying
-Before You Begin
-Lesson 1: Understanding the Foundations of T-SQL
-Lesson 2: Understanding Logical Query Processing
-Case Scenarios
-Suggested Practices
-Answers
2. Getting Started with the SELECT Statement
-Before You Begin
-Lesson 1: Using the FROM and SELECT Clauses
-Lesson 2: Working with Data Types and Built-in Functions
-Case Scenarios
-Suggested Practices
-Answers
3. Filtering and Sorting Data
-Before You Begin
-Lesson 1: Filtering Data with Predicates
-Lesson 2: Sorting Data
-Lesson 3: Filtering Data with TOP and OFFSET-FETCH
-Case Scenarios
-Suggested Practices
-Answers
4. Combining Sets
-Before You Begin
-Lesson 1: Using Joins
-Lesson 2: Using Subqueries, Table Expressions, and the APPLY Operator
-Lesson 3: Using Set Operators
-Case Scenarios
-Suggested Practices
-Answers
5. Grouping and Windowing
-Before You Begin
-Lesson 1: Writing Grouped Queries
-Lesson 2: Pivoting and Unpivoting Data
-Lesson 3: Using Window Functions
-Case Scenarios
-Suggested Practices
-Answers
6. Querying Full-Text Data
-Before You Begin
-Lesson 1: Creating Full-Text Catalogs and Indexes
-Lesson 2: Using the CONTAINS and FREETEXT Predicates
-Lesson 3: Using the Full-Text and Semantic Search Table-Valued Functions
-Case Scenarios
-Suggested Practices
-Answers
7. Querying and Managing XML Data
-Before You Begin
-Lesson 1: Returning Results As XML with FOR XML
-Lesson 2: Querying XML Data with XQuery
-Lesson 3: Using the XML Data Type
-Case Scenarios
-Suggested Practices
-Answers
8. Creating Tables and Enforcing Data Integrity
-Before You Begin
-Lesson 1: Creating and Altering Tables
-Lesson 2: Enforcing Data Integrity
-Case Scenarios
-Suggested Practices
-Answers
9. Designing and Creating Views, Inline Functions, and Synonyms
-Before You Begin
-Lesson 1: Designing and Implementing Views and Inline Functions
-Lesson 2: Using Synonyms
-Case Scenarios
-Suggested Practices
-Answers
10. Inserting, Updating, and Deleting Data
-Before You Begin
-Lesson 1: Inserting Data
-Lesson 2: Updating Data
-Lesson 3: Deleting Data
-Case Scenarios
-Suggested Practices
-Answers
11. Other Data Modification Aspects
-Before You Begin
-Lesson 1: Using the Sequence Object and IDENTITY Column Property
-Lesson 2: Merging Data
-Lesson 3: Using the OUTPUT Option
-Case Scenarios
-Suggested Practices
-Answers
12. Implementing Transactions, Error Handling, and Dynamic SQL
-Before You Begin
-Lesson 1: Managing Transactions and Concurrency
-Lesson 2: Implementing Error Handling
-Lesson 3: Using Dynamic SQL
-Case Scenarios
-Suggested Practices
-Answers
13. Designing and Implementing T-SQL Routines
-Before You Begin
-Lesson 1: Designing and Implementing Stored Procedures
-Lesson 2: Implementing Triggers
-Lesson 3: Implementing User-Defined Functions
-Case Scenarios
-Suggested Practices
-Answers
14. Using Tools to Analyze Query Performance
-Before You Begin
-Lesson 1: Getting Started with Query Optimization
-Lesson 2: Using SET Session Options and Analyzing Query Plans
-Lesson 3: Using Dynamic Management Objects
-Case Scenarios
-Suggested Practices
-Answers
15. Implementing Indexes and Statistics
-Before You Begin
-Lesson 1: Implementing Indexes
-Lesson 2: Using Search Arguments
-Lesson 3: Understanding Statistics
-Case Scenarios
-Suggested Practices
-Answers
16. Understanding Cursors, Sets, and Temporary Tables
-Before You Begin
-Lesson 1: Evaluating the Use of Cursor/Iterative Solutions vs. Set-Based Solutions
-Lesson 2: Using Temporary Tables vs. Table Variables
-Case Scenarios
-Suggested Practices
-Answers
17. Understanding Further Optimization Aspects
-Before You Begin
-Lesson 1: Understanding Plan Iterators
-Lesson 2: Using Parameterized Queries and Batch Operations
-Lesson 3: Using Optimizer Hints and Plan Guides
-Case Scenarios
-Suggested Practices
-Answers
Index
