MCTS SQL Server 2005 Implementation & Maintenance Study Guide (Exam 70-431)

Shows you what and how to study for the MCDBA SQL Server 2005 Technology Specialist exam. This book covers various official exam objectives, over 250 practice exam questions, and step-by-step exercises.

---

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.


The Best Fully Integrated Study System Available With hundreds of practice questions and hands-on exercises, MCTS SQL Server 2005 Implementation & Maintenance Study Guide covers what you need to know--and shows you how to prepare--for this challenging exam.



100% complete coverage of all official objectives for Exam 70-431

Exam Readiness Checklist at the front of the book--you're ready for the exam when all objectives on the list are checked off

Inside the Exam sections in every chapter highlight key exam topics covered

Simulated exam questions match the format, tone, topics, and difficulty of the real exam


Covers all the exam topics, including:

Installing and Configuring SQL Server 2005 * Creating Databases and Database Objects * SQL Server Security * Creating Views, Partitions, and Linked Servers * Transact-SQL Programming * Working with Constraints, Triggers, and Stored Procedures * Backup and Restore of SQL Server with SQL Agent Jobs * Data Redundancy and Availability * Using the Service Broker * XML Data Support * SQL Server Performance Monitoring and Tuning * Troubleshooting Server and Database Errors

CD-ROM includes:



Complete MasterExam practice testing engine, featuring: One full practice exam; Detailed answers with explanations; Score Report performance assessment tool

Video training clips from the author

Electronic book for studying on the go


With free online registration:



One-hour LearnKey video training session

Bonus downloadable MasterExam practice test