Module 1: Getting Started with Databases and Transact-SQL in SQL Server 2008

1. Overview of SQL Server 2008

2. Overview of SQL Server Databases

3. Overview and Syntax Elements of T-SQL

4. Working with T-SQL Scripts

5. Using T-SQL Querying Tools

Module 2: Querying and Filtering Data

1. Using the SELECT Statement

2. Filtering Data

3. Working with NULL Values

4. Formatting Result Sets

5. Performance Considerations for Writing Queries

Module 3: Grouping and Summarizing Data

1. Summarizing Data by Using Aggregate Functions

2. Summarizing Grouped Data

3. Ranking Grouped Data

4. Creating Crosstab Queries

Module 4: Joining Data from Multiple Tables

1. Querying Multiple Tables by Using Joins

2. Applying Joins for Typical Reporting Needs

3. Combining and Limiting Result Set

Module 5: Working with Subqueries

1. Writing Basic Subqueries

2. Writing Correlated Subqueries

3. Comparing Subqueries with Joins and Temporary Tables

4. Using Common Table Expressions

Module 6: Modifying Data in Tables

1. Inserting Data into Tables

2. Deleting Data from Tables

3. Updating Data in Tables

4. Overview of Transactions

Module 7: Querying Metadata, XML, and Full-Text Indexes

1. Querying Metadata

2. Overview of XML

3. Querying XML Data

4. Overview of Full-Text Indexes

5. Querying Full-Text Indexes

Module 8: Using Programming Objects for Data Retrieval

1. Overview of Views

2. Overview of User-Defined Functions

3. Overview of Stored Procedures

4. Overview of Triggers

5. Writing Distributed Queries

Module 9: Using Advanced Querying Techniques

1. Considerations for Querying Data

2. Working with Data Types

3. Cursors and Set-Based Queries

4. Dynamic SQL

5. Maintaining Query Files