1 Installing SQL Server 2005
2 Configuring SQL Server 2005
3 Creating Tables, Constraints, and User-Defined Types
4 Creating Indexes
5 Working with Transact-SQL
6 Creating Partitions
7 Implementing Views
8 Managing XML Data
9 Creating Functions, Stored Procedures, and Triggers
10 Working with Flat Files
11 Backing Up, Restoring, and Moving a Database
12 Using Transact-SQL to Manage Databases
13 Working with HTTP Endpoints
14 Working with SQL Server Agent Jobs
15 Monitoring and Troubleshooting SQL Server Performance
16 Managing Database Snapshots
17 Implementing Database Mirroring
18 Implementing Log Shipping
19 Managing Replication
20 Working with Service Broker
21 Creating Full-Text Catalogs