Review of MCITP Self-Paced Training Kit (Exam 70-444): Optimizing and Maintaining a Database Administration Solution Using Microsoft® SQL Server(TM) 2005 (Pro-Certification) (Hardcover)
Pretty good coverage on measuring and troubleshooting server performance and query performance. Good chapter on index optimization and maintenance. This book also covers replication and security well. All in all, a valuable reference that will also help you pass the exam.
Product Description
Announcing an all-new Microsoft Certified IT Professional MCITP Training Kit designed to help maximize your performance on Exam 70-444, an exam for the new MCITP: Database Administrator certification. This kit packs the tools and features exam candidates want most-including in-depth, self-paced training based on final exam content; rigorous, objective-by-objective review; exam tips from expert, exam-certified authors; and a robust testing suite. It also provides real-world scenarios, case study examples, and troubleshooting labs for skills and expertise that you can apply to the job.
Focusing on SQL Server 2005, this official study guide covers topics such as optimizing the performance of database servers, implementing a data recovery plan, designing a strategy for monitoring and maintaining a database, designing a database management strategy, and designing a strategy to manage and maintain database security.
Ace your exam preparation and ramp up quickly on SQL Server 2005 database administration by working at your own pace through the lessons, hands-on exercises, and practice tests. The CD features 425 practice questions and a flexible test engine with pre-assessment and post-assessment capabilities. Choose timed or untimed testing mode, generate random tests, or focus on discrete objectives or chapters, and get detailed explanations for right and wrong answers-including pointers back to the book for further study. You also get a 180-day evaluation version of SQL Server 2005 Enterprise Edition and a 15 percent exam discount voucher-making this kit an exceptional value and a great career investment.
Comprehensive study guide written by exam-certified authors- Deeper, more focused coverage of exam objectives and sub-objectives-plus instructive case studies and troubleshooting scenarios to enhance your performance on the job- 425 practice questions on CD- Test engine that enables customized testing, pre-assessment and post-assessment, and automated scoring and feedback- Complete objective-by-objective review section, plus a tear-out exam-mapping grid- Exam tips based on real-world test experience- 180-day evaluation version of SQL Server 2005 Enterprise Edition- 15 percent exam discount voucher from a leading authorized testing center (limited time offer)- Microsoft Encyclopedia of Networking, Second Edition, eBook- Practice files on CD- Entire study guide in searchable eBook format