Hjem

Chapter 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
Chapter 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
Chapter 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
Chapter 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
Chapter 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
Chapter 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
Chapter 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
Chapter 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
Chapter 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
Chapter 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
Chapter 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
Chapter 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
Chapter 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
Chapter 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
Chapter 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
Chapter 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
Chapter 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