MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008 Implementation And Maintenance Book/CD Package

EXAM PREP GUIDE Ace your preparation for the skills measured by MCTS Exam 70-432and 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 youve 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

PRACTICE TESTS Assess your skills with the practice tests on CD. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs. You get detailed explanations for right and wrong answersincluding a customized learning path that describes how and where to focus your studies.

Your kit includes:

• 15% exam discount from Microsoft. Offer expires 12/31/13. Details inside.
• Official self-paced study guide.
• Practice tests with multiple, customizable testing options and a learning plan based on your results.
• 250+ practice and review questions.
• Case scenarios, exercises, and best practices.
• Sample chapters from related Microsoft Press books.
• 180-day trial of SQL Server 2008 Enterprise Edition.
• Fully searchable eBook of this guide.

DedicationAcknowledgementsIntroductionChapter 1: Installing and Configuring SQL Server 2008Chapter 2: Database Configuration and MaintenanceChapter 3: TablesChapter 4: Designing SQL Server IndexesChapter 5: Full Text IndexingChapter 6: Distributing and Partitioning DataChapter 7: Importing and Exporting DataChapter 8: Designing Policy Based ManagementChapter 9: Backing up and Restoring a DatabaseChapter 10: Automating SQL ServerChapter 11: Designing SQL Server SecurityChapter 12: Monitoring Microsoft SQL ServerChapter 13: Optimizing PerformanceChapter 14: Failover ClusteringChapter 15: Database MirroringChapter 16: Log ShippingChapter 17: ReplicationGlossaryAnswersSystem RequirementsAbout the AuthorExam 70-432: Microsoft SQL Server 2008Implementation and MaintenanceAdditional Resources for IT Professionals from Microsoft PressGet CertifiedSQL Server 2008