Course Details

Previous Page


Implementing SQL Server 2008 Reporting Services Solutions


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number



Overview/Description
SQL Server 2008 Reporting Services provides powerful and flexible solutions for enterprise reporting needs. This course introduces the reporting services functionality, tools, installation, and enhancements provided by SQL Server 2008. It outlines the fundamental tasks involved in authoring a basic report and explores the features available to customize and enhance report functionality. This includes understanding the Report Definition Language used with reports, the types of report objects and items that can be added to reports, defining and manipulating data sources and datasets, and formatting the appearance of reports. The course also covers the use of parameters and filters in manipulating report data sets, as well as the addition of user interactivity features such as drilldowns, document maps, and sorting. The course also discusses how the functionality of reports can be extended through the incorporation of expressions and custom code assemblies. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-448 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance certification.

Target Audience
IT professionals working to develop and maintain Microsoft SQL Server 2008 business intelligence solutions or those pursuing a career as a database administrator or developer

Prerequisites
Familiarity with Microsoft .NET Framework; experience with SQL Server 2005 or SQL Server 2008 business intelligence components; experience in performing queries on relational databases and using SQL Server Management Studio and Business Intelligence Development Studio

Expected Duration (hours)
3.0

Lesson Objectives

Implementing SQL Server 2008 Reporting Services Solutions

  • recognize what SQL Reporting Services is used for
  • install Reporting Services
  • configure Reporting Services
  • recognize how to author SQL Server reports
  • format reports in SQL Server 2008
  • recognize how to filter data in SQL Server 2008 reports
  • add interactivity to reports
  • add expressions to reports
  • add custom code in reports
  • use reports in SQL Server 2008
  • Course Number:
    md_mqbm_a04_it_enus