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

Description

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

Assess your skills with the 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 kit includes:

* 15% exam discount from Microsoft. Offer expires 12/31/13. 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.
* 180-day trial of SQL Server 2008 Enterprise Edition.
* Case scenarios, exercises, and best practices.
* Fully searchable eBook of this guide, plus sample chapters from related books.

A Note Regarding the example files

This book does not ship with a CD or DVD. The example files to accompany the book content are available from http://examples.oreilly.com/9780735626362/

CONTENTS:

Dedication
Exam 70-448: TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance
Acknowledgments
Introduction
Hardware Requirements
Software Requirements
Using the SQL Server Evaluation DVD and the Companion CD
System Requirements for the Companion CD
Microsoft Certified Professional Program
Technical Support
Evaluation Edition Software Support

Chapter 1: Developing SSIS Packages
1.1 Before You Begin
1.2 Lesson 1: Creating SSIS Packages and Data Sources
1.3 Lesson 2: Creating and Editing Control Flow Objects
1.4 Lesson 3: Using Data Flow Adapters and Transformations
1.5 Case Scenario: Creating an ETL Solution
1.6 Chapter Summary

Chapter 2: Debugging and Error Handling in SSIS
2.1 Before You Begin
2.2 Lesson 1: Configuring Package Transactions and Checkpoints
2.3 Lesson 2: Identifying Package Status, Enabling Logging, and Handling Task Errors
2.4 Lesson 3: Handling Data Flow Errors and Debugging
2.5 Case Scenario: Troubleshooting and Handling Errors in SSIS Packages
2.6 Chapter Summary

Chapter 3: Deploying and Configuring SSIS Packages
3.1 Before You Begin
3.2 Lesson 1: Using Package Configurations and Expressions
3.3 Lesson 2: Deploying SSIS Packages
3.4 Case Scenario: Deploying SSIS Packages
3.5 Chapter Summary

Chapter 4: Administering, Securing, and Executing SSIS Packages
4.1 Before You Begin
4.2 Lesson 1: Managing the SSIS Service and Configuring Package Security
4.3 Lesson 2: Executing and Scheduling Packages
4.4 Case Scenario: Securing and Scheduling SSIS Packages
4.5 Chapter Summary

Chapter 5: Developing SSAS Cubes
5.1 Before You Begin
5.2 Lesson 1: Creating Data Sources and Data Source Views
5.3 Lesson 2: Creating and Modifying SSAS Cubes
5.4 Lesson 3: Creating and Modifying Dimensions
5.5 Lesson 4: Creating Measure Groups and Measures
5.6 Case Scenario: Building an SSAS Solution as a Prototype
5.7 Chapter Summary

Chapter 6: Extending SSAS Cubes
6.1 Before You Begin
6.2 Lesson 1: Defining User Hierarchies and Dimension Relationships
6.3 Lesson 2: Creating KPIs, Actions, Translations, and Perspectives
6.4 Lesson 3: Creating Calculations and Queries by Using MDX
6.5 Case Scenario: Extending SSAS Cubes
6.6 Chapter Summary

Chapter 7: Managing SSAS Storage, Processing, and Deployment
7.1 Before You Begin
7.2 Lesson 1: Defining Measure Group Partitions and Aggregations
7.3 Lesson 2: Deploying SSAS Objects
7.4 Lesson 3: Processing SSAS Objects
7.5 Case Scenario: Implementing Low-Latency OLAP and Deployment Strategies
7.6 Chapter Summary

Chapter 8: Securing and Administering SSAS
8.1 Before You Begin
8.2 Lesson 1: Setting Up SSAS Server Security
8.3 Lesson 2: Managing SSAS High Availability, Backups, and Object Scripting
8.4 Lesson 3: Managing SSAS Tuning and Logging
8.5 Lesson 4: Tracing and Monitoring SSAS Instances
8.6 Case Scenario: Administering and Securing SSAS Cubes
8.7 Chapter Summary

Chapter 9: Working with SSAS Data Mining
9.1 Before You Begin
9.2 Lesson 1: Preparing and Creating Data Mining Structures
9.3 Lesson 2: Creating Models and Applying Algorithms
9.4 Lesson 3: Validating Models, Using DMX Queries, and Using Prediction Queries in Reports
9.5 Lesson 4: Securing and Processing Data Mining Models
9.6 Case Scenario: Working with SSAS Data Mining
9.7 Chapter Summary

Chapter 10: Developing SSRS Reports
10.1 Before You Begin
10.2 Lesson 1: Creating SSRS Projects and Reports in BIDS
10.3 Lesson 2: Creating a Dataset from a Data Source
10.4 Lesson 3: Working with Advanced Report Object Properties
10.5 Lesson 4: Applying Dataset Filters and Groups
10.6 Case Scenario: Building Reports for the AdventureWorks Intranet
10.7 Chapter Summary

Chapter 11: Extending and Deploying SSRS Reports
11.1 Before You Begin
11.2 Lesson 1: Assigning Parameters Within Reports
11.3 Lesson 2: Using Expressions to Perform Advanced Report Item Formatting
11.4 Lesson 3: Deploying New Reports and Changes
11.5 Lesson 4: Using Reports in Your Code
11.6 Case Scenario: Creating a Reporting Services Infrastructure
11.7 Chapter Summary

Chapter 12: Scheduling and Securing Deployed Reports and Data Sources
12.1 Before You Begin
12.2 Lesson 1: Administering SSRS Item-Level Permissions and Site Security Roles
12.3 Lesson 2: Creating Report Schedules and Subscriptions
12.4 Lesson 3: Managing Report Caching and Execution Properties in Report Manager
12.5 Case Scenario: Managing the Report Environment for Adventure Works
12.6 Chapter Summary

Chapter 13: Configuring and Administering the SSRS Server
13.1 Before You Begin
13.2 Lesson 1: Installing and Configuring Initial Instances of SSRS
13.3 Lesson 2: Configuring Advanced SSRS Settings and Scale-Out Deployment
13.4 Case Scenario: Scaling Out Your SSRS Servers
13.5 Chapter Summary

Answers
Chapter 1: Case Scenario Answers
Chapter 2: Case Scenario Answers
Chapter 3: Case Scenario Answers
Chapter 4: Case Scenario Answers
Chapter 5: Case Scenario Answers
Chapter 6: Case Scenario Answers
Chapter 7: Case Scenario Answers
Chapter 8: Case Scenario Answers
Chapter 9: Case Scenario Answers
Chapter 10: Case Scenario Answers
Chapter 11: Case Scenario Answers
Chapter 12: Case Scenario Answers
Chapter 13: Case Scenario Answers

References
Implementing an SSIS Solution
Configuring, Deploying, and Maintaining SSIS
Implementing an SSAS Solution
Configuring, Deploying, and Maintaining SSAS
Implementing an SSRS Solution
Configuring, Deploying, and Maintaining SSRS
About the Authors