MCITP SQL Server 2005 Database Administration All-in-One Exam Guide (Exams 70-431, 70-443, & 70-444)

MCITP SQL Server 2005 Database Administration All-in-One Exam Guide (Exams 70-431, 70-443, & 70-444)

by Darril Gibson

NOOK Book(eBook)

$40.99 $69.99 Save 41% Current price is $40.99, Original price is $69.99. You Save 41%.
View All Available Formats & Editions

Available on Compatible NOOK Devices and the free NOOK Apps.
WANT A NOOK?  Explore Now


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
  • Video training clips from the author

Product Details

ISBN-13: 9780071595636
Publisher: McGraw-Hill Education
Publication date: 10/16/2007
Series: All-in-One
Sold by: Barnes & Noble
Format: NOOK Book
Pages: 752
File size: 27 MB
Note: This product may take a few minutes to download.

About the Author

Darril Gibson, MCITP, MCDBA, MCSE, is a professional trainer specializing in Microsoft Technologies. He has created several video training courses for Keystone learning.

Table of Contents

Chapter 1: Installing and Configuring SQL Server 2005
Chapter 2: SQL Server 2005 Database Basics
Chapter 3: Database Design
Chapter 4: Transact-SQL Primer
Chapter 5: Advanced Database Objects
Chapter 6: Server Infrastructure Design
Chapter 7: Optimizing Databases
Chapter 8: Database Security
Chapter 9: Server Security
Chapter 10: High-Availability Strategies
Chapter 11: Data Recovery Strategies
Chapter 12: Data Access
Chapter 13: Database Administrator Tools
Chapter 14: Business Intelligence
Chapter 15: Managing Concurrency
Appendix A: About the CD
Appendix B: Exam 70-431: What You Need to Know to Pass
Appendix C: Inside the Design Test
Appendix D: Exam 70-443: What You Need to Know to Pass
Appendix E: Exam 70-444: What You Need to Know to Pass
Appendix F: SQL Database Design Object Summary

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews

MCITP SQL Server 2005 Database Administration All-in-One Exam Guide (Exams 70-431, 70-443, & 70-444) 4.6 out of 5 based on 0 ratings. 5 reviews.
Anonymous More than 1 year ago
Anonymous More than 1 year ago
"Do you live by yourself?" -branchclaw
Brian_J_D More than 1 year ago
I highly recommend this book for any aspiring SQL Server Database Administrator. I have spent the last three months actively reading through the book and performing the exercises and I am proud to say that was time well spent. Last Thursday and Friday I took all three exams and passed with flying colors. Instead of dividing the book exam by exam, Darril Gibson has done an outstanding job in assembling a resource that actually covers the material spanning all three exams at once. I found this method exceptionally helpful because you actually gain an understanding of the material by learning how all the pieces fit together instead of only memorizing material exam-by-exam.
Anonymous More than 1 year ago
Guest More than 1 year ago
The exercises in this book are superb. So many times I¿ve picked up a technical book and tried the different exercises but the steps just don¿t work, or the exercises don¿t give the details needed to complete the exercise. In this book, I¿ve found the exercises are in-depth and accurate, and appropriate for the MCITP exams. I just finished the exercises on Triggers and several concepts have become clearer for me.