Microsoft SQL Server 2005 - Edition 2005

Take your database skills to the next level with this hands-on, step-by-step guide.

Learn more-advanced skills to design, test, deploy, and maintain SQL Server databases-one step at a time. Ideal for developers who understand database essentials, this learn-by-doing tutorial offers practical guidance, code samples, and a collection of techniques to help you solve real-world business problems.

Discover how to:

• Manage data access with server logins and user and server roles
• Implement a disaster recovery strategy
• Use aggregate functions to compute totals and complex statistical values
• Optimize query performance by managing IO statistics and designing indexes
• Work with remote data sources-including third-party databases
• Provide remote access through the Internet or a middle-tier service interface
• Manage transactions, implement error handlers, and define isolation levels
• Go further and work with SQL Server Reporting Services and Notification Services

CD features:

• All practice exercises
• Code samples