MCITP SQL Server 2005 Database Administration All-in-One Exam...

Features

• Cover Type: Hard Cover with 752 pages
• Published by: McGraw-Hill Osborne Media
• Edition: 1st Edition September 25, 2007
• Written in: English
• ISBN 10 Number: 0071496092
• ISBN 13 Number: 978-0071496094
• Book Dimensions: 9.3 x 7.7 x 1.8 inches
• Weighs: 3.3 pounds

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.

Reader Reviews
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.