MCTS SQL Server 2005 Implementation & Maintenance Study Guide (Exam 70-431) (ISBN 0072263210) Book Reviews 1-9 Sorted By Most Recent, at VeryWellSaid.com

Great book, poor practice tests.

I just passed this test at Microsoft TechEd on my first attempt. The book is well organized and covers all the basics of the exam. My test included 47 questions,35 multiple choice and 12 simulations. The practice exams that are included with the book are horrendous and will not prepare you for the test. Do not rely on them. The book will give you all the basics but you will need to know how to apply them to real world examples. It's not enough to know about snapshots and replication, you'll need to know how to implement them in the most effective Microsoft way. I do recommend this book because it will help prepare you for the test but it's not enough on it's own to pass the test. Good luck.

(Review Data Last Updated: 2008-09-06 04:37:20 EST)

05-14-08

(NA)

It worked for me

This is my first Microsoft certification so I wasn't 100% sure how to approach preparing for it. My knee-jerk reaction was to buy a book and do all of my learning from just the book. I found myself reading at night and then during the day (while working) I would try and apply what I had read the previous night to what I was working on that day. Without realizing it I was really just using the book to guide my hands-on learning.

Having said that, the book did a very good job of introducing the exam topics, making note of important topics (HINT: This will probably be on the test), and chapter review questions. I felt the review questions were fairly similar in style to the 70-431 multiple choice question. The practice test's simulation questions are a little buggy, I don't think I could ever answer any of them, but it wasn't that big of deal since I use SSMS everyday. I thought the web content was pretty good, videos, and the second practice test but it is very difficult to navigate to the material. I almost gave up looking for it but somehow I did find it.

I beleive that you could pass the test just by using this book (or any other book) but I think that you should really do the majority of your learning with hands on experience. I do reccomend this book to aid your studying, it worked for me.

(Review Data Last Updated: 2008-06-11 04:41:17 EST)

04-14-08

(NA)

Just passed the exam

I used this book as my main study guide for 70-431. In general, this book provided the understanding needed for the test. I also found the videos to be helpful. My only criticisms are
1)The actual test is considerably more difficult than the practice exam that comes with this book. I took the pratice exam in 30 minutes while the real test took 2 hours.
2)The topic of db backups (through SQL and SSMS) seems to carry more weight on the test than in the book, so be prepared.

As a side note, the technical editor of this book (Darril Gibson) wrote a All-In-One study guide for several SQL exams. It's an excellent book and I used it as a side reference while studying. If you plan to take all three tests, you may want to save your money and just buy the Gibson book.

(Review Data Last Updated: 2008-05-19 04:35:52 EST)

02-06-08

3\4

The way to pass the exam

This book was an invaluable resource. I took the official training recommended by Microsoft (Both classes and an E-Learning course). However, if I had taken the exam with only those I surely would have failed. The Microsoft curriculum was presented in a confusing and stale way that failed to demonstrate how the many "features" of SQL could or should be used in the real world. Carpenter's book provided insight that let me know how a feature worked, and what it was supposed to accomplish. Truly a great resource for the exam (which I passed first try), and also for real world application.

My only criticism of the book is that the editor did a very poor job. There were grammatical and spelling mistakes throughout the book. It appears the editor didn't even run a spell check. Mostly these errors were not a problem, however, at least one practice question and answer directly violated the text and a couple of code examples would never have run. While the CD was helpful (the certcam videos were nice), the E-book was incomplete. It did not have the appendixes - and the table appendix would have been nice to print.

Overall a great book that anyone planning on earning this certification should read. The exam is not easy, but with the help of this book you should pass.

(Review Data Last Updated: 2008-04-15 04:51:12 EST)

01-22-08

1\1

Even better than Microsoft's book

Impressive and exciting. This book is perfectly arranged, documented and skilfully done. I don't usually rate the items five stars.

(Review Data Last Updated: 2008-02-07 04:03:11 EST)

11-02-07

(NA)

Excellent Book

Great book, it entails inside details for advanced DBA's and yet covers the basics for those just getting started with SQLServer. This book is well organized for quick reference, along with examples for certification that will benefit daily use, extending into professional development. You will learn more than DB skills, reading and following his examples. I recommend SQLServer 2005 Implementation and Maintenance Study Guide for all IT enthuses.

(Review Data Last Updated: 2008-01-23 02:05:41 EST)

09-03-07

1\1

EXCELLENT Prep

It's nice to have a prep book that is not only easy to follow, but actually prepares you for the test. I found Tom's book very staightforward, and it's very accessable as a reference book as well. If you're planning on taking the certification test for SQL 2005, you can't go wrong with this book. It also helped prep me for teaching SQL in my workshops across the country. The book is one of the resources I carry on the road with me.

(Review Data Last Updated: 2007-11-03 08:23:00 EST)

08-31-07

1\1

More than an exam prep book

The thing I liked most about this book was the fact that I can acutally use it after the test. I have the Microsoft Press book that is also intended as a prep tool for the 70-431 exam, but it will be useless to me as a reference. This book has such a good chapter on SQL and excellent "real-world" type coverage in the other chapters that will allow me to use it as an ongoing reference.

Having used the other book (the one from Microsoft Press) and this one, I can tell you that this book gives you all the information of the Microsoft Press book and then some. I'm glad I used both books in my preparation, but this book is definitely the one that will stay on my shelf.

(Review Data Last Updated: 2007-09-04 22:51:56 EST)

08-08-07

1\1

Excellent Training tool