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