MCDBA SQL Server 2000 Database Design Study Guide (Exam 70-229) [With CDROM]

By: Bane, Jeffery

No Synopsis Available.

• Format: Hardcover
• Language: English
• ISBN: 0072126949
• ISBN13: 9780072126945
• Release Date: October 2001
• Publisher: McGraw-Hill/Osborne Media
• Length: 608 Pages
• Weight: 2.94 lbs.
• Dimensions: 1.8" x 8.0" x 9.5"

Customer Reviews

Quite good from novice perspective

This book is a great primer for the Exam and SQL Server development in general. While you obviously need to live, eat, and sleep Books On Line to pass the exam, this was a great place to start. I found the chapter on T-SQL to be one of the better ones I've ever read, and I still refer to it often. While no book gives you the test answers (try brain dumps if you want that), I find this a great book.

A fairly good book for MCDBA and MCSD Preparation

I recently passed 70-229 exam. I used this book as my preparation guide though I frequently referred to SQL Server Books Online. The book is easy to read and explains the topics well. The review questions at the end of chapters are quite good to test your understanding of the materials. However, expect much tougher scenario based questions in exams. I found the book somewhat lacking in depth in the coverage of replication, the use of query analyzer tools, and transaction and locking issues. So, you may want to turn to Books Online to help you out there...

Not for the uninitiated

I found this an excellent reference, but not a "SQL for Idiots" guide that I think many IT new-comers are looking for. Having a working grasp of relational database systems is required. This book helped me prepare for the obscurities of the MCDBA test that I would not normally run across in the real world. One thing that I did notice is the drastically differentstyles of the chapters, it was clear that it was a group collaboration with some gifted writers and some not (The style of chapter 2 should have persisted throughout the book, it would have been much more enjoyable!)Overall, It was highly informative and has been a great reference so I have nothing but positive things to say, but for those who expect to pass after reading it... A book isn't an alternative to experience.

Hefty but Excellent.

What struck me most about this book was the completeness of the material. While it was an excellent prep for the exam (passed!) it also goes beyond that and actually teaches practical information. So if you're an aspiring paper MCDBA or paper MCSE looking for a quick read that will tell you only the exam answers, this isn't the book. Database design is a complicated topic and this book is an excellent, albeit lengthy, read.