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
Electronic content 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
