MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance (Exam 70-444) Study Guide

Victor Isakov, Marilyn Miller-White, J. Steven Jones, Andy Warren

  • 出版商: Sybex
  • 出版日期: 2007-07-10
  • 售價: $1,900
  • 貴賓價: 9.5$1,805
  • 語言: 英文
  • 頁數: 647
  • 裝訂: Paperback
  • ISBN: 0470127457
  • ISBN-13: 9780470127452
  • 相關分類: MSSQLSQL
  • 已過版

商品描述

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.