MOC-2030 Creating Reporting Solutions Using Microsoft SQL Server 2000 Reporting Services

TEMARIO Y CONTENIDOS

Creating Reporting Solutions using Microsoft SQL Server™ 2000 Reporting Services

Course 2030—Two days—Instructor-led

Prerequisites

Before attending this course, students must have:

•MCDBA (Microsoft Certified Database Administrator) certification or equivalent knowledge.

•Exposure to Visual Studio .

•Experience navigating the Microsoft Windows Server™ environment.

•Experience with Microsoft Windows® services

•Starting and stopping service

Creating service accounts and permissions.

Microsoft Certified Professional Exams

No Microsoft Certified Professional exams are associated with this course currently.

Course Materials

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

Course Outline

Module 1: Introduction to Microsoft SQL Server Reporting Services

•Overview of Microsoft SQL Server Reporting Services

•Tour of Reporting Services

• Overview of Reporting Services Architecture

Module 2: Authoring Basic Reports

•Creating a Basic Table Report

•Formatting Report Pages

•Calculating Values

Module 3: Enhancing Basic Reports

•Interactive Navigation

•Displaying Data

Module 4: Manipulating Data Sets

• Defining Report Data

•Using Parameters and Filters

•Using Parameter Lists

Module 5: Managing Content

•Publishing Content

•Executing Reports

•Creating Cached Instances

•Creating Snapshots and Report History

•Creating Report Subscriptions

Module 6: Administering Reporting Services

•Server Administration

•Performance and Reliability Monitoring

•Database Administration

•Security Administration

Module 7: Programming Reporting Services

•Querying Server Information

•Automating Report Management

• Rendering Reports

•Creating Custom Code