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

Erik Veerman (Author), Teo Lachev (Author), Dejan Sarka (Author), Javier Loria (Author), Solid Quality Learning (Author)

Book Description

ISBN-10: 0735623414 | ISBN-13: 978-0735623415 | Publication Date: September 12, 2007

EXAM PREP GUIDE

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

PRACTICE TESTS

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. Offer expires 12/31/12. 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 [e-mail].

Editorial Reviews

From the Publisher

Key Book Benefits:

In-depth coverage of exam objectives and sub-objectives--plus instructive case studies and troubleshooting scenarios to enhance your performance on the job

200+ practice and review questions

Test engine that enables customized testing, pre-assessment and post-assessment, and automated scoring and feedback

Complete objective-by-objective review section, plus a handy exam-mapping grid

180-day evaluation version of SQL Server 2005 Enterprise Edition

15 percent exam discount voucher from Microsoft (limited-time offer)

Entire study guide in searchable eBook format

About the Author

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.

Product Details

• Paperback: 608 pages
• Publisher: Microsoft Press (September 12, 2007)
• Language: English
• ISBN-10: 0735623414
• ISBN-13: 978-0735623415
• Product Dimensions: 9 x 7.4 x 1.6 inches
• Shipping Weight: 2.8 pounds (View shipping rates and policies)
• Average Customer Review: 3.3 out of 5 stars  See all reviews (9 customer reviews)
• Amazon Best Sellers Rank: #672,245 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

5 of 5 people found the following review helpful:

3.0 out of 5 stars Not Enough for Exam, February 28, 2008

By 

M. Rana "Rana" (Australia) - See all my reviews
(REAL NAME)   

This review is from: MCTS Self-Paced Training Kit (Exam 70-445): Microsoft SQL Server 2005 (Paperback)

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 "me" (ole U S of A) - See all my reviews

This review is from: MCTS Self-Paced Training Kit (Exam 70-445): Microsoft SQL Server 2005 (Paperback)

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 - See all my reviews

This review is from: MCTS Self-Paced Training Kit (Exam 70-445): Microsoft SQL Server 2005 (Paperback)

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.