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

Darril Gibson (Author)

Book Description

ISBN-10: 0071496092 | ISBN-13: 978-0071496094 | Publication Date: September 25, 2007 | Edition: 1

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

Editorial Reviews

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.

Product Details

• Hardcover: 752 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (September 25, 2007)
• Language: English
• ISBN-10: 0071496092
• ISBN-13: 978-0071496094
• Product Dimensions: 9.4 x 7.7 x 1.8 inches
• Shipping Weight: 3.3 pounds (View shipping rates and policies)
• Average Customer Review: 4.4 out of 5 stars  See all reviews (10 customer reviews)
• Amazon Best Sellers Rank: #1,041,020 in Books (See Top 100 in Books)

More About the Author

After a 22 year Navy career working with computers and electronics, I've turned my attention to computers, teaching and writing, especially related to IT certifications.

I've been focused on IT-related security quite a bit in the last few years, teaching, writing, and editing. I have written security related books including books on Security+, SSCP, MTA Security, Risk, and more.

Current security certifications include Security+, CASP, SSCP, and CISSP. Additionally, I've passed 37 Microsoft tests and earned 19 Microsoft certifications (maybe more by the time you read this) and a few non-Microsoft certifications. Check out my Microsoft transcript here: mcp.microsoft.com/authenticate/validatemcp.aspx.
Transcript ID: 660310
Access Code: DarrilGibson

I understand how the Microsoft testing and certification process works. As an MCT since 1999, I've helped countless students learn Microsoft products and become certified. Additionally, I've helped hundreds of students earn the Security+ certification over the years, and thousands have passed the Security+ certification using one of my books.

One of the treasured joys in my life is getting emails from past students and readers letting me know they've become certified and/or moved up in their job status. Feel free to contact me through GetCertifiedGetAhead.com.

Customer Reviews

Most Helpful Customer Reviews

7 of 8 people found the following review helpful:

5.0 out of 5 stars Fantastic Resource!, March 12, 2008

By 

wgh (NJ) - See all my reviews

This review is from: MCITP SQL Server 2005 Database Administration All-in-One Exam Guide (Exams 70-431, 70-443, & 70-444) (Hardcover)

This is a great book! It is very well written and the material presented in a consitent and logical manner.

Some of the material I knew before picking up this book. Since this would be my first MS cert, I read every section of the book. For the topics I already knew, I was impressed by how well Darril boiled the material down to the essence, the central point that you needed to learn. I was hoping that he'd do the same for the areas I did not know. I passed all three tests and this book was the reason.

Read every page. Do every hands-on example. Review the exam tips and you'll not only pass the test but actually be able to do the work.

3 of 3 people found the following review helpful:

5.0 out of 5 stars Excellent Resource for 70-447 Upgrade Exam, August 29, 2008

By 

Brad Blackmon (Santa Clara, CA) - See all my reviews
(REAL NAME)   

This review is from: MCITP SQL Server 2005 Database Administration All-in-One Exam Guide (Exams 70-431, 70-443, & 70-444) (Hardcover)

I used this book as my primary study/refresher resource to prepare for (and pass) the 70-447 upgrade exam. If you are an MCDBA on SQL 2000, and looking for a resource to for the MCDBA upgrade exam, this is the perfect resource! Very clear, concise coverage of all the exam topics. Each chapter has a bullet list listing the topics covered in each exam. Although the 70-447 exam isn't specifically targeted, you can approximate it by combining the 70-443 and 70-444 topics.

3 of 3 people found the following review helpful:

3.0 out of 5 stars It delivers what it promises., December 6, 2007

By 

Alberto Gemin (London, UK) - See all my reviews
(REAL NAME)   

This review is from: MCITP SQL Server 2005 Database Administration All-in-One Exam Guide (Exams 70-431, 70-443, & 70-444) (Hardcover)

PREMISE: I am not yet over the obstacles (certification), I am just studying on this book, so I cannot say whether the book has helped me pass the exams or not.

HOWEVER, judging from other certifications I achieved and the relative study books, this one will work, because it seems pretty comprehensive and detailed.

It is a well-organized book, the pace is just right (and makes me think why one would want to read other books totaling 2000 pages or more to reach the same goal) and it gives tips and hints that I am sure will be valuable.

The plus is that you can read it to learn about SQL Server 2005. It gives you a very good overview, and you feel that you are spending your time learning something.

As a reference book it is quite superficial, i.e. it does not really expand much in any topic. This is fine though, if you are thinking of buying this book as a reference think again. That is not what is advertised.

Four out of five stars in my opinion is be the best rating for a certification study guide: you cannot really make a certification guide something "special", so this type of books hardly ever gets five stars.

However, there are two drawbacks that made me throttle back to three stars:

Firstly, some of the answers to the end-of-chapter questions are wrong. They are easy to spot though, typically they start with "Correct Answer: C" (wrong) then they go on explaining why B is the correct answer.

Secondly, the writing style is not exceedingly good. At the beginning it was just a little awkward to see the way some sentences are put together. Now that I am past the first half it is becoming somewhat annoying, and in some instances a little confusing.

I do not blame the author: I think he did a very good job (nobody expects a SQL Server expert to write beautiful English prose, and lots of it). However, another pass at editing could have made this book much more enjoyable.