1 Basic Operations in a SQL Server-Based Relational Database

2 Tools of the Trade

3 The Foundation Statements of SQL

4 JOINs

5 Creating and Altering Tables

6 Keys and Constraints

7 Advanced Query Topics

8 Normalization and Other Basic Design Issues

9 Speeding Performance: SQL Server Storage and Index Structures

10 Views

11 Writing Scripts and Batches

12 Stored Procedures

13 User Defined Functions

14 Transactions and Locks

15 Triggers

16 XML Support

17 Reporting Services

18 Beginning Data Transformation Services

19 Administration Overview

AppA Exercise Solutions

AppB Function Listing

AppC Tools for Working with SQL Server

AppD Client Accessibility

AppE Samples