Module 1: Introduction to SQL Server 2005
This module introduces the role that Integration Services plays in extracting,
transforming, and loading data. This module also describes the tools that you can use to
build and manage Integration Services solutions.
• Overview of Integration Services Solutions
• Integration Services Tools
Module 2: Developing Integration Services
This module provides an overview of the development tasks that are involved in
creating an Integration Services package. After completing this module, you will be able to
create a basic package.
• Creating an Integration Services
• Using Variables
• Building and Running a Solution
Module 3: Implementing Control Flow This module introduces the tasks and
precedence constraints that you can use to implement control flow in an Integration
• Control Flow Tasks
• Control Flow Precedence Constraints
• Control Flow Containers
Module 4: Implementing Data Flow
This module describes the data flow sources, transformations, and destinations that you can use to implement a data flow task in an Integration Services control flow. It also explains how to use data flow paths to direct valid and invalid rows through the data flow.
• Data Flow Sources and Destinations
• Data Flow Transformations
• Data Flow Pipeline
Module 5: Implementing Logging
This module discusses how to use logging in an Integration Services package, and explains how to configure and use logging providers to generate information about a package’s execution.
• Overview of Integration Services Logging
• Implementing Logging
Module 6: Debugging and Error Handling
This module describes how to debug Integration Services packages by using the debugging tools in Business Intelligence Development Studio. It then explains how to implement error-handling logic in an Integration Services package.
• debugging a Package
• Implementing Error Handling
Module 7: Implementing Checkpoints and
This module explains what checkpoints are and how to implement them. It then discusses
transactions, and describes how you can implement transactional data access logic in an
Integration Services package.
• Implementing Checkpoints
• Implementing Transactions
Module 8: SSIS Administration.
This module discusses how to create Package Configurations and how to deploy Integration
Services packages to production servers. Package Configurations
• Deploying Packages
• Managing Packages
• Securing Packages
Scheduling a Package
Module 1: Introduction to Microsoft SQL
Server Reporting Services This module introduces the role that Reporting Services plays in an organization’s reporting life cycle, the key features offered by Reporting Services, and the components that make up the Reporting Services architecture.
Overview of SQL Server Reporting Services
Installing Reporting Services Reporting Services Tools
Module 2: Authoring Reports
This module introduces the fundamentals of report authoring, including
configuring data sources and data sets, creating tabular reports, summarizing data,
and applying basic formatting.
Creating a Basic Table Report
Formatting Report Pages
Module 3: Manipulating Data Sets
This module explores data sets to a greater depth, including the use of alternative data sources and interacting with a data set through the use of parameters. Students learn how to dynamically modify the data set underlying a data region by allowing parameters to be sent to the underlying query. They also learn to use best practices to implement static and dynamic parameter lists when interacting with queries and stored procedures.
Defining Report Data
Using Parameters and Filters
Using Parameter Lists
Module 4: Using Report Models
This module describes how to create a report model so that business users can create their own reports without using the full Report Designer development environment. Students also learn how to use Report Builder to create a report from a report model.
Creating Report Models Using Report Builder
Module 5: Publishing and Executing Reports This module explains the various options you can use to publish reports to the report server and execute them.
Creating Cached Instances
Creating Snapshots and Report History
Module 6: Using Subscriptions to Distribute
This module describes how to implement subscriptions so that you can distribute reports either automatically by e-mail or by publishing reports to a shared folder.
Introduction to Report Subscriptions
Creating Report Subscriptions
Managing Report Subscriptions
Module 7: SSRS Administration
This module discusses how to administer the Reporting Services server, how to monitor and
optimize the performance of the report server, how to maintain the Reporting Services
databases, and how to keep the system secure.
Performance and Reliability Monitoring
Administering Report Server Databases
Module 8: Programming Reporting Services
This module explains how to query Reporting Services information programmatically and how to automate report management tasks.
Students also learn how to render reports without relying on Report Manager, and how you
can extend the feature set of a report server by creating custom code.
Querying for Server Information Using a
Web Service Automating Report Management
Rendering Reports Creating Custom Code
Introduction to Analysis Services
This module introduces the role that Analysis Services plays in an organization’s, the
key features offered by Analysis Services, and the components that make up the Analysis Services architecture
Analysis Services Tools
MS – BI
Cube Design process and Concepts This module introduces the role that Cube plays
in Analysis Services, and the components that make up the Analysis Services Cube.
Creating simple calculations
Advanced Cube Design Process This module introduces Advanced Methods like KPI,
Actions and Write back that make up the Analysis Services Cube.
MDX introduction and Queries
Using Write back
This Module provides understanding of production management activities like
security, deploying, processing and scheduling Analysis tasks
Applying Security Roles
Levels of Security
VLDB with partitioning
Monitoring Cube Activity
Deployment and Scheduling
Planning for Disaster and Recovery
Performance Tuning SSAS