Self-Paced Training Kit (Exam 70-448) Microsoft SQL Server 2008 Business Intelligence Development and Maintenance (MCSA)

by Veerman, Erik; Lachev, Teo; Sarka, Dejan

• ISBN13: 9780735626362
• ISBN10: 0735626367
• Edition: 1st
• Format: Paperback
• Copyright: 2009-04-15
• Publisher: Microsoft Press

Summary

Announcing an all-new Self-Paced Training Kit designed to help maximize your performance on 70-448, the required exam for the new MCTS: Microsoft SQL Server 2008 Business Intelligence Implementation and Maintenance certification. This 2-in-1 kit includes the official Microsoft study guide, plus practice tests on CD to help you assess your skills. It comes packed with the tools and features exam candidates want most including in- depth, self-paced training based on final exam content; rigorous, objective-by-objective review; exam tips from expert, exam-certified authors; and customizable testing options. It also provides real-world scenarios, case study examples, and troubleshooting labs for the skills and expertise you can apply on the job. Work at your own pace through the lessons and lab exercises. This official study guide covers installing, configuring, and managing SQL Server business intelligence components and tools; implementing SQL Server Analysis Services cubes, creating KPIs, and working with MDX; building data mining models and configuring algorithms; administering SQL Server Reporting Services and deploying information-rich solutions; and, developing and troubleshooting SQL Server Integration Services packages. Assess yourself using 300+ practice and review questions on the CD, featuring multiple, customizable testing options to meet your specific needs. Choose timed or untimed testing mode, generate random tests, or focus on discrete objectives. You get detailed explanations for right and wrong answers including pointers back to the book for further study. You also get an evaluation version of SQL Server 2008 software and an exam discount voucher making this kit an exceptional value and a great career investment.

Author Biography

Dejan Sarka is MCT and MCDBA certified and a Microsoft MVP for SQL Server. He teaches and consults for Solid Quality Mentors, speaks at TechEd and PASS, and develops OLTP, OLAP, and data mining solutions.

Table of Contents

Dedication

Exam 70-448: TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

Acknowledgments

Introduction

Developing SSIS Packages

Debugging and Error Handling in SSIS

Deploying and Configuring SSIS Packages

Administering, Securing, and Executing SSIS Packages

Developing SSAS Cubes

Extending SSAS Cubes

Managing SSAS Storage, Processing, and Deployment

Securing and Administering SSAS

Working with SSAS Data Mining

Developing SSRS Reports

Extending and Deploying SSRS Reports

Scheduling and Securing Deployed Reports and Data Sources

Configuring and Administering the SSRS Server

Answers

References

About the Authors

Table of Contents provided by Publisher. All Rights Reserved.