Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

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

Groupig 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, SML 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 Maintraining Query Files