MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance (Exam 70-444) Study Guide
暫譯: MCITP 管理員：Microsoft SQL Server 2005 優化與維護 (考試 70-444) 學習指南

Description

• Covering Microsoft's brand-new SQL 2005 administrator exam, this study guide walks readers through setting up, maintaining, and troubleshooting database solutions
• Reviews key topics such as defining high-availability solutions, automating administrative tasks, defining security solutions, monitoring and troubleshooting the database server, and designing and executing deployments
• Candidates must first complete the requirements for the MCTS exam and have three or more years dedicated to database work; then they may earn their MCITP by passing two exams
• The CD-ROM features leading-edge exam prep software with an assessment test, test engine of case study practice questions, and electronic flashcards

 

Table of Contents

Introduction.

Assessment Test.

Chapter 1: Optimizing the Performance of Databases and Database Servers.

Chapter 2: Optimizing the Performance of Queries.

Chapter 3: Optimizing and Implementing a Data Recovery Plan for a Database.

Chapter 4: Designing a Strategy to Monitor a Database Solution.

Chapter 5: Designing a Strategy to Maintain a Database Solution.

Chapter 6: Designing and Managing SSIS Packages.

Chapter 7: Designing a Database Data Management Strategy.

Chapter 8: Designing a Strategy to Manage Replication.

Chapter 9: Protecting Your SQL Server from Attack.

Chapter 10: Designing a Strategy to Manage and Maintain Database Security.

Glossary.

Index.