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

Have a Promotion Code?

Please enter it here:

Great deals and more!

Sign up for special offers, exclusive discounts, and new product announcements from McGraw-Hill Professional.




October 16, 2007


Mixed media product, 752 pages

Other Formats


0071496092 / 9780071496094


Your Price



Main description

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

The CD-ROM 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
  • Complete electronic book

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

Author comments

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

Copyright 2014 McGraw-Hill Global Education Holdings, LLC


Before you can enjoy free downloads from McGraw-Hill Professional, we ask that you please provide your email address and country.

Yes, I want to receive other special offer.