MCTS: SQL Server 2005 (Exam 70-445)

SQL Server 2005 - Business Intelligence Implementation
and Maintenance (70-445) Training Course Curriculum:

Module 1 - Course 2791

Course Overview
Introduction to SQL Server 2005 Analysis Services
Overview of Data Analysis Solutions
Overview of SQL Server 2005 Analysis Services
Installing SQL Server 2005 Analysis Services
Summary
Review Quiz
Creating Multidimensional Analysis Solutions
Developing Analysis Services Solutions
Creating a Data Source and a Data Source View
Creating a Cube
Summary
Create a Data Source
Create and Modify a Data Source View
Create and Modify a Cube
Review Quiz
Working with Dimensions
Configuring Dimensions
Defining Hierarchies
Sorting and Grouping Attributes
Summary
Configure Dimensions
Define Relationships and Hierarchies
Sort and Group Dimension Attributes
Review Quiz
Working with Measures and Measure Groups
Working with Measures
Working with Measure Groups
Summary
Configure Measures
Define Dimension Usage and Relationships
Configure Measure Group Storage
Review Quiz
Querying Multidimensional Analysis Solutions
MDX Fundamentals
Adding Calculations to a Cube
Summary
Query a Cube by Using MDX
Create a Calculated Member
Define a Named Set
Review Quiz
Customizing Cube Functionality
Implementing Key Performance Indicators
Implementing Actions
Implementing Perspectives
Implementing Translations
Summary
Implement a KPI
Implement an Action
Implement a Perspective
Implement a Translation
Review Quiz
Deploying and Securing an Analysis Services Database
Deploying an Analysis Services Database
Securing an Analysis Services Database
Summary
Deploy an Analysis Services Database
Secure an Analysis Services Database
Review Quiz
Maintaining a Multidimensional Solution
Configuring Processing Settings
Logging, Monitoring, and Optimizing an Analysis Services Solution
Backing Up and Restoring an Analysis Services Database
Summary
Implement Logging and Monitoring
Back Up and Restore a Database
Review Quiz
Introduction to Data Mining
Overview of Data Mining
Creating a Data Mining Solution
Validating Data Mining Models
Course Summary
Create a Data Mining Structure
Add a Data Mining Model
Explore Data Mining Models
Review Quiz

Module 2 - Course 2792

Course Overview
Introduction to SQL Server 2005 Integration Services
Overview of Integration Services Solutions
Integration Service Tools
Summary
Use the Import and Export Wizard
Run an Integration Services Package
Review Quiz
Developing Integration Services Solutions
Creating an Integration Services Solution
Using Variables
Building and Running a Solution
Summary
Create an Integration Services Project
Implement a Package
Build and Run an Integration Services Project
Review Quiz
Implementing Control Flow
Control Flow Tasks
Control Flow Precedence Constraints
COntrol Flow Containers
Summary
Create a Simple Control Flow
Configure Precedence Constraints
Use Containers
Review Quiz
Implementing Data Flow
Data Flow Sources and Destinations
Data Flow Transformations
Data Flow Paths
Summary
Transfer Data
Implement Transformations
Use Data Viewers
Configure Error Output
Review Quiz
Implementing Logging
Overview of Integration Services Logging
Implementing Logging
Summary
Configure Logging
Implement Custom Logging
Review Quiz
Debugging and Error Handling
Debugging a Package
Implementing Error Handling
Summary
Debug a Package
Review Quiz
Implementing Checkpoints and Transactions
Implementing Checkpoints
Implementing Transactions
Summary
Implement Checkpoints in a Package
Implement Transactions in a Package
Implement a Native Transaction
Review Quiz
Deploying Packages
Package Configurations
Deploying Packages
Summary
Create a Package Configuration
Prepare a Package for Deployment
Deploy a Package
Review Quiz
Managing and Securing Packages
Managing Packages
Securing Package
Course Summary
Import a Package
Configure and Execute a Package
Schedule a Package
Secure a Package
Review Quiz

Module 3 - Course 2793

subjects title
Course Overview
Introduction to SQL Server Reporting Services
Overview of SQL Server Reporting Services
Installing Reporting Services
Reporting Services Tools
Summary
Explore Report Designer
Explore Report Manager
Review Quiz
Authoring Basic Reports
Creating a Basic Table Report
Formatting Report Pages
Calculating Values
Summary
Create a Basic Table Report
Format Report Pages
Add Calculated Values
Review Quiz
Enhancing Basic Reports
Interactive Navigation
Displaying Data
Summary
Use Dynamic Visibility
Use Document Maps
Initiate Actions
Use a List Data Region
Review Quiz
Manipulating Data Sets
Defining Report Data
Using Parameters and Filters
Using Parameter Lists
Summary
Restrict Query Results
Filter Report Data
Review Quiz
Using Report Models
Creating Report Models
Using Report Builder
Summary
Create a Report Model
Use Report Builder
Review Quiz
Publishing and Executing Reports
Publishing Reports
Executing Reports
Creating Cached Instances
Creating Snapshots and Report History
Summary
Publish Reports
Execute a Report On Demand
Configure and View a Cached Report
Configure and View Snapshot Report
Review Quiz
Using Subscriptions to Distribute Reports
Introduction to Report Subscriptions
Creating Report Subscriptions
Managing Report Subscriptions
Summary
Create a Standard Subscription
Create a Data-Driven Subscription
Review Quiz
Administering Reporting Services
Server Administration
Performance and Reliability Monitoring
Administering Report Server Databases
Security Administration
Summary
Use Configuration Manager
Secure a Report Services Site
Secure Items
Review Quiz
Programming Reporting Services
Querying for Server Information Using a Web Service
Automating Report Management
Rendering Reports
Creating Custom Code
Course Summary
Use URL Access to Display a Report
Build a Web Service Client
Use the Report Viewer Control
Review Quiz