R. R. Jacobsen said
This book is a wonderful comprehensive review of the key components used for SQL Server 2008 certification (exam 70-448). It covers SSIS, SSAS and SSRS in such a manner as to provide great background alongside some basic hands-on exercises to perform.
There is a practice exam disc included with the book which really helps in terms of studying for the exam and another disc with an evaluation copy of SQL Server 2008. All of this can take you from doing what I would call "cowboy SQL work" to a more professional, well founded, and optimized approach towards working with BI tools used with SQL Server.
The authors provide some good practical real-life recommendations on how to apply some of the techniques covered which helps round out the training. Collectively, this text has opened my eyes to more features and functionality in SQL than I did before picking it up and offers a way to actually apply the learning material -- albeit at a simple, high level. Just the same, one can always go deeper and experiment with some of the techniques. In the first chapter alone I learned of a technique that solved a problem which that a consulting firm I worked with had an allergic reaction towards solving. I'm thinking this consulting firm might have benefited from this book.
I'm grateful that a careful reading of the exercises does allow one to complete the exercises and not have to deal with a problem so often faced in similar type texts -- nobody proof-read the thing to make sure the commands were accurate and actually worked! Seems like a pretty basic concept but this is so often not the case.
My only warning to readers is that initial installation of the SQL Server evaluation software and setting up the DB's used as examples can prove tricky (but this is a MSFT issue, not one with the book or the way in which the conveys information). Why is it that sample DB's and installation of same cannot be made easier as it was with SQL 2005 early on?
Finally, in the back of the book is a coupon code for taking the exam -- practically worth the price of the book. Your biggest investment will be the time necessary to study for the exam but in today's economy that would be a great investment to make.
Anwarul Kabir Khan said
Effective though I didn't appear exam so far. Covered a lot of topics effective for exam. But to do professional work I believe books for SSIS, SSAS and SSAS data mining are necessary individually. Data mining(Chapter 9) contents are too brief to understand. Best practice and Exam tips are really helpful. Also real life case examples are helpful. As a novice this is a good book to study.
Book includes 200 sample questions and SQL server 2008 E/E CD for 180 days trial.
Comments