MCTS 70-445 Microsoft SQL Server 2005 - Business Intelligence- Implementation and Maintenance Training


MCTS 70-445 Microsoft SQL Server 2005 - Business Intelligence- Implementation and Maintenance

Our 70-445 Microsoft SQL Server 2005 Business Intelligence Implementation and Maintenance Certification Training Course teaches students how to implement an Analysis Services solution in an organization, how to develop, deploy, and manage Integration Services packages and how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution.

Microsoft Certified Technology Specialists in Microsoft SQL Server 2005 Business Intelligence (MCTS: SQL Server 2005 Business Intelligence) implement and maintain business intelligence solutions. They have thorough knowledge of the Microsoft SQL Server 2005 Business Intelligence Development tool suite as well as knowledge of database schemas, debugging, monitoring, and troubleshooting Business Intelligence solutions, and they know how to work with Microsoft .NET Framework. Additionally, they author and deploy SQL Server Integration Services (SSIS) packages.

When you pass Exam 70-445: TS: Microsoft SQL Server 2005  Business Intelligence Implementation and Maintenance, you complete the requirements for the following certification:

MCTS: Microsoft Certified Technology Specialist: SQL Server 2005 Business Intelligence

Exam 70-445 also counts towards credit for the following certification: MCITP: Business Intelligence Developer.

  This exam is intended for experts in implementing and maintaining solutions by using the Microsoft SQL Server 2005 Business Intelligence tool suite.

n Our easy-to-use delivery format allows you to concentrate on the lesson at hand and not how to run the delivery software - saving you time and frustration. Our comprehensive course materials are delivered in an easy-to- understand format - allowing you to get the most out of your time. n

Our courses incorporate audio, video, and text training and then the total experience is reinforced with exercises and practice tests to ensure that you have really grasped the material.

This Course is available online or via DVD's:
Online Course = All items marked with are included.
DVD Study Kit = Everything! - If its marked with then its included.
For Pricing - Click Here
Live Video,
Courses =
Courses =
Online Streaming Video
(Broadband min 512k)
12 Months subscription
Featuring live instructor-led classroom-like sessions in digital video format. Multimedia-rich delivery brings experienced subject matter experts to your desktop or laptop.
Training Simulations  
DVD Courses = Delivered on DVD
Online Courses = Online Access
Interactive hands-on practice lab
Email Support  
1 Year's Technical Email Support
DVD Courses= Delivered
on DVD
Online Courses = Downloadable
Free Upgrades  
12 months of Free Upgrades.
Compatibility with:  

XP | Win 2003/8 server | Vista
Exam Simulator  
Exam Simulator for closest replication to the real exam!



Content on this page requires a newer version of Adobe Flash Player.

Get Adobe Flash player





(Learning Segments)


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
Review Quiz
Creating Multidimensional Analysis Solutions
Developing Analysis Services Solutions
Creating a Data Source and a Data Source View
Creating a Cube
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
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
Configure Measures
Define Dimension Usage and Relationships
Configure Measure Group Storage
Review Quiz
Querying Multidimensional Analysis Solutions
MDX Fundamentals
Adding Calculations to a Cube
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
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
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
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 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
Explore Report Designer
Explore Report Manager
Review Quiz
Authoring Basic Reports
Creating a Basic Table Report
Formatting Report Pages
Calculating Values
Create a Basic Table Report
Format Report Pages
Add Calculated Values
Review Quiz
Enhancing Basic Reports
Interactive Navigation
Displaying Data
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
Restrict Query Results
Filter Report Data
Review Quiz
Using Report Models
Creating Report Models
Using Report Builder
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
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
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
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


Module 2 - Course 2792

Course Overview
Introduction to SQL Server 2005 Integration Services
Overview of Integration Services Solutions
Integration Service Tools
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
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
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
Transfer Data
Implement Transformations
Use Data Viewers
Configure Error Output
Review Quiz
Implementing Logging
Overview of Integration Services Logging
Implementing Logging
Configure Logging
Implement Custom Logging
Review Quiz
Debugging and Error Handling
Debugging a Package
Implementing Error Handling
Debug a Package
Review Quiz
Implementing Checkpoints and Transactions
Implementing Checkpoints
Implementing Transactions
Implement Checkpoints in a Package
Implement Transactions in a Package
Implement a Native Transaction
Review Quiz
Deploying Packages
Package Configurations
Deploying Packages
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



Full motion video

Each class is presented in full motion video allowing you to see the steps, hear the explanations, and perform the tasks which includes our interactive hands-on training simulations, students will learn from real-world scenarios taught by our expert instructor.

Instructor-Led Training

Combines both the convenience and affordability of computer-based training with the effectiveness of a traditional classroom setting. The instructors featured in our multi-media DVD's are not only certified in their area of expertise, but also have years of real world experience and are subject matter experts in their fields.


We supply a complete line of e-books to offer a complete training solution. Our courses include e-books for CompTIA, CISCO and Microsoft certifications.Supplied on DVD for DVD courses or downloadable for Online Courses.

Practice Exam Simulators

We offer exam simulators for all technical certifications. Our exam simulators are the closest replication to the real exam!

Our exam simulators creates a simulation of an actual certification exam. Under timed conditions, IntelliSage? sets up a test with 60 randomly chosen questions designed to help you get ready for the real exam. As with the Practice Exam, the Certification Simulator allows you to mark questions you cannot answer for review at the end of the test.
If you ask, IntelliSage? will show you the correct answer. IntelliSage? will also explain why it is the correct answer when you select the "Learn Now" feature. The Practice Exam is the first IntelliSage? step in getting you ready to pass your certification exams.

Hands-on Lab Simulation

Hands-on Lab Simulation is a crucial component of your IT training. Practice make perfect. Step-by-step hands-on labs with detail instructions are included to reinforce all key concepts. When you complete a topic, choose the Lab Simulation button to select the associated hands-on lab exercises. Labs allow you to reinforce concepts by performing the tasks you've just learned..

Free Upgrades

A unique benefit of the our Learning System, is that
it allows you to stay current with the ever-changing certification requirements. When a certification test changes and we produce an upgrade for the certification program, we offer our customers free upgrades on their interactive DVD's for up to 1 year from date of original purchase? absolutely free!


MCTS 70-445 Microsoft SQL Server 2005 - Business Intelligence- Implementation and Maintenance

Online Course:£300 ex. VAT
DVD Study Kit: £300 ex. VAT
List Price:£750  
Online Library: 95% off

1yr Unlimited Online Access to 143 Courses
Save 95%

      What's included in each option?

mcse training
 ©Copyright 2009 All Rights Reserved