CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

MS6236 - Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com

This three-day instructor-led course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution.

Click here for a printer-friendly version of this page

Upcoming classes

	Number	Class Date	Location	Length	Cost	Sign up
	MS6236	Aug 01, 2012 - Aug 03, 2012	Bloomington	3 days	$1395.00	Register

Prerequisites

Before attending this course, students must have:

Exposure to creating reports in Microsoft Access or other third-party reporting products, such as Crystal Reports.

Conceptual understanding of the push and pull distribution/subscription paradigm.

Experience navigating the Microsoft Windows Server environment.

Experience with Windows services (starting and stopping)

Experience creating service accounts and permissions

Experience with Microsoft SQL Server, including:

SQL Server Agent.

SQL Server query language (SELECT, UPDATE, INSERT, and DELETE).

SQL Server System tables.

SQL Server accounts (users and permissions).

Detailed Class Syllabus

Module 1: Introduction to Microsoft SQL Server Reporting Services

Lesson 1: Overview of SQL Server Reporting Services

Lesson 2: Installing Reporting Services

Lesson 3: Reporting Services Tools

Module 2: Authoring Basic Reports

Lesson 1: Creating a Basic Table Report

Lesson 2: Formatting Report Pages

Lesson 3: Calculating Values

Module 3: Enhancing Basic Reports

Lesson 1: Interactive Navigation

Lesson 2: Displaying Data

Module 4: Manipulating Data Sets

Lesson 1: Defining Report Data

Lesson 2: Using Parameters and Filters

Lesson 3: Using Parameter Lists

Module 5: Using Report Models

Lesson 1: Creating Report Models

Lesson 2: Using Report Builder

Module 6: Publishing and Executing Reports

Lesson 1: Publishing Reports

Lesson 2: Executing Reports

Lesson 3: Creating Cached Instances

Lesson 4: Creating Snapshots and Report History

Module 7: Using Subscriptions to Distribute Reports

Lesson 1: Introduction to Report Subscriptions

Lesson 2: Creating Report Subscriptions

Lesson 3: Managing Report Subscriptions

Module 8: Administering Reporting Services

Lesson 1: Reporting Server Administration

Lesson 2: Performance and Reliability Monitoring

Lesson 3: Administering Report Server Databases

Lesson 4: Security Administration

Lesson: 5 Upgrading to Reporting Services 2008

Module 9: Programming Reporting Services

Lesson 1: Querying for Server Information Using a Web Service

Lesson 2: Automating Report Management

Lesson 3: Rendering Reports

Lesson 4: Creating Custom Code