Vous voulez voir cette page en français ? Cliquez ici.

Sign in to turn on 1-Click ordering.
Amazon Prime Free Trial required. Sign up when you check out. Learn More
More Buying Choices
Have one to sell? Sell yours here
Tell the Publisher!
I'd like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

MCTS Self-Paced Training Kit (Exam 70-445): Microsoft® SQL Server(TM) 2005 Business Intelligence - Implementation and Maintenance: Microsoft SQL Server 2005 Business Intelligence--Implementation and Maintenance [Paperback]

Erik Veerman , Solid Quality Learning , Teo Lachev , Dejan Sarka , Javier Loria
2.0 out of 5 stars  See all reviews (1 customer review)
List Price: CDN$ 74.99
Price: CDN$ 47.24 & FREE Shipping. Details
You Save: CDN$ 27.75 (37%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 1 left in stock (more on the way).
Ships from and sold by Amazon.ca. Gift-wrap available.
Want it delivered Friday, August 29? Choose One-Day Shipping at checkout.


Amazon Price New from Used from
Paperback, Bargain Price CDN $30.00  
Paperback, Sept. 15 2007 CDN $47.24  
Save Up to 90% on Textbooks
Hit the books in Amazon.ca's Textbook Store and save up to 90% on used textbooks and 35% on new textbooks. Learn more.
Join Amazon Student in Canada

Book Description

Sept. 15 2007 0735623414 978-0735623415 1


Ace your preparation for the skills measured by MCTS Exam 70-445—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce what you’ve learned by applying your knowledge to real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time.

Maximize your performance on the exam by learning to:

  • Install, configure, and manage SQL Server business intelligence components and tools
  • Implement SQL Server Analysis Services cubes, create KPIs, work with MDX
  • Build data mining models and configure algorithms
  • Administer SQL Server Reporting Services and deploy information-rich solutions
  • Develop and troubleshoot SQL Server Integration Services packages
  • Implement package roles, protection levels, and passwords


Assess your skills with practice tests on CD. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs. You get detailed explanations for right and wrong answers—including a customized learning path that describes how and where to focus your studies.

Your training kit includes:

  • 15% exam discount from Microsoft. (Limited time offer). Details inside.
  • Official self-paced study guide.
  • Practice tests with multiple, customizable testing options and a learning plan based on your results.
  • 200+ practice and review questions.
  • Case scenarios, practice exercises, and best practices.
  • 180-day evaluation version of Microsoft SQL Server 2005 Enterprise Edition.
  • Fully searchable eBook of this guide.

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.

Product Details

Product Description

About the Author

Erik Veerman is a Microsoft® MVP for SQL Server®, an award-winning BI solution developer, and a popular speaker, instructor, and author. He shares his expertise with OLAP design, ETL processing, and dimensional modeling as a mentor for Solid Quality Mentors.

Teo Lachev has more than a decade of experience in designing and developing Microsoft®-centered solutions. He is technical architect for a leading financial institution where he designs and implements Business Intelligence applications for the banking industry. Teo is a Microsoft Most Valuable Professional (MVP) for SQL Server®, Microsoft Certified Solution Developer (MCSD), and Microsoft Certified Trainer (MCT). He lives with his family in Atlanta, GA.

Dejan Sarka is a mentor with SolidQ and focuses on development of database and business intelligence applications. He is a frequent speaker at international conferences such as TechEd, SqlDevCon, and PASS. He is the founder of the Slovenian SQL Server and .NET Users Group. As main author or coauthor, Dejan has written nine books about SQL Server. He has also developed three courses for SolidQ: Data Modeling Essentials, Data Quality and Master Data Management, and Data Mining.

Javier Loria is a SQL Server expert who works at Solid Quality Mentors where he combines deep technical expertise and real-world implementation experience to provide advanced solutions and training for the Microsoft SQL Server database platform.

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index
Search inside this book:

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

Customer Reviews

5 star
4 star
3 star
1 star
2.0 out of 5 stars
2.0 out of 5 stars
Most helpful customer reviews
0 of 1 people found the following review helpful
2.0 out of 5 stars Where's the publishers errata? Sept. 23 2008
By Neil
Having searched through the PDF version of the book on the included CD it seems the first occurrence of the word 'Lookup' in an Excercise is pg 97. So which Lookup are they referring to since the previous step uses an Aggregate, not a Lookup.

That is to say, this book needs an online errata which doesn't seem to exist.

Great book if you are a mind reader though.
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 3.3 out of 5 stars  10 reviews
5 of 5 people found the following review helpful
3.0 out of 5 stars Not Enough for Exam Feb. 28 2008
By M. Rana - Published on Amazon.com
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.
10 of 12 people found the following review helpful
1.0 out of 5 stars Do not buy this book May 1 2008
By simply - Published on Amazon.com
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.
1 of 1 people found the following review helpful
5.0 out of 5 stars Great book to help pass the 70-445 exam May 14 2009
By Zetagirl66 - Published on Amazon.com
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.
1 of 1 people found the following review helpful
4.0 out of 5 stars As good as,if not better than, attending the corresponding the MS intructor led training Oct. 3 2008
By nornal - Published on Amazon.com
Format:Paperback|Verified Purchase
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.
3 of 4 people found the following review helpful
1.0 out of 5 stars Terrible exam prep kit Oct. 21 2008
By ch - Published on Amazon.com
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.
Search Customer Reviews
Only search this product's reviews

Look for similar items by category