MCITP Administrator
Microsoft SQL Server 2005 Optimization and Maintenance (Exam 70-444) Study Guide
1st Edition
Published on 6. July 2007
Book
Paperback/Softback
648 pages
978-0-470-12745-2 (ISBN)
Description
Your essential guide to Microsoft's new SQL Server 2005 certification
Get the preparation you need for exam 70-444, Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005, one of two required exams in the Microsoft MCITP: Database Administrator certification path. Inside, you'll find:
* Full coverage of all exam objectives in a systematic approach, so you can be confident you're getting the instruction you need for the exam
*
Practical hands-on exercises to reinforce critical skills
*
Real-world scenarios that put what you've learned in the context of actual job roles
*
Challenging review questions in each chapter to prepare you for exam day
*
Exam Essentials, a key feature at the end of each chapter that identifies critical areas you must become proficient in before taking exam 70-444
*
A handy tear card that maps every official exam objective to the corresponding chapter in the book, so you can track your exam prep, objective by objective
Look inside for complete coverage of all exam objectives.
Featured on the CD
SYBEX TEST ENGINE:
Test your knowledge with advanced testing software. Includes all chapter review questions and bonus exams.
ELECTRONIC FLASHCARDS:
Reinforce your understanding with flashcards that can run on your PC, Pocket PC, or Palm handheld.
Also on the CD, you'll find the entire book in searchable and printable PDF. Study anywhere, any time, and approach the exam with confidence.
Get the preparation you need for exam 70-444, Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005, one of two required exams in the Microsoft MCITP: Database Administrator certification path. Inside, you'll find:
* Full coverage of all exam objectives in a systematic approach, so you can be confident you're getting the instruction you need for the exam
*
Practical hands-on exercises to reinforce critical skills
*
Real-world scenarios that put what you've learned in the context of actual job roles
*
Challenging review questions in each chapter to prepare you for exam day
*
Exam Essentials, a key feature at the end of each chapter that identifies critical areas you must become proficient in before taking exam 70-444
*
A handy tear card that maps every official exam objective to the corresponding chapter in the book, so you can track your exam prep, objective by objective
Look inside for complete coverage of all exam objectives.
Featured on the CD
SYBEX TEST ENGINE:
Test your knowledge with advanced testing software. Includes all chapter review questions and bonus exams.
ELECTRONIC FLASHCARDS:
Reinforce your understanding with flashcards that can run on your PC, Pocket PC, or Palm handheld.
Also on the CD, you'll find the entire book in searchable and printable PDF. Study anywhere, any time, and approach the exam with confidence.
More details
Edition
1., Auflage
Language
English
Place of publication
Chichester
United Kingdom
Publishing group
John Wiley and Sons Ltd
Target group
Professional and scholarly
Illustrations
Illustrations
Dimensions
Height: 23.1 cm
Width: 18.5 cm
Thickness: 3.5 cm
Weight
952 gr
ISBN-13
978-0-470-12745-2 (9780470127452)
Schweitzer Classification
Persons
Victor Isakov, MCITP, is a database architect and Microsoft Certified Trainer who provides consultation and training to various organizations in the public, private, and NGO sectors globally. He has authored a number of books on SQL Server and worked closely with Microsoft to develop the new generation of SQL Server 2005 Certification and Microsoft official curriculum for both Instructor Led Training and e-Learning courses. He also writes articles regularly for devx.com and searchsqlserver.com.
Marilyn Miller-White, MCTS, MCITP, MCT, MCDBA, MCSE, is the owner of White Consulting, a New Jersey-based consultancy specializing in database and systems training and solutions.
J. Steven Jones, MCDBA, is a senior database architect with over ten years of experience with SQL Server. He is a regular contributor and columnist for sqlservercentral.com.
Andy Warren is president of Different Path Consulting and is also a senior trainer with End to End Training.
Marilyn Miller-White, MCTS, MCITP, MCT, MCDBA, MCSE, is the owner of White Consulting, a New Jersey-based consultancy specializing in database and systems training and solutions.
J. Steven Jones, MCDBA, is a senior database architect with over ten years of experience with SQL Server. He is a regular contributor and columnist for sqlservercentral.com.
Andy Warren is president of Different Path Consulting and is also a senior trainer with End to End Training.
Content
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. Designing a Strategy to Manage Database Security.
Chapter 10. Designing a Strategy to Maintain Database Security.
Glossary.
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. Designing a Strategy to Manage Database Security.
Chapter 10. Designing a Strategy to Maintain Database Security.
Glossary.