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

Thomas Moore (Author)

Book Description

Series: Exam Gear | Publication Date: March 13, 2002

The book is organized according to the exam objectives, including:introducing SQL Server 2000, database design, grouping and normalizing data, data access and modification, programming, views, constraints, defaults and triggers, stored procedures and UD functions, indexes, replication, and monitoring.

Editorial Reviews

From the Back Cover

Organized according to the actual exam objectives, our Training Guide series features pedagogy that provide readers with the most effective learning tools in the marketplace.

The book is organized according to the exam objectives, including:

* Introducing SQL Server 2000
* Database design
* Grouping and normalizing data
* Data access and modification
* Programming
* Views
* Constraints, defaults and triggers
* Stored Procedures and UD functions
* Indexes
* Replication
* Monitoring

The book also features several effective learning tools, including Exam Tips, Study Strategies, Step-by-Step Exercises, Case Studies, Summaries & Review Breaks, Review Questions, Exam Questions, Hands-On Exercises, and Fast Facts.

About the Author

Thomas Moore, MCSE, MCSE, MCDBA, MCT, CTT, has been in the computer industry for more than 20 years. Thomas has a wide variety of expertise in all hardware environments and with most Microsoft Server products. "My first and lasting love, besides my wife and family, however, is programming." Thomas is comfortable in any programming language environment, achieving his MCSD and MCDBA certifications from their 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. Thomas enjoys staying up-to-date, although like most of us, he finds it a challenge to keep up with the pace of the industry. Thomas's most recent certification achievements include being one of the first Windows 2000 MCSEs in the world and achieving the same standard as a SQL Server 2000 MCDBA.

Product Details

• Hardcover: 928 pages
• Publisher: New Riders Publishing (March 13, 2002)
• Language: English
• ISBN-10: 0735711291
• ISBN-13: 978-0735711297
• Product Dimensions: 9.2 x 8.3 x 2.5 inches
• Shipping Weight: 4.3 pounds
• Average Customer Review: 3.6 out of 5 stars  See all reviews (18 customer reviews)
• Amazon Best Sellers Rank: #3,785,082 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.