MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation (2nd Edition) [Paperback]

Thomas Moore (Author), Ed Tittel (Author)

Book Description

ISBN-10: 0789729970 | ISBN-13: 978-0789729972 | Publication Date: April 6, 2003 | Edition: 2

MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation is the perfect study guide to help you pass the 70-229 exam, which is an elective for the MCSD, MCAD, MCDBA, and MCSE programs. If you are preparing for this exam, you'll find our Training Guide to be the most effective self-study tool in the market! This book is your one-stop shop because of its teaching methodology, the accompanying PrepLogic testing software, and superior Web site support at www.examcram.com. The book follows the exam objectives and features numerous exercises to give you hands-on opportunities, exam tips that give you advice for test day, and warnings that alert you to possible mistakes. The Fast Facts section condenses the most important information for last-minute review, and the practice exam is representative of the actual exam.

Each book in the Training Guide series is published under the direction of Series Editor Ed Tittel, the leading authority on IT certification. This book has been subjected to rigorous technical review by a team of industry experts, ensuring content is superior in both coverage and technical accuracy, and has earned the distinction of Cramsession¿ Approved Study Material.

The CD features PrepLogic¿ Practice Tests, Preview Edition. This product includes one complete PrepLogic Practice Test with approximately the same number of questions found on the actual vendor exam. Each question contains full, detailed explanations of the correct and incorrect answers. The engine offers two study modes, Practice Test and Flash Review, full exam customization, and a detailed score report.

Editorial Reviews

From the Back Cover

MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation is the perfect study guide to help you pass the 70-229 exam, which is an elective for the MCSD, MCAD, MCDBA, and MCSE programs. If you are preparing for this exam, you'll find our Training Guide to be the most effective self-study tool in the market! This book is your one-stop shop because of its teaching methodology, the accompanying PrepLogic testing software, and superior Web site support at www.examcram.com. The book follows the exam objectives and features numerous exercises to give you hands-on opportunities, exam tips that give you advice for test day, and warnings that alert you to possible mistakes. The Fast Facts section condenses the most important information for last-minute review, and the practice exam is representative of the actual exam.

Each book in the Training Guide series is published under the direction of Series Editor Ed Tittel, the leading authority on IT certification. This book has been subjected to rigorous technical review by a team of industry experts, ensuring content is superior in both coverage and technical accuracy, and has earned the distinction of Cramsession¿ Approved Study Material.

The CD features PrepLogic¿ Practice Tests, Preview Edition. This product includes one complete PrepLogic Practice Test with approximately the same number of questions found on the actual vendor exam. Each question contains full, detailed explanations of the correct and incorrect answers. The engine offers two study modes, Practice Test and Flash Review, full exam customization, and a detailed score report.

About the Author

Thomas Moore (MCSD, MCDBA, MCSE, MCT, CTT) has been in the computer industry for more than 20 years. He has had his MCDBA certification from its inception. Over the past 12 years he has been working for a variety of Microsoft partners and currently is a Systems Analyst for TechServices Web Development Group in Fort Wayne, Indiana where he has been for the past three years.

Series Editor Ed Tittel runs LANWrights, Inc., a training and writing firm that specializes in networking, computer security, and markup languages. Ed has contributed to more than 100 books on computing.

Product Details

• Paperback: 928 pages
• Publisher: Que; 2 edition (April 6, 2003)
• Language: English
• ISBN-10: 0789729970
• ISBN-13: 978-0789729972
• Product Dimensions: 9.2 x 8 x 2 inches
• Shipping Weight: 3.8 pounds (View shipping rates and policies)
• Average Customer Review: 3.6 out of 5 stars  See all reviews (18 customer reviews)
• Amazon Best Sellers Rank: #1,882,976 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

25 of 27 people found the following review helpful:

3.0 out of 5 stars Could be Better, March 16, 2003

By 

vbguy "vbguy1" (Springfield, VA United States) - See all my reviews

This review is from: MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation (Hardcover)

This book has a lot of good content. I felt the explanations of the different subject areas were well-written, thorough, and very helpful. Succeeding on the exam is a matter of being able to think through the problems presented to you - not just memorizing isolated facts. This book can help you gain the kind of understanding you need to take the exam.

I feel the book is weak in terms of focus on the exam itself and the sample tests, etc. Many of the exam questions were very poorly worded. They don't give you enough information to make a really good decision. In some cases they were just plain wrong. (Fortunatly, I didn't find that to be the case with the real exam.) One really dissapointing thing is the way the big practice test at the end nearly repeats a lot of the individual chapter test questions.

So, the information in the book is good but somebody who really knows testing methods needs to rework it.

Also, I think the book emphasizes areas (e.g. replication, full-text search) that aren't stressed very much on the exam. Conversely, it seemed not to cover other areas (security and performance monitoring) very adequately.

This book needs to be proofread thoroughly and corrected.

The CD only contains a softcopy of the book itself plus some kind of sample test. (Since the sample test in the book were so poor, I didn't waste any time installing and taking the test from the CD.) A very useful addition would be a CD containing enough data to build a reasonably large database. This could be used to give practice in creating, loading, and then running performance tests, etc. "Northwind" and "Pubs" just aren't big enough to do this.

16 of 16 people found the following review helpful:

4.0 out of 5 stars Past the Test!, October 9, 2002

By 

Robert Lewis - See all my reviews

This review is from: MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation (Hardcover)

Not bad! Has a good study outline and organisation with all required objectives of the test. Pretty good detailed examples in chapters, Review exercies a little weak, but review questions are good. Using this book, the Books On Line from the product and all the 70-299 example tests i could find on line, I past 70-229 test comfortably....

12 of 12 people found the following review helpful:

2.0 out of 5 stars Not Que's best effort, September 10, 2004

By 

abcd - See all my reviews

This review is from: MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation (2nd Edition) (Paperback)

In the past, I used the QUE books by Kalani and the Transcender practice tests to gain my MCAD. I bought this book to help prepare for my next test (70-229) on the MCSD track, and I have been disappointed.

I come from a programming background, not a SQL Server Admin background. This book is light on the kind of detail that Microsoft tests for in their exams. I am extremely displeased with the sections on replication, SQL Server Profiler, database security and performance tuning.

Other sections such as the writing queries and stored procedure I found to be OK. But then again, most of my Sql Server experience has been in writing queries and stored procedures.

Maybe this would be a good study guide for experienced SQL Admins. I can't answer that question. I do feel that us programmers would be better served by not using this book as a preparation guide.