Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.






All-in-One is All You NeedGet 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