Creating
Reporting Solutions Using Microsoft SQL Server 2005 Reporting Services
- Presenter
- Duration
- Price (ex GST)
- Sydney
- Brisbane
- 8 Dec 08 completed
30 Aug 09 Sold Out
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
|
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
|
|
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
Scott McPhillips
Jatin Valabjee
.