Customer Reviews

MCTS Self-Paced Training Kit (Exam 70-445): Microsoft SQL Server 2005

5 star:		(1)
4 star:		(5)
3 star:		(1)
2 star:		(0)
1 star:		(2)

 

 

The book is good source for starting up in BI SQL Server but perhaps not enough to pass exam. I gave exam last week after only preparing this book , didn't pass .. the questions were so different from the one given with book practice test and also advanced knowledge was required . I think its good idea to use one of the practice test i.e SelfTest etc and learn online whats left off.

This book has not been properly edited to ensure that all instructions are correct. The book consistently references the wrong items (db names) or asks the reader to perform a step that can't be completed because an item does not exist. EXAMPLE: pg 303, Ex.1 Step 7. There is no 'subcategory' field in the 'dscategory' dataset. I think this error is becauase pg 294, steps 12 & 16 have the names reversed. These authors stink.

I just passed the 70-431 exam. I took a class and we used the Mircosoft Tool Kit book. It was a self paced course so there wasn't classroom lectures. The book was great ! I passed the exam on the first try. Which prompted me to go it alone and purchase this book 70-445. I found the text easy to understand and could follow the examples and practices very easily. The questions in the toolkit are directly related to the actual exam questions that you will sit for.

I have attended the intructor led MS trainings.

Because you dictate your own pace, reading the book and diligently going thru the exercises is as good as,if not better than, attending the corresponding the MS intructor led trainings.

Do not expect to pass the exam with this training kit. I read each chapter, completed all exercises, and repeated all simulation tests several times. The questions on the real exam are MUCH harder. I was extremely disturbed to fail because of this kit. And yes, there are quite a few of instructional typo errors that will have you going in circles.

Very good training kit. One minus -- there are just a few Quick Check questions and answers at the end of each chapter. It would be better to have say 20 questions per each chapter for evaluation.

Very good introduction in MS SQL Server 2005 BI. Although indeed sometimes errors in the textual instructions, the delivered projects on CD are correct and clear. Clear theoretical explanations. Textual errors are also easy to pass by with a little effort and a bit 'trial-and-error' yourself. Also valuable T-SQL examples worked out in the lessons.
This books combines the three BI-areas of interest (SSRS, SSAS, and SSIS) in one book and is aiming at the preparation for the 70-445 exam. Attractive book and lay-outs conventions. It really invites you to read.

This book helped me prep for the 70-445 exam, I am still reading this one. I recommend Transcender Practice exams with this book.

GREAT REFERENCE GUIDE FOR THE SQL SERVER 2005 (EXAM 70-445). I WOULD HIGHLY RECOMMEND GAINING KNOWLEDGE ON THE BACKROUND OF THE SYSTEMS USED IN THIS STUDY GUIDE. EXTREMELY DETAILED AND CORRECT IN EVERY ASPECT THAT I'VE SEEN SO FAR.