MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation
| 2002-03-13 00:00:00 | | 0 | Microsoft Certification
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.
User review
rich99man
The book covers the practical training side of this rather broad topic quite well. Having no business experience in this area, I was looking for a vehicle to get this SQL Server thing down for my own use and as preparation for certification. I found the explanations of the subject areas were well-written, thorough, and helpful. Other sources such as Books Online and some of the more reference oriented texts are quite valuable supplements.
Having taken certification exams in the past, it was clear that the task of exam preparation is a separate animal and overpromised here. There is the ExamCram2 series that picks through this material and goes a long way to addressing that objective. Having certified with this pair, maybe there is a new job somewhere.
The book could use a reedit, but overall it is quite coherent.
User review
MCDBA, MCSE, MCSD, MCAD Training Guide
The book met the requirements of the course it was being used for,,. it was how ever a little bit lax on the code portion,,.when it came to doing the project it left a bit to be desired in clarity of how to build a data base in SQL,,.
User review
Horrible!!
Why can't authors ever flow through a book in an ordely manner? What is the point of jumping from chapter to chapter? For example, many times through out this book references are being made to up coming chapters about specific topics in chapters that don't belong there. Why do you tell the reader about an up coming topic in a chapter that doesn't belong there and then ask a question about it in the chapter test. Why even make a chapter about that specific topic if your going to include it in a chapter that doesn't belong there? Thats a little redundent!! Also the author likes to give you examples on how to do certain things the right way, and then tests you on something he never covered in the chapter. If the topic has nothing to do with the chapter, do not include in the chapter. If you do include it into a chapter in which it doesn' belong, don't include it into the chapter test. How do you expect the reader to completely understand and answer the question if he or she knows nothing about it? Unless, your wanting the reader to stop what there doing, flip to the chapter and read it, then go back to the previous chapter your testing on just for that one little question that doesn't belong. Rediculous!!
User review
Good, but not as dead on as others in the series
I just passed the 70-229 exam this morning with an 862. My study strategy involved reading this book cover to cover over a 2 week period and taking some uCertify practice exams.
While I have absolutely LOVED the other books for the MCAD (by Amit Kalani) I feel this book was not nearly as effective. It had a lot of focus on items that the exam didn't touch (and neither did the 4 practice exams I took) and it actually didn't touch on some items that were on the exam.
I would, however, still recommend the book. It was easy to read and had good flow and descriptions; it is an excellent base to add to with exams or other cram style books. I would say that this book got me to 60% and the practice exams got me the remaining 26% of my score.
User review
great book
not only it prepared me for the exam, but also gave me quite insight in practical enviornment.