Microsoft Course 2030 Creating Reporting Solutions using Microsoft SQL Server™ 2000 Reporting Services — A 2-Day Course

 Open Public Course Closed In-House Course

Course Synopsis

This two-day instructor-led training course provides students with the knowledge and skills to author, deploy, and manage reports using Microsoft Reporting Services. Students should leave the course with a good understanding of how to apply reporting services to problems within a business context.

Course Objectives

On completion of this SQL Server training course, delegates should be able to:

• Understand the architecture of Microsoft Reporting Services and Office integration
• Author reports using the Report Designer
• Deploy and publish reports
• Manage the lifecycle of a report including report scheduling and backup and restore
• Understand how to apply Reporting Services to a business problem

Intended Audience

This SQL training course is intended for:

• Database administrators
• Database developers
• IT professionals

Course Prerequisites

Before attending this course, delegates are expected to have:

• MCDBA (Microsoft Certified Database Administrator) certification or equivalent knowledge.
• Exposure to Visual Studio .NET.
• Exposure to creating reports in Microsoft Access or third party reporting products.
• Experience navigating the Microsoft Windows Server™ environment.
• Experience with Microsoft Windows services.
• Starting and stopping services.
• Creating service accounts and permissions.

Certification

There are currently no Microsoft Certified Professional exams are associated with this course.

Course Materials

The student kit includes a comprehensive workbook and other necessary materials for this class.

Publicly scheduled dates, locations, and prices

Outline Course Contents

Introduction to Microsoft SQL Server Reporting Services

The information in this module introduces the role Reporting Services plays in an organization's reporting lifecycle, the key features offered by Reporting Services, and the components that make up the Reporting Services architecture.

• Overview of Microsoft SQL Server Reporting Services
• Tour of Reporting Services
• Overview of Reporting Services Architecture

Authoring Basic Reports

In this module, students learn about the fundamentals of report authoring, including how to configure data sources and data sets, create tabular reports, summarize data, and apply basic formatting.

• Creating a Basic Table Report
• Formatting Report Pages
• Calculating Values

Enhancing Basic Reports

This module introduces some techniques for enhancing a basic report using document maps, actions, and data regions. Document maps provide navigation through a contents page, actions provide a mechanism for creating custom actions (jumping from one report to another for example), and data regions allow data to be displayed in formats such as a matrix or a list.

• Interactive Navigation
• Displaying Data

Manipulating Data Sets

In this module, data sets are covered in greater depth, including the use of alternative data sources and interacting with a data set through parameters. Student will learn how to dynamically modify the data set underlying a data region allowing parameters to be sent to the underlying query. This module presents various best practices for dealing with static and dynamic parameter lists when interacting with stored procedures.

• Defining Report Data
• Using Parameters and Filters
• Using Parameter Lists

Managing Content

This module introduces the management of content in the Reporting Services database. The module discusses the process of deploying reports together with the various mechanisms that can be used in deployment. Students learn about the report execution models supported by Reporting Services, including the caching of report instances. Finally, students learn about using subscriptions for report delivery.

• Publishing Content
• Executing Reports
• Creating Cached Instances
• Creating Snapshots and Report History
• Creating Report Subscriptions

Administering Reporting Services

This module introduces the administration of the Reporting Services server, the administration of individual jobs, and the administration of the database. In this module, students will learn how to administer the Reporting Services server, monitor and optimize the performance of the Report Server, maintain the Reporting Services databases, and keep the system secure.

• Server Administration
• Performance and Reliability Monitoring
• Database Administration
• Security Administration

Programming Reporting Services

This module introduces the programmatic control of Reporting Services. In this module, students will learn how to query Reporting Services information programmatically and how to automate their report management tasks. They will also learn how to render reports without relying on Report Manager and how to create custom code to extend the feature set of the Report Server.

• Querying Server Information
• Automating Report Management
• Rendering Reports
• Creating Custom Code