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

Description

EXAM PREP GUIDE 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

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 answers - including 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(R) books.
* 180-day trial of SQL Server 2008 Enterprise Edition.
* Fully searchable eBook of this guide.

CONTENTS:

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 2008 - Implementation and MaintenanceAdditional Resources for IT Professionals from Microsoft PressGet Certified - SQL Server 2008