Announcing an all-new MCTS Training Kit designed to help maximize your performance on Exam 70-431, a core exam for the new Microsoft IT Professional certifications. This kit packs the tools and features wanted mostincluding 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 installing and configuring SQL Server, implementing database mirroring, managing database snapshots, working with XML and flat files, managing replication, backing up and restoring a database, and more.

This training kit is designed for information technology (IT) professionals who plan to take Microsoft Certified Technical Specialist (MCTS) exam 70-431, as well as for IT professionals who need to know how to implement and maintain Microsoft SQL Server 2005 databases. We assume that before you begin using this kit you have a working knowledge of Microsoft Windows, network technologies, relational databases and their design, Transact-SQL, and the SQL Server 2005 client tools.

By using this training kit, you’ll learn how to

■ Install and configure SQL Server 2005.
■ Create and implement database objects.
■ Implement high availability and disaster recovery.
■ Maintain databases.
■ Support data consumers.
■ Monitor and troubleshoot SQL Server performance.