⚠️ This page has been archived

✅ New page with updated info: ssw.com.au/events

  • Presenter
    • Adam Cogan
  • Duration
    • 2 days
  • Price (ex GST)
    • $4,240

This course provides attendees with the knowledge and skills to author, deploy, and manage reports using Microsoft Reporting Services.

After completing this course, students will be able to:

  • Understand the Architecture of Microsoft Reporting Services and Office integration
  • Author reports using 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
Course Times 9am-5pm
Who should attend
  • Database Administrators
  • Database Developers
  • IT Professionals
Pre Requisites
  • MCDBA certification or equivalent
  • Exposure to Visual Studio .NET
  • Exposure to creating reports in MS Access or third party reporting
  • Experience navigating the Microsoft Windows Server environment

Agenda

Day 1

Topic Description
Lesson 1:
Introduction to Microsoft SQL Server Reporting Services
  • Overview of Microsoft SQL Server Reporting Services
  • Tour of Reporting Services as an end user
  • Overview of Reporting Services Architecture
  • System requirements
  • Competitors to Reporting Services
Lesson 2:
Authoring Basic Reports
  • Creating a Basic Table Report
  • Formatting Report Pages
  • Calculating Values
Lesson 3:
Enhancing Basic Reports
  • Interactive Navigation
  • Displaying Data with expressions
Lesson 4:
Manipulating Data Sets
  • Defining Report Data
  • Using Parameters and Filters
  • Using Parameter Lists

Day 2

Topic Description
Lesson 5
  • Publishing Content
  • Executing Reports
  • Creating Cached Instances
  • Creating Snapshots and Report History
  • Creating Report Subscriptions
Lesson 6
  • Server Administration
  • Performance and Reliability Monitoring
  • Database Administration
  • Security Administration
Lesson 7
  • Querying Server Information
  • Automating Report Management
  • Rendering Reports
  • Creating Custom Code
Lesson 8
  • Introduction to Performance Point
Lesson 9
  • Best Practices for Reporting Services

Acknowledgements

Adam Cogan