MCSE: SQL Server 2000 Design Study Guide: Exam 70-229 and over 2 million other books are available for Amazon Kindle . Learn more

Buy New

or
Sign in to turn on 1-Click ordering.
Buy Used
Used - Good See details
Price: 1.79

or
 
   
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Colour:
Image not available

 
Start reading MCSE: SQL Server 2000 Design Study Guide: Exam 70-229 on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

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

Marc Israel , J. Steven Jones
5.0 out of 5 stars  See all reviews (2 customer reviews)
RRP: 36.99
Price: 33.60 & FREE Delivery in the UK. Details
You Save: 3.39 (9%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Usually dispatched within 10 to 13 days.
Dispatched from and sold by Amazon. Gift-wrap available.

Formats

Amazon Price New from Used from
Kindle Edition 31.92  
Hardcover 33.60  

Book Description

5 Sep 2001 0782129420 978-0782129427 Har/Cdr
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.


Product details

  • Hardcover: 832 pages
  • Publisher: John Wiley & Sons; Har/Cdr edition (5 Sep 2001)
  • Language: English
  • ISBN-10: 0782129420
  • ISBN-13: 978-0782129427
  • Product Dimensions: 23 x 19.4 x 5.2 cm
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (2 customer reviews)
  • Amazon Bestsellers Rank: 2,193,186 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Authors

Discover books, learn about writers, and more.

Product Description

From the Back Cover

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

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.


Inside This Book (Learn More)
First Sentence
For many users, database design is a total mystery. Read the first page
Explore More
Concordance
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Customer Reviews

4 star
0
3 star
0
2 star
0
1 star
0
5.0 out of 5 stars
5.0 out of 5 stars
Most Helpful Customer Reviews
24 of 25 people found the following review helpful
5.0 out of 5 stars Useful and helpful 24 Nov 2001
By A Customer
Format:Hardcover
If you are about to take 70-229 exam, this book will DEFINITELY help you. Solid volume of the book includes almost every feature of MS SQL 2000. So it starts with basics of database design and smothly leads you to more advanced features of SQL (as a language and standard) and SQL server (as a database server). Therefore I would suggest to use it even them who just started studying of SQL and database design. Every chapter includes review questions, which could be helpful to memorise general ideas (but not for me in particular). "Real world scenarios" are just brilliant. I suggest to use them as a first-stage preparation for exam questions. Test exam which comes with a book on CD is helpful addon for other testing software, but no more. So it's definitely worthwhile to get additional testing software.
Book contains a lot of examples for every tiny feature. It might be a positive as well as a negative for some of you. I skipped many of them, however this information could be used in your daily work as a reference.
Unfortunatelly, there is a lack of information about XML in the book. (Possibly this is the only significant "minus"). Book helps you to answer XML-related exam questions, but no more.

So summarising everything, this book and testing software will give you a success on your test.
Comment | 
Was this review helpful to you?
5.0 out of 5 stars Best Certification Book I've Used 31 Oct 2005
Format:Hardcover
After using Microsoft official texts to achieve MCAD .NET I found this book a breath of fresh air.
I found it very easy to read with concise examples and no needless rambling. Each chapter ends with a summary, exam essentials and a set of questions to check you understood everything. The book covers everything you need for the exam with one small exception, an overview of Database Replication.
I will now be looking to Sybex first for all my certification needs in the future.
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 3.8 out of 5 stars  19 reviews
30 of 32 people found the following review helpful
4.0 out of 5 stars 70-229 SQL 2000 Design 1 Nov 2001
By SkinnyBytes - Published on Amazon.com
Format:Hardcover|Verified Purchase
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! 28 July 2004
By Prerak Sanghvi - Published on Amazon.com
Format: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
4.0 out of 5 stars Good Book and Study Guide -- 4.5 Stars 7 Mar 2002
By King Leung - Published on Amazon.com
Format:Hardcover
This is a good book which has comprehensive coervage of most of the exam objectives and also important concepts not required by the exam, like extent, page and physical storage of records. There is one chapter devoted to index storage, statistics and fragmentation with some under the hood information. I passed the exam the second time but I don't blame it on the book. Most of the exam questions are case-scenario based and no book will ever cover every possible case. Understanding business logic and creating logical models is a matter of experience and common sense rather than mouth-fed knowledge from books. This book does have its drawbacks. The book must be hastily published and there are numerous mistakes. The proof-reading job was donely poorly. One should go to Sybex's web site to find the correction to these errors. The CD includes two bonus exams in addition to those already in the book. The layout of the options in a question is the worst I have seen. When the options are long, each option is contained in a two line scrollable box. It is impossible to compare one option from the next.
The parts that are not adquately covered include Index Tuning Wizard and using SQL Profiler to create traces, the latter is tested in greater depth in 70-228. On the whole this is a great book for anyone who wants to learn SQL Server 2000 and is recommended as the principal material for the exam. I would give it 4 and a half stars.
13 of 13 people found the following review helpful
3.0 out of 5 stars Among many other certification books, this is the best 21 Nov 2002
By Nomadic PC User - Published on Amazon.com
Format: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.
12 of 12 people found the following review helpful
4.0 out of 5 stars Good book, but not very relevant to the exam. 6 Jan 2002
By J. Brian DeRosa - Published on Amazon.com
Format:Hardcover|Verified Purchase
This is an excellent book written at the "professional beginner" level discussing issues of database design and planning with SQL server 2000. Excellent design and configuration tips, Good explanations of difficult concepts, however, the practice tests are somewhat lacking, and while it covers all of the relevant material, the book fails somewhat as a study aid specifically for the 70-229 exam, where many other Sybex books excel. The book is well worth the money as a useful tool for a relatively new SQL 2000 DBA, however, don't rely on it too heavily for the test.
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Look for similar items by category


Feedback