Exploring Transact-SQL
Defining the Role of SQL Server
Defining the Types of SQL Statements
Using SQL Server Books On-Line
Using SQL Query Analyser
Observing and Executing a SQL Script File
Defining Data Types
Working with Object Names
Using Variables
Using Operators in a Query
Creating a Table Using the Basic Table Template
Using Osql

Querying Data
Selecting Data with the SELECT Statement
Using Comparison Operators in a WHERE Clause
Using Wildcards in Queries
Working with Logical Operators
Retrieving Data Based on a Range or List of Values
Sorting Data
Using the DISTINCT Keyword

Changing Data Through Queries
Inserting Data
Using the INSERT...SELECT Statement
Using the SELECT...INTO Statement
Using the DELETE Statement
Deleting Rows Based on a Query
Using the TRUNCATE TABLE Statement
Using the UPDATE Statement
Updating a Table Based on a Query
Working with Explicit Transactions

Summarizing Data
Using Aggregate Functions to Summarize Data
Using TOP in a Query
Designing GROUP BY Queries
Using the WITH ROLLUP Operator
Using the WITH CUBE Operator
Using the GROUPING Function With the WITH CUBE Operator

Joining Tables
Querying Multiple Tables
Designing and Executing an Inner Join
Working with Cross Joins
Working with Self Joins
Joining Multiple Tables
Combining SELECT Statements

Implementing Subqueries
Using a Subquery as a Table
Using Subqueries as an Expression

Working with Full-text Indexes
Implementing the Microsoft Search Service
Enabling Full-text Indexing on the Movie Table
Populating a Full-text Index
Configuring SQL Server to Automatically Update Full-text Indexes
Using the CONTAINS Search Condition in Queries
Using the CONTAINSTABLE Function in Queries
Using the FREETEXTTABLE Function in Queries

Programming Transact-SQL
Creating a View
Displaying View Information
Dropping a View
Using Books Online to Research System Stored Procedures
Creating a Stored Procedure
Executing a Stored Procedure
Creating an INSERT Trigger
Designing and Creating a Scalar Function