Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services

Session Detail:    Classroom 3 Day

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

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)

Who Can Benefit

This course is intended for information technology (IT) professionals and developers who need to implement reporting solutions by using Microsoft SQL Server 2008 Reporting Services.

Session Outline

Class Outline

Module 1: Introduction to Microsoft SQL Server Reporting Services

  • Lesson 1: Overview of SQL Server Reporting Services
  • Lesson 2: Installing Reporting Services
  • Lesson 3: Reporting Services Tools

After completing this module, students will be able to:

  • Describe the features of SQL Server Reporting Services
  • Install Reporting Services
  • Describe the Reporting Services tools

Module 2: Authoring Basic Reports

  • Lesson 1: Creating a Basic Table Report
  • Lesson 2: Formatting Report Pages
  • Lesson 3: Calculating Values

After completing this module, students will be able to:

  • Create a basic table report
  • Format report pages
  • Calculate values for a report

Module 3: Enhancing Basic Reports

  • Lesson 1: Interactive Navigation
  • Lesson 2: Displaying Data

After completing this module, students will be able to:

  • Create reports with interactive navigation
  • Display data in various formats

Module 4: Manipulating Data Sets

  • Lesson 1: Defining Report Data
  • Lesson 2: Using Parameters and Filters
  • Lesson 3: Using Parameter Lists

After completing this module, students will be able to:

  • Define report data
  • Use parameters and filters
  • Use parameter lists

Module 5: Using Report Models

  • Lesson 1: Creating Report Models
  • Lesson 2: Using Report Builder

After completing this module, students will be able to:

  • Create Report Models
  • Use 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

After completing this module, students will be able to:

  • Publish reports
  • Execute reports
  • Create cached instances
  • Create 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

After completing this module, students will be able to:

  • Describe report subscriptions
  • Create report subscriptions
  • Manage 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
  • Lesson 5: Upgrading to Reporting Services 2008

After completing this module, students will be able to:

  • Administer the reporting server
  • Monitor performance and reliability
  • Administer the Report Server databases
  • Administer security
  • Upgrade to Reporting Services 2008

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

After completing this module, students will be able to:

  • Query server information using a Web service
  • Automate report management
  • Render reports
  • Create custom code

Need to train your team?

All of our sessions can be customized to meet your team’s specific need. Build the perfect program by picking and choosing topics from any of the courses in our catalog. A personalized private session gives you the ultimate flexibility and helps maximize your team’s valuable time!

Requesting Team Training
DateTimeTypePriceAdd To Cart
Jul 16, 2021Virtual$299.99
Aug 17, 2021Virtual$299.99
Sep 16, 2021Virtual$299.99
Oct 15, 2021Virtual$299.99
Nov 15, 2021Virtual$299.99
Dec 14, 2021Virtual$299.99
Jul 9, 2021Virtual$299.99
Aug 16, 2021Virtual$299.99
Sep 14, 2021Virtual$299.99
Oct 13, 2021Virtual$299.99
Nov 11, 2021Virtual$299.99
Dec 10, 2021Virtual$299.99
Jun 25, 2021Virtual$299.99
Jul 26, 2021Virtual$299.99
Aug 24, 2021Virtual$299.99
Sep 22, 2021Virtual$299.99
Oct 21, 2021Virtual$299.99
Nov 19, 2021Virtual$299.99
Jun 24, 2021Virtual$299.99
Jul 23, 2021Virtual$299.99
Aug 23, 2021Virtual$299.99
Sep 21, 2021Virtual$299.99
Oct 20, 2021Virtual$299.99
Nov 18, 2021Virtual$299.99
Dec 17, 2021Virtual$299.99
Jul 8, 2021Virtual$299.99
Aug 6, 2021Virtual$299.99
Sep 7, 2021Virtual$299.99
Oct 6, 2021Virtual$299.99
Nov 4, 2021Virtual$299.99
Dec 3, 2021Virtual$299.99
Jul 15, 2021Virtual$299.99
Aug 13, 2021Virtual$299.99
Sep 13, 2021Virtual$299.99
Oct 12, 2021Virtual$299.99
Nov 10, 2021Virtual$299.99
Dec 9, 2021Virtual$299.99
Jun 23, 2021Virtual$299.99
Jul 22, 2021Virtual$299.99
Aug 20, 2021Virtual$299.99
Sep 20, 2021Virtual$299.99
Oct 19, 2021Virtual$299.99
Nov 17, 2021Virtual$299.99
Dec 16, 2021Virtual$299.99
Jul 7, 2021Virtual$0.00
Aug 4, 2021Virtual$0.00
Sep 1, 2021Virtual$0.00
Oct 6, 2021Virtual$0.00
Nov 3, 2021Virtual$0.00
Dec 1, 2021Virtual$0.00
Jul 15-16, 20218:30AM-5:00PM ESTVirtual$795.00
Mar 1 - Mar 5, 202110:00AM-6:00PM ESTVirtual$2,995.00
Apr 19 - Apr 23, 202110:00AM-6:00PM ESTVirtual$2,995.00
Jul 28-30, 20218:00AM-5:00PM ESTVirtual$2,295.00
Aug 10-12, 20218:00AM-5:00PM ESTVirtual$2,295.00
Jun 28 - Jul 1, 20219:30AM - 5:30PM EDTVirtual$3,200.00
Jul 26 - Jul 29, 20219:30AM - 5:30PM EDTVirtual$3,200.00
Jul 26 - Jul 30, 20219:30AM - 5:30PM EDTVirtual$3,875.00
Sep 13 - Sep 17, 20219:30AM - 5:30PM EDTVirtual$3,875.00
Jul 19 - Jul 23, 202110:00AM-6:00PM ESTVirtual$2,995.00

Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services

3 Day
Classroom

$2,295.00

Chat with a Coach

Chat with a Coach

Have a more immediate need? Why spend the next hour searching online for answers when you can spend just 15 minutes with one of our experts and get accurate and personalized answers to all of your questions. 

$9.99 | 15 Minutes

Book Now