Wednesday, July 23, 2008

MCTS Self-Paced Training Kit (Exam 70-431): Microsoft® SQL Server™ 2005—Implementation and Maintenance

Author Solid Quality Learning
Pages 992
Disk 1 Companion CD(s); 1 Evaluation DVD(s)
Level Beg/Int
ISBN 9780735622715

Exam Prep Guide
Ace your preparation for the skills measured by MCTS Exam 70-431—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce what you’ve learned by applying your knowledge to real-world case scenarios and practices. This official Microsoft study guide is designed to help you make the most of your study time.

Maximize your performance on the exam by learning to:
•Install and configure SQL Server
•Create tables and indexes, define columns, and implement constraints
•Implement functions, stored procedures, and triggers by using Transact-SQL
•Work with relational and XML data
•Monitor, troubleshoot and tune queries
•Maintain database availability with log shipping, database mirroring, and replication
•Prepare a backup strategy and restore a database