MCSA/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 System Administration, 70-228, Second Edition

MCAD/MCSD Self-Paced Training Kit: Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and Microsoft Visual C# .NET

MCSE Self-Paced Training Kit: Microsoft Windows Server 2003 Core Requirements, Exams 70-290, 70-291, 70-293, 70-294

Sql

MCAD/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 Database Design and Implementation, Exam 70-229, Second Edition

Format: Hardcover
Author: Microsoft Corporation
ReleaseDate: 14 May, 2003
Publisher: Microsoft Press
Rating:

Simply badly designed for exams
First of all, unlike most other certification books the exam goals are not together in one section. I believe that the writers made some bad choices when they first began to write this book. 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.
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. 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 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.
.

Book for SQL novice
If you are an Experience whom trying to get ready for the exam. This book is good for a person whom does not know any thing about SQL and Database Designing. then save your money and look for different one. This book will just wast your time. .