MCAD/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server(TM) 2000 Database Design and Implementation, Exam 70-229, Second Edition (Pro-Certification) | 
 enlarge | Author: Microsoft Corporation
Brand: MSOFT
Category: Book
List Price: $59.99
Buy New: $4.42
You Save: $55.57 (93%)
New (35) Used (33) from $1.17
Avg. Customer Rating:  19 reviews
Sales Rank: 225759
Media: Hardcover
Edition: 2nd
Autographed: No
Memorabilia: No
Number Of Items: 1
Pages: 880
Shipping Weight (lbs): 3.2
Dimensions (in): 9 x 7.2 x 1.4
MPN: 0-7356-1960-3
ISBN: 0735619603
Dewey Decimal Number: 005.7585
UPC: 790145196033
EAN: 9780735619609
ASIN: 0735619603
Publication Date: June 4, 2003
Availability: Usually ships in 1-2 business days
Shipping: International shipping available
Condition: New slight shelf wear
|
| Also Available In:
|
| Similar Items:
| • | MCSA/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server(TM) 2000 System Administration, Exam 70-228, Second Edition (Pro-Certification) | | • | MCAD/MCSD Self-Paced Training Kit: Microsoft (2nd Edition) .NET Core Requirements, Exams 70-305, 70-315, 70-306, 70-316, 70-310, 70-320, and 70-300 box vol. set | | • | MCAD/MCSD Self-Paced Training Kit: Developing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual C# .NET, Second Edition (Pro-Certification) | | • | MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification) | | • | MCAD/MCSD Self-Paced Training Kit: Developing Windows-Based Applications with Microsoft Visual Basic .NET and Microsoft Visual C# .NET, Second Ed (Pro-Certification) |
|
| Editorial Reviews:
Product Description
PRESS SQL SRV 2000 DB DES IMP 70229 2ED
|
| Customer Reviews: Read 14 more reviews...
 Good training book September 28, 2008
I am in a SQL Database Implementation and Design class right now, and the lessons provided in the book do a good job at instilliong SQL code into your mind.
Exam 70-229 November 12, 2007
Fairly good book with some problems in repetitive text. Do NOT count on this book as your only resource for the 70-229 exam. Then again, it's foolish to expect to pay $40 to pass this very difficult exam. I passed the exam but used a test engine endorsed by Microsoft.
Bottom line: Outstanding value @ $40. Four stars because of the repetitive text, otherwise I would give it five.
Works for getting the basics and cert prep June 9, 2007
Not being interested in certification, I was looking for something that would get me the basics, and tell me where to go to get the meat. This book is doing that. Includes a MS SQL Server 2000 120 day use installation disk. The install includes the "Books On Line" (a source of a lot of meat).
Not caring if this is good for cert test prep, and having never taken a cert test, I can't tell you if it is a good prep. It hase provided a good portion of the information I was looking for, and helped me understand the changes / inhancements in MS SQL 2005.
4 stars because I am seldom overwhelmed with something.
 Simply badly designed for exams May 22, 2006
5 out of 6 found this review helpful
I believe that the writers made some bad choices when they first began to write this book. First of all, unlike most other certification books the exam goals are not together in one section. Instead there are whole chapters for queries, indexes, views, etc with all of the information about each topic in that chapter. So if you wanted to read about 'query optimization' you would have to read the sections within that chapter about query optimation from the queries chapter, from the index chapter, some from the views chapter, etc. So if you want to review a specific topic that you are not as good at you will be doing a lot of page flipping.
Second the book is too thick. It contains a lot of information that i doudt that you will actually get on the exam (like estimating the size of a table). It also has about a 100-150 page objective by objective index at the back with questions. But these sections seem to be fragmented from the rest of the book and do not have enough information to truely learn the objective. The first part of the book seems to be written as an introduction to databases book rather then a certification book, and i dont think that i would use this book to introduce myself to databases anyway.
Third: the practice certification exam does not work. The practice exam is an exam that seems to have an embeded internet explorer and is ran by javascript. I have no clue why you would use javascript to create a practice exam. Anyway i get the 'error running these scripts, would you like to continue running scripts on this page error' and i am unable to run the exam. I am using windows xp service pack 2 internet explorer 6.1.
I personally went out and bought the exam cram for 229 and it seems to be much better.
This Won't Prepare You For 70-229 But a Good Starting Point. May 17, 2005
15 out of 15 found this review helpful
This book is a very easy read, explains concepts clearly, but lacks the kind of detail necessary for passing the 70-229 exam, especially if you are taking this as an elective on the developer track. It will get you through most of what you need to know at 10,000 feet, but it will not take you to a passing score. It taught me things I had never used and for that it is well worth the time investment. I also love the fact that you can install the "e-book" on a laptop and a desktop at home and never carry the hard cover book around.
I had been using SQL Server 2000 for years and thought this would be a snap for me. After reading this book I thought I was ready for the test. On the practice exam I saw words that were used that I had no idea what the context was. Those functions are not discussed in this book but you can trust they will be covered completely on the test! You will thoroughly need to know things like triggers, functions and constraints, and all their possible parameters, or you will not be prepared for the exam.
After going through the book you will be ready for the material that is available at the practice test vendors Microsoft recommends at the Microsoft Web sites for MCAD & MCSD Certification. I am not trying to promote any company and I have nothing to gain by saying the following: The study guide I purchased for about the cost of this book prepared me for the exam. This book prepared me for the study guide.
|
|
|
