Microsoft SQL Server 2005 Implementation and Maintenance Self-Paced Training Kit MCTS Exam 70-431  (Hardcover, Solid Quality Learning)

An excellent resource material for those preparing for MCTS Exam 70-431. The book gives 450 practice and review questions and also practice tests with multiple, customizable testing options and a learning plan based on your results. It also contains a fully searchable eBook of this guide.

Learn how to:

• Install and configure SQL Server
• Create tables and indexes, define columns, and implement constraints
• Work with relational and XML data
• Prepare a backup strategy and restore a database

Table of Contents

1. Planning a Database Server Infrastructure
2. Deploying and Consolidating Multiple Instances
3. Designing SQL Server Security in the Enterprise
4. Designing Database Server Security Policies
6. Designing Database Security
7. Planning for High Availability in the Enterprise
8. Failover Clustering
9. Database Mirroring
10. Log Shipping
11. Replication
12. Designing the Physical Database
13. Designing a Data Recovery Strategy
14. Archiving Database Data