MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008 Implementation and Maintenance

Hardcover: 900 pages
Publisher: Microsoft Press (February 2009)
Language: English
ISBN-10: 0735626057
ISBN-13: 978-0735626058

04/06/2012 · No Responses

Ace your preparation for the skills measured by MCTS Exam 70-432—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time.

Maximize your performance on the exam by learning to:

Configure, manage, back up, and restore databases
Create a partitioned table, index, or indexed view
Configure services and components to manage your environment
Help prevent unauthorized access at each security infrastructure layer
Design and deploy high-availability solutions
Manage SQL Server Agent jobs, alerts, and operators
Identify service, concurrency, and job execution problems

Table of Contents
Chapter 1. Installing and Configuring SQL Server 2008
Chapter 2. Database Configuration and Maintenance
Chapter 3. Tables
Chapter 4. Designing SQL Server Indexes
Chapter 5. Full Text Indexing
Chapter 6. Distributing and Partitioning Data
Chapter 7. Importing and Exporting Data
Chapter 8. Designing Policy Based Management
Chapter 9. Backing up and Restoring a Database
Chapter 10. Automating SQL Server
Chapter 11. Designing SQL Server Security
Chapter 12. Monitoring Microsoft SQL Server
Chapter 13. Optimizing Performance
Chapter 14. Failover Clustering
Chapter 15. Database Mirroring
Chapter 16. Log Shipping
Chapter 17. Replication