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

Browse Similar Topics

Top Level Categories:
Information Technology & Software Development
Product
Vendor

Sub-Categories:
Information Technology & Software Development > Databases
Databases > Microsoft SQL Server
Product > Microsoft SQL Server 2005
Vendor > Microsoft