Detailed information on…
- Installing, upgrading, and administering SQL Server 2005
- Database maintenance, backup, and recovery
- Creating and managing tables, views, stored procedures, triggers, and user-defined functions
- Database and index design
- SQL Server query optimization, and performance monitoring and tuning
- Transactions, transaction management, and distributed transactions
- SQL Server Management Studio—NEW!
- SQL Server Notification Services; Integration Services—NEW!; Analysis Services; Reporting Services—NEW!; Web Services—NEW!
- SQL Server Service Broker—NEW!
- SQL Server and Microsoft .NET Framework integration, including CLR-based stored procedures, functions, and triggers—NEW!
- SQL Server high availability and SQL Server clustering and replication
- Database Mirroring—NEW!
- Database Snapshots—NEW!
- Using XML in SQL Server 2005
- SQL Server tools and utilities