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

Ace your preparation for the skills measured by MCTS Exam 70-448—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through 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:

• Create SSIS packages; troubleshoot data flow and control flow
• Configure, debug, and deploy SSIS solutions
• Develop SSAS cubes for OLAP and data mining services
• Implement custom logic with MDX
• Optimize storage design and query performance
• Create SSRS reports; enable interactivity; write custom code
• Manage the report environment
• Configure security features for SSIS, SSAS, and SSRS

Table of Contents
Chapter 1. Developing SSIS Packages
Chapter 2. Debugging and Error Handling in SSIS
Chapter 3. Deploying and Configuring SSIS Packages
Chapter 4. Administering, Securing, and Executing SSIS Packages
Chapter 5. Developing SSAS Cubes
Chapter 6. Extending SSAS Cubes
Chapter 7. Managing SSAS Storage, Processing, and Deployment
Chapter 8. Securing and Administering SSAS
Chapter 9. Working with SSAS Data Mining
Chapter 10. Developing SSRS Reports
Chapter 11. Extending and Deploying SSRS Reports
Chapter 12. Scheduling and Securing Deployed Reports and Data Sources
Chapter 13. Configuring and Administering the SSRS Server

Book Details

• Paperback: 640 pages
• Publisher: Microsoft Press (February 2009)
• Language: English
• ISBN-10: 0735626367
• ISBN-13: 978-0735626362