Getting Started with Databases and Transact-SQL in SQL Server 2008
o Overview of SQL Server 2008
o Overview of SQL Server Databases
o Overview and Syntax Elements of T-SQL
o Working with T-SQL Scripts
o Using T-SQL Querying Tools
Querying and Filtering Data
o Using the SELECT Statement
o Filtering Data
o Working with NULL Values
o Formatting Result Sets
o Performance Considerations for Writing Queries
Grouping and Summarizing Data
o Summarizing Data by Using Aggregate Functions
o Summarizing Grouped Data
o Ranking Grouped Data
o Creating Crosstab Queries
Joining Data from Multiple Tables
o Querying Multiple Tables by Using Joins
o Applying Joins for Typical Reporting Needs
o Combining and Limiting Result Set
Working with Subqueries
o Writing Basic Subqueries
o Writing Correlated Subqueries
o Comparing Subqueries with Joins and Temporary Tables
o Using Common Table Expressions
Modifying Data in Tables
o Inserting Data into Tables
o Deleting Data from Tables
o Updating Data in Tables
o Overview of Transactions
Querying Metadata, XML, and Full-Text Indexes
o Querying Metadata
o Overview of XML
o Querying XML Data
o Overview of Full-Text Indexes
o Querying Full-Text Indexes
Using Programming Objects for Data Retrieval
o Overview of Views
o Overview of User-Defined Functions
o Overview of Stored Procedures
o Overview of Triggers
o Writing Distributed Queries
Using Advanced Querying Techniques
o Considerations for Querying Data
o Working with Data Types
o Cursors and Set-Based Queries
o Dynamic SQL
o Maintaining Query Files
