MCSE: SQL Server 2000 Design Study Guide (Exam 70-229) [Hardcover]

Marc Israel (Author), J. Steven Jones (Author), Steve Jones (Author)

Book Description

ISBN-10: 0782129420 | ISBN-13: 978-0782129427 | Publication Date: August 20, 2001

Here's the book you need to prepare for Exam 70-229, Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition:

• In-depth coverage of every exam objective--all the information you need to know
• Practical information on designing and implementing a SQL Server 2000 database
• Hundreds of challenging review questions, in the book and on the CD
• Leading-edge exam preparation software, including a testing engine and electronic flashcards

Authoritative coverage of all exam objectives, including:

• Developing a logical data model
• Implementing the physical database
• Retrieving and modifying data
• Programming business logic
• Tuning and optimizing data access
• Designing a database security plan

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Editorial Reviews

From the Back Cover

Here’s the book you need to prepare for Exam 70-229, Designing andImplementing Databases with Microsoft SQL Server 2000 EnterpriseEdition:

• In-depth coverage of every exam objective--allthe information you need to know
• Practical information on designing andimplementing a SQL Server 2000 database
• Hundreds of challenging reviewquestions, in the book and on the CD
• Leading-edge exam preparation software,including a testing engine and electronic flashcards

Authoritativecoverage of all exam objectives, including:

• Developing alogical data model
• Implementing the physical database
• Retrieving andmodifying data
• Programming business logic
• Tuning and optimizing data access
• Designing a database security plan

About the Author

Marc Israel (MCSE, MCDBA and MCT) has over 10 years' experience working with SQL Server, currently as the General Manager with the Microsoft Recommended Support Point for the Indian Ocean region.

Steve Jones (MCSE) is a senior database architect with over 10 years SQL Server experience. He is a regular contributor and columnist for Swynk.com, a popular SQL Server Web site.

Product Details

• Hardcover: 704 pages
• Publisher: Sybex (August 20, 2001)
• Language: English
• ISBN-10: 0782129420
• ISBN-13: 978-0782129427
• Product Dimensions: 9.1 x 7.6 x 2 inches
• Shipping Weight: 3.2 pounds
• Average Customer Review: 3.8 out of 5 stars  See all reviews (19 customer reviews)
• Amazon Best Sellers Rank: #1,935,663 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

30 of 32 people found the following review helpful:

4.0 out of 5 stars 70-229 SQL 2000 Design, November 1, 2001

By 

James Ortiz (Gilbert, Arizona) - See all my reviews

This review is from: MCSE: SQL Server 2000 Design Study Guide (Exam 70-229) (Hardcover)

Good book, but certainly not the best book SYBEX has produced. I used SYBEX books for all 6 exams for MCSE WinNT, and passed all 6 the first time. Now I am pursuing MCDBA SQL 2000 certification. I used SYNGRESS to study for exam 70-228 "SQL Admin" and passed, however due to the unavailablility of a SYNGRESS book for 70-229 "SQL Design" I bought this SYBEX book AND FAILED THE EXAM.

The book lacks enough 'hands on' excersizes, particularly regarding using views, stored procedures, and user-defined functions. Also, as you read through the book you can 'feel' it was co-authored. Much of the book is somewhat hard to read, but the chapters on Accessing, Inserting, and Updating Data are very easy to read with many hands-on exercizes. The chapter reviews are pretty useless for actually 'reviewing' the material, as it really only lists the topics covered and provides very little summary information of what was actually covered in the chapter. SYNGRESS books provide an excellent "2 minute drill" at the end of each chapter to review the details, but this SYBEX book does not contain any such tool.

The SYNGESS/Osborne book for MCDBA exam 70-229 "SQL Design" is due out in November, and I would recommend considering the SYNGRESS book before this SYBEX book.

16 of 16 people found the following review helpful:

4.0 out of 5 stars A very useful book despite all the errors!, July 28, 2004

By 

Prerak Sanghvi "Prerak Sanghvi" (New York, NY) - See all my reviews
(REAL NAME)   

This review is from: MCSE: SQL Server 2000 Design Study Guide (Exam 70-229) (Hardcover)

Let me just get it out of the way by mentioning first that this book contains many errors - perhaps more than an average technical book. However, most are typographical and do not degrade the value of the book that much.

Having said that, the coverage of all the exam topics in this book is nothing short of superb! The explanations are detailed, clear and with numerous examples. For the purposes of the exam, I would go as far as to say that you may not need any other supplemental material (which is very rare for a study guide)!

This book covered all but 2 questions on my 70-229 exam. One of them was regarding the full syntax of OPENXML and the other was regarding Replication.

The questions at the end of the chapters are very similar to those on the test (again, rare for a study guide). If you can answer most of those questions correctly, you will do well on the real exam.

All in all, in my opinion, this is the best book out there for the 70-229 exam.

13 of 13 people found the following review helpful:

3.0 out of 5 stars Among many other certification books, this is the best, November 21, 2002

By 

Nomadic PC User "Chef" (Anaheim, CA) - See all my reviews

This review is from: MCSE: SQL Server 2000 Design Study Guide (Exam 70-229) (Hardcover)

I have used MOC (The first mistake), and MSPRESS (Another mistake), then QUE (I think this book needs serious revamp) only to find out all of them do not cover what you need to know for the exam, until I came across this book. It explains concepts for 70-229 very well. It has a lot of exercises that reinforce the concepts. I gave three stars because there are still many typos and review questions with wrong answers.