MCITP SQL Server 2005 Database Administration All-in-One Exam Guide (Exams 70-431, 70-443, & 70-444)

All-in-One is All You Need

Get complete coverage of all three Microsoft Certified IT Professional database administration exams for SQL Server 2005 in this comprehensive volume. Written by a SQL Server expert and MCITP, this definitive exam guide features learning objectives at the beginning of each chapter, exam tips, practice questions, and in-depth explanations. Detailed and authoritative, the book serves as both a complete certification study guide and an essential on-the-job reference.

Get full details on all exam topics including how to:

• Install and configure SQL Server 2005

• Use Transact-SQL

• Manage server infrastructure design

• Optimize databases

• Secure databases and servers

• Ensure high availability

• Implement backup and recovery strategies

• Maximize the built-in administration tools

• Use Business Intelligence tools, including SSIS and SSRS

• Manage concurrency

The CD-ROM features:

• Six full practice exams—two for each exam: 70-431, 70-443, and 70-444

• Scripts from the step-by-step exercises in the book

• Video training clips from the author

• Complete electronic book

Darril Gibson, MCITP, MCDBA, MCSE, is a professional trainer specializing in Microsoft Technologies. He has created several video training courses for Keystone learning.