3 Review(s)

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