Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


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

Subscriber Reviews

Average Rating: 0 out of 5 rating Based on 0 Ratings

No Subscribers have provided a review for this book.

Table of Contents



The publisher has provided additional content related to this title.

A Message from the Publisher

Please download the attached files for instructions as to accessing the companion CD materials.

Windows version files