Microsoft SQL Server Reporting Services Class (3 Days)
This is a three day instructor-led, classroom style training class on Microsoft SQL Server 2008 Reporting Services.
Summary:
This three-day instructor-led course teaches students Microsoft SQL Server 2008 Reporting Services. The course content consists of roughly 2 days of writing reports, and 1 day of installing, administering and troubleshooting. The report development practice will primarily use Report Builder to build reports, as we believe that is the easiest tool to build reports with. But we will also show you how to build reports using SQL Server Business Intelligence Studio, so you can judge for yourself.
Course outline:
Module 1: Introduction to Microsoft SQL Server Reporting Services
Lesson 1: Overview of SQL Server Reporting Services
Lesson 2: Reporting Services Tools
Module 2: Authoring Basic Reports Using Report Builder
Lesson 1: Creating a Basic Table Report
Lesson 2: Formatting Report Pages
Lesson 3: Calculating Values
Module 3: Enhancing Basic Reports Using Report Builder
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 SQL Server Business Intelligence Studio to build reports
Lesson 1: Overview
Lesson 2: Pros and Cons of Using BIS versus 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
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