MCDBA SQL Server 7 Test Yourself Practice Exams (Exams 70-028 & 70-029)

By Syngress Media Inc., Beth Young, Brian Wells, et al.

No Synopsis Available.

• Format: Paperback
• Language: English
• ISBN: 0072121815
• ISBN13: 9780072121810
• Release Date: December 1999
• Publisher: McGraw-Hill Osborne Media
• Length: 656 Pages
• Weight: 2.71 lbs.
• Dimensions: 9.3" x 1.8" x 7.5"

Customer Reviews

Useful if you understand its limits

The key to books like this one is understanding their limitations. The book does not claim to teach everything to pass the two exams it covers - it is simply a collection of practice questions and exams. And, to this end, it is a great book.For those with a strong understanding of the material (designing and implementing databases in SQL Server 7, and administering SQL Server 7), the book is excellent in giving you a feel for the topics to be covered in the final exam. It certainly helps you highlight areas of weakness which you need to address.In many ways, I like the style of the book, in that it does not really assist those trying to become paper MCDBAs (ie. with the certification, but without any practical knowledge), since it has a certain level of assumed knowledge.There are (in my opinion) some errors, but they seemed to be few and far between. Overall, a fine resource.

Absolutely recommendable

This book I bought as part of the MCDBA boxed set from Syngress, and it's the only one of the batch that's really worth your money.The questions in the book are very hard, and although the format is a bit different than in the real test, it's my personal opinion that these are harder than on the real test.Each question has elaborate answers telling you both why the correct answer is correct, and why the incorrect answers are incorrect. Here, I learned much about SQL Server that I didn't know before, so with this book, you not only test your knowledge; you also learn while you do it.More than one author has contributed to this book, and it's my impression that the section(s) on the design test are more thoroughly worked out than the ones on the administration test.My only real gripe with this book is that some questions (most in the administration section) seem to have erronous answers, but it's not many.This book will not teach you SQL Server, but if you know the product already, this book can help you prepare for the test(s).

Excellent

I thought that this books was wonderful, between this book and the transcenders I fell very prepared for these tests. However, I not only feel better prepared for the tests I genuinely learned a lot about SQL Server 7 that I did not know, especially about optimizing the database with indexes.