Developing Applications that Use SQL Server Business Intelligence Services

This course is included in our On-demand training solution.


recognize how to implement Reporting Services to generate reports and Integration Services to manipulate data according to your requirements

Target Audience

Developers who use Microsoft Office SQL Server 2005 and consultants providing consulting services for SQL Server 2005; individuals looking to pass the 70-441 PRO: Designing Database Solutions by Using Microsoft SQL Server 2005 certification exam and those individuals targeting toward the Microsoft certification: Microsoft Certified IT Professional (MCITP): Database Developer certification path.


Three or more years database programming experience including expertise in troubleshooting triggers, queries, stored procedures, user-defined functions, and user-defined types, writing Transact-SQL queries, performing database performance optimization, designing and troubleshooting the data access layer of the application, designing databases, iImplementing databases at the physical level, and gathering business requirements.

Expected Duration

135 min.

Course Objectives

Developing Applications that Use SQL Server Business Intelligence Services

  • recognize the various features and components of Reporting Services.
  • recognize how to create, modify, and design reports.
  • recognize how to use the tools required to administer the Reporting Services application.
  • recognize data sources, and execution and scheduling of reports.
  • recognize how to build high performance data integration and workflow solutions by using Integration Services tools for building and managing data integration solutions.
  • recognize how to create an SSIS Package.
  • determine the design of a Reporting Service and Integration Service solution.