|
MCTS 70-448 Training Course TS: Microsoft SQL Server 2008, Business Intelligence Implementation and Maintenance teaches students how to implement SQL Server Implementation Services (SSIS), SQL Server Analysis Services (SSAS) and Sql Server Reporting Services (SSRS) solutions as well as configure, maintain and deploy SSIS, SSAS and SSRS solutions.
When you pass Exam 70-448 TS: Business Intelligence Implementation and Maintenance you complete the requirements for the following certification:
- Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance
Microsoft Exam 70-448 also counts as credit toward the following certifications:
- MCITP: Business Intelligence Developer 2008
This is the most effective way to earn your Microsoft Certified Technology Specialist (MCTS). IT Professionals holding the Microsoft Certified Technology Specialist: SQL Server 2008, Business Intelligence Development and Maintenance certification have demonstrated the knowledge and skills necessary to work with the full suite of BI technologies in SQL Server 2008, including Reporting Services, Analysis Services, and Integration Services.
This Microsoft Certified Course follows the approved Microsoft course curriculum, ensuring you receive the training and knowledge needed to succeed.
Course Overview
Implementing Business Solutions
BI Concepts
Designing an OLAP System
Designing an Architecture
Module Review
Creating SSIS Packages
Creating Packages
Using Control Flow
Implementing Constraints
Module Review
Data Flows
Sources and Destination
Transformations
Transactions
Debugging
Module Review
Package Management
Event Handlers and Logging
Working with Code
Module Review
Deploying SSIS Packages
Deploying Packages
Securing Packages
Executing Packages
Module Review
Implementing Cubes
Data Sources and Data Source Views
Creating Cubes
Configuring Dimensions
Setting Up a Cube
Module Review
Configuring Cubes and Measures
Configuring Measures
MDX
Adding Functionality
Module Review
SSA Solutions
Configuring Security
Configuring Storage
Processing Cubes
Deploying Cubes
Module Review
Data Mining
Data Mining Basics
Building a Data Mining Model
Module Review
Creating Reports
Creating Basic Reports
Interactive Reports
Coding Reports
Module Review
Managing a Report Server
Configuring Reporting Services
Deploying Reports
Controlling Report Execution
Using Subscriptions
Securing Reporting Services
Module Review
Implementing the Report Builder
Report Models
Report Builder
Module Review
Course Review
Exam Preparation
|
