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

by Darril Gibson (Author)

Editorial Reviews

Product 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.

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

• Format: Kindle Edition
• File Size: 18360 KB
• Print Length: 752 pages
• Simultaneous Device Usage: Up to 4 simultaneous devices, per publisher limits
• Publisher: McGraw-Hill Osborne Media; 1 edition (September 25, 2007)
• Sold by: Amazon Digital Services
• Language: English
• ASIN: B0012D1D1E
• Average Customer Review: 4.4 out of 5 stars See all reviews (8 customer reviews)
• Amazon.com Sales Rank: #178,897 in Kindle Store (See Bestsellers in Kindle Store)

  Popular in this category: (What's this?)

  #79 in

  Books > Computers & Internet > Certification Central > MS SQL Server

Customer Reviews

Most Helpful Customer Reviews

5 of 6 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.

2 of 2 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.

2 of 2 people found the following review helpful:

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

By	Alberto Gemin (New York City, USA) - 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.