1-800-THE-TREE (1-800-843-8733)
 

SQL Server 2005 Reporting Services: Hands-On

 
Course: 523     Type: Hands-On Training     Duration: 4 Days

Quick Enroll    

You Will Learn How To
  • Leverage SQL Server Reporting Services to produce sophisticated reports
  • Author robust reports that extract business intelligence out of your data
  • Extract relevant report data using parameters and filters
  • Render interactive reports with drill-down and drill-through features
  • Deploy reports to a Report Server for centralized access and administration
  • Secure reports in the Reporting Services environments

Course Benefits
The ability of an organization to deliver business-critical reports to customers, partners, suppliers and employees is a vital component of remaining competitive. SQL Server Reporting Services augments SQL Server and other database management systems to meet these demanding requirements. In this course, you gain the knowledge and skills to write robust reports, mine important data and deliver reports for centralized access and administration.

Who Should Attend
Those designing, creating or delivering reports from a database. Previous exposure to any database system or spreadsheet data is assumed.

Hands-On Training
Throughout this course, you gain extensive experience creating and managing reports using Reporting Services. Exercises include:
  • Authoring free form reports including images, calculated fields and groups
  • Importing Microsoft Access reports
  • Implementing advanced navigation using drill down, drill through and document maps
  • Deploying reports manually and automatically
  • Creating cached instances, snapshots and subscriptions
  • Configuring and testing security on report items
  • Building and applying a currency converter function

Course 523 Content
SQL Server Reporting Services (SSRS) Architecture
  • Report types and formats
  • SSRS Web Services
  • Report Server
  • Report Builder
  • Model Designer
  • Data sources: SQL Server, Oracle, OLE DB
  • Single and Web farm deployment
Authoring Reports
Creating basic reports
  • Tabular
  • List
  • Matrix
  • Chart
  • Constructing data sources and Datasets
  • Inserting a data region, fields and images
Leveraging expressions
  • Calculating fields
  • Built-in collections
  • Integrating expressions in properties
  • Applying conditional formatting
  • Best practices for adding images
Grouping and sorting data
  • Grouping to multiple levels
  • Sorting the results
  • Employing aggregate functions
Implementing Parameters and Filters
Building parameters into reports
  • Returning subsets of data with query parameters
  • Mapping report parameters to query parameters
  • Building cascading report parameters
  • Changing chart titles programmatically
  • Designing reports for the user's national language
  • Passing parameters to stored procedures
  • Exploiting multivalued parameters
Restricting report data with filters
  • Enhancing performance with filters
  • Filters vs. query parameters
  • Localizing tables and queries
Leveraging Advanced Reporting Features
Combining data regions in one report
  • Utilizing sequential and nested regions
  • Producing master/detail reports
  • Linking subreports
Presenting data with appropriate detail
  • Revealing report detail with drill down
  • Displaying related data with drill through
  • Navigating with document maps
Deploying and Delivering Reports
Deploying reports to the server
  • Preparing reports for publishing
  • Configuring project properties
  • Units of deployment: Individual reports, projects, solutions, data sources
  • Checking results with Report Manager
Selecting delivery options
  • On-demand or by subscription
  • Improving performance with cached instances and snapshots
  • Configuring snapshot history
Sending subscription reports
  • Making reports available via e-mail and fileshare
  • Delivering reports flexibly through data-driven subscriptions
Securing Reporting Services
Securing the RS environment
  • Assigning users to roles
  • Setting permissions on report items
  • Granting and revoking system-level permissions
Empowering users with ad-hoc reporting
  • Architecting report models with Model Designer
  • Defining data source views
  • Creating and retiring models
Creating reports with Report Builder
  • Deploying Report Builder to users
  • Dragging and dropping entities onto charts and tabular reports
  • Navigating data with infinite drill through
Programming Reporting Services
Expanding the capabilities of SSRS
  • Exploiting SSRS Web services
  • Searching for information in a report
  • Writing a Windows application with Report Viewer controls
Delivering Business Intelligence with SSRS
  • Mapping out the role of SSRS in a BI Infrastructure
  • Integrating Reporting Services with SharePoint

Related Courses
SQL Server is a trademark of Sybase, Inc.
  
 
Request More Info

Salutation

First Name

Last Name

Company

Zip Code

Country
   Codes
Work Phone

Extension

E-mail

A representative will contact you to follow up your request.
Privacy Statement

Save an EXTRA $200 on a 10-Day Training Pass!

SQL Server 2005 Reporting Services: Hands-On
Upcoming Dates
Sep 16 - 19, 2008
 New York
Sep 30 - Oct 3, 2008
 Washington, DC (Rockville, MD)
Oct 14 - 17, 2008
 Washington, DC (Reston, VA)
Oct 21 - 24, 2008
 Irvine, CA
Oct 28 - 31, 2008
 New York
Nov 4 - 7, 2008
 Washington, DC (Alexandria, VA)
Nov 11 - 14, 2008
 Chicago (Downtown)
Nov 11 - 14, 2008
 Toronto
Nov 11 - 14, 2008
 Washington, DC (Rockville, MD)
Nov 18 - 21, 2008
 Annapolis, MD

SQL Server 2005 Reporting Services: Hands-On
Bring Learning Tree On-Site

Course Tuition
$ 2,650 Standard Tuition
Tuition with a Savings Plan
$ 1,580 10-Day Pass
$ 1,665 Training Passport
$ 1,830 Flex-Pass
$ 2,095 Voucher 10-Pack
$ 2,385 Alumni Gold Discount
$ 2,360 Government Discount
 

 

SQL Server 2005 Reporting Services: Hands-On
SQL Server 2005 Reporting Services: Hands-On
Participants creating drill-down reports.
The most recent 100 evaluations scored this course at:

  (3.74/4.00)


SQL Server 2005 for the Enterprise


CPE 23 Credits 2 Hour(s) College Credit
Customer Service or Enroll: 1-800-843-8733