6236 Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services

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

Lesson 1: Introduction to Microsoft SQL Server Reporting Services

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

Lesson 2: Authoring Basic Reports

• Creating a Basic Table Report
• Formatting Report Pages
• Calculating Values

Lesson 3: Enhancing Basic Reports

• Interactive Navigation
• Displaying Data

Lesson 4: Manipulating Data Sets

• Defining Report Data
• Using Parameters and Filters
• Using Parameter Lists

Lesson 5: Using Report Models

• Creating Report Models
• Using Report Builder

Lesson 6: Publishing and Executing Reports

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

Lesson 7: Using Subscriptions to Distribute Reports

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

Lesson 8: Administering Reporting Services

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

Lesson 9: Programming Reporting Services

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

• Charleston, SC - April 23, 2012
• Columbia, SC - April 23, 2012
• Greenville, SC - April 23, 2012
• Chattanooga, TN - April 23, 2012
• Charleston, WV - April 23, 2012
• McLean, VA - April 23, 2012
• West Valley City, UT - April 23, 2012
• Madison, WI - April 23, 2012
• Appleton, WI - April 23, 2012
• McLean, VA - May 7, 2012
• Las Vegas, NV - May 29, 2012
• Sacramento, CA - May 29, 2012
• Reno, NV - May 29, 2012
• Jacksonville, FL - May 30, 2012
• Charleston, SC - May 30, 2012
• Atlanta, GA - May 30, 2012
• Columbia, SC - May 30, 2012
• Greenville, SC - May 30, 2012
• Greensboro, NC - May 30, 2012
• Charleston, WV - May 30, 2012
• Mechanicsburg, PA - May 30, 2012
• Pittston, PA - May 30, 2012
• Madison, WI - May 30, 2012
• Appleton, WI - May 30, 2012
• Madison, WI - June 11, 2012
• Anaheim, CA - June 20, 2012
• Greensboro, NC - June 25, 2012
• Richmond, VA - June 25, 2012
• Charleston, SC - June 27, 2012
• Columbia, SC - June 27, 2012