1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

SQL Server 2005 Reporting Services: Hands-On

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

You Will Learn How To

  • Leverage SQL Server 2005 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
  • 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

Related Courses

 
SQL Server is a registered trademark of Microsoft Corporation. 		 

Upcoming Dates

Oct 14 - 17, 2008
 Washington, DC (Reston, VA)
Oct 28 - 31, 2008
 New York
Nov 11 - 14, 2008
 Chicago (Downtown)
Nov 11 - 14, 2008
 Toronto
Nov 11 - 14, 2008
 Washington, DC (Rockville, MD)
Dec 2 - 5, 2008
 Baltimore
Dec 9 - 12, 2008
 Chicago (Schaumburg)
Dec 16 - 19, 2008
 Boston (Waltham)
Dec 16 - 19, 2008
 New York
Jan 6 - 9, 2009
 Dallas
Jan 6 - 9, 2009
 Washington, DC (Rockville, MD)
Jan 13 - 16, 2009
 Atlanta
Jan 20 - 23, 2009
 Toronto
Jan 27 - 30, 2009
 New York
Feb 3 - 6, 2009
 Washington, DC (Reston, VA)

For complete schedule, please visit www.learningtree.com
 
http://www.learningtree.com/courses/523pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

SQL Server 2005 Reporting Services: Hands-On

 
Course: 523   Type: Hands-On Training   Duration: 4 Days
 
 
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
 
http://www.learningtree.com/courses/523pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

SQL Server 2005 Reporting Services: Hands-On Tuition

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

Course Tuition
$ 2,790 Standard Tuition
Tuition with a Savings Plan
$ 1,800 10-Day Pass
$ 1,670 Training Passport
$ 1,700 Premium-Pass
$ 2,200 Voucher 10-Pack
$ 2,515 Alumni Gold Discount
$ 2,484 Government Discount
 

 

Your Course Tuition Entitles You To...

  • Class participation
  • Team workshops
  • Use of in-class hands-on equipment
  • Comprehensive course materials
  • Morning and afternoon refreshments
  • Course Completion Certificate awarding Continuing Education Units
  • FREE participation in Professional Certification
  • FREE participation in College Credit programs (including related exams)
  
 

Tuition Savings Plans

Training Passport
  • 3 courses in 12 months
  • As little as $1,670 per course
  • Savings as much as 40%
  • Only $5,000
Premium Pass
  • 4 courses in 24 months
  • As little as $1,700 per course
  • Save as much as 45%
10-Day Pass
  • A NEW way to save on training
  • 10 days of training for one person
  • Save as much as $990 per course
  • Only $4,500
Training Vouchers
  • Save as much as $990 per course
  • Fully transferable
  • As low as $2,200 per course
Alumni Gold Discount Attend your first course and you'll receive a personalized Alumni Gold Discount card, entitling you to save as much as $305 on each course you take within the following 12 months. Take just one course each year and you'll be entitled to ongoing discounts...year after year!

Your Guarantee of Satisfaction

Unless you feel 100% satisfied that Learning Tree delivered even more than you expected, there is no fee for your course attendance. Our Guarantee of Quality lets you experience the value of the course--and then pay only if you feel the course was well worth the tuition.

Enrolling is Easy and Flexible!

Enroll by phone or online. If your plans change, just let us know and, without a fee, you can transfer to another course or cancel your enrollment. Pay after you've taken the course, and then only if you are 100% satisfied.
 
http://www.learningtree.com/courses/523pf.htm