Home > Courses Certifications > Data Management > Course 6236 synopsis

6236 - Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services

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)

Duration: 3 days

 

Module 1: Introduction to Microsoft SQL Server Reporting Services

• Overview of SQL Server Reporting Services
• Installing Reporting Services
• Reporting Services Tools

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: Using Report Models

• Creating Report Models
• Using Report Builder

Module 6: Publishing and Executing Reports

• Publishing Reports
• Executing Reports
• Creating Cached Instances
• Creating Snapshots and Report History

Module 7: Using Subscriptions to Distribute Reports

• Introduction to Report Subscriptions
• Creating Report Subscriptions
• Managing Report Subscriptions

Module 8: Administering Reporting Services

• Reporting Server Administration
• Performance and Reliability Monitoring
• Administering Report Server Databases
• Security Administration
• Upgrading to Reporting Services 2008

Module 9: Programming Reporting Services

• Querying for Server Information Using a Web Service
• Automating Report Management
• Rendering Reports
• Creating Custom Code