| 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 Function ,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 |