 |
 SQL Server 2008 Business Intelligence Suite training
SQL Server Training: Introduction to Microsoft SQL Server 2005 for Developers and Query Writers
SQL Server Administration Training: Introduction to Microsoft SQL Server 2005 for Administrators
SQL Server 2005: Advanced Topics
SSRS Training: Introduction to SQL Server 2005 Reporting Services
SSAS Training: Introduction to SQL Server 2005 Analysis Services
SSIS Training: Introduction to SQL Server 2005 Integration Services
Transact-SQL Training: Introduction to T-SQL for SQL Server for Report Writing
T-SQL Training: T-SQL for SQL Server 2005 for Developers
Live Online Training
 Please contact us
for GSA pricing
and CMAS pricing.
Contract #
GS-35F-0307T
Contract #
3-09-70-2645A
Complimentary SQL Server Training Seminar
Organizations in the Atlanta, Georgia area are encouraged
to contact Accelebrate® about having a complimentary, one-hour SQL Server seminar delivered for their developers. Contact
us today for more information.
Recent Training Venues
Accelebrate has recently trained for clients in the following cities:
- Huntsville, Alabama
- Montgomery / Birmingham, Alabama
- Anchorage, Alaska
- Calgary, Alberta
- Phoenix, Arizona
- Fayetteville / Little Rock, Arkansas
- Amsterdam, The Netherlands / Brussels, Belgium
- Oakland / San Jose / San Francisco, California
- Sacramento, California
- Oceanside / San Diego, California
- Pasadena / Orange County / Los Angeles, California
- San Bernardino / Riverside, California
- Boulder / Colorado Springs / Denver, Colorado
- Washington, DC
- Wilmington, Delaware
- Manchester / London, England
- DeLand / Orlando, Florida
- Fort Lauderdale / Miami, Florida
- Gainesville / Jacksonville, Florida
- Saint Petersburg / Tampa, Florida
- Titusville & Melbourne, Florida
- Alpharetta & Atlanta, Georgia
- Augusta & Savannah, Georgia
- Macon & Columbus, Georgia
- Boise, Idaho
- Bloomington, Illinois
- Chicago, Illinois
- Indianapolis, Indiana
- Cedar Rapids / Des Moines, Iowa
- Dublin, Ireland
- Kingston, Jamaica
- Wichita, Kansas
- Paducah / Lexington / Louisville, Kentucky
- Baton Rouge, Louisiana
- Valletta, Malta
- Hagerstown & Frederick, Maryland
- Greenbelt / Silver Spring / Baltimore, Maryland
- Boston / Cambridge, Massachusetts
- Hartford, Connecticut / Springfield, Massachusetts
- Taunton, Massachusetts / Providence, Rhode Island
- Ann Arbor / Farmington Hills / Detroit, Michigan
- Grand Rapids, Michigan
- Lansing, Michigan
- Saginaw / Flint / Bay City / Midland, Michigan
- Saint Paul / Minneapolis, Minnesota
- Jackson, Mississippi
- Gulfport / Biloxi, Mississippi
- St. Louis, Missouri
- Whiteman Air Force Base / Kansas City, Missouri
- Lincoln / Omaha, Nebraska
- Reno and Las Vegas, Nevada
- Santa Fe / Albuquerque, New Mexico
- Newark, New Jersey
- Princeton, New Jersey & Philadelphia, Pennsylvania
- White Plains / New York City, New York
- Charlotte, North Carolina
- Durham / Raleigh, North Carolina
- Bowling Green / Toledo, Ohio
- Canton / Akron, Ohio
- Cincinnati, Ohio
- Cleveland & Columbus, Ohio
- Dayton, Ohio
- Tulsa / Oklahoma City, Oklahoma
- Toronto, Ontario
- Portland, Oregon
- Pittsburgh, Pennsylvania
- Providence, Rhode Island
- Edinburgh / Glasgow, Scotland
- Columbia & Charleston, South Carolina
- Stockholm, Sweden
- Chattanooga / Knoxville, Tennessee
- Memphis / Jackson / Nashville, Tennessee
- College Station and Houston, Texas
- El Paso, Texas / Ciudad Juarez, Mexico
- San Antonio / Austin, Texas
- Wichita Falls & Dallas, Texas
- Ogden / Salt Lake City, Utah
- Burlington, Vermont
- Fairfax / Dulles / McLean / Herndon / Reston, Virginia
- Richmond / Alexandria / Arlington, Virginia
- Virginia Beach / Norfolk, Virginia
- Tacoma / Seattle, Washington
- Madison / Milwaukee, Wisconsin
|
|
|
SQL Server 2005 Reporting Services Training: Introduction to SQL Server 2005 Reporting Services (SSRS)
|
Course Number: 653
Duration: 3 days
view class outline
Looking for SSRS 2008 training?
SQL Server 2005 Reporting Services Training Overview
Accelebrate's Introduction to SQL Server 2005 Reporting Services (SSRS) training teaches attendees how to create, test, and distribute SQL Server 2005 Reporting Services reports. In addition, this SSRS training optionally teaches attendees how to interface with SSRS from .NET applications.
Accelebrate also offers SQL Server 2008 Business Intelligence Suite training with SSRS 2008, SSIS 2008, and SSAS 2008.
Location and Pricing
Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor’s or students’ travel expenses. To receive a customized proposal and price quote private training at your site or online, please contact us.
In addition, some courses are available as live, online classes for individuals. To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/sql.htm.
SQL Server 2005 Reporting Services Training Prerequisites
All SSRS training attendees should have prior experience with relational databases and writing SQL queries for SQL Server 2005.
Hands-on/Lecture Ratio
This SSRS training is 70% hands-on, 30% lecture, with the longest lecture segments lasting for 10 minutes.
SQL Server 2005 Reporting Services Training Materials
All SSRS training students will receive a copy of Wrox Press's Professional SQL Server 2005 Reporting Services and comprehensive courseware covering all topics taught.
Software Needed on Each Student PC
- Windows 2000 Pro, XP Pro, Windows Server 2003, Windows Server 2008, or Vista Business/Ultimate with latest service packs applied
- Microsoft IIS turned on prior to SQL Server installation
- SQL Server 2005 full install, including Reporting Services, with latest service packs applied
- At least 1GB RAM (2GB recommended)
- Sample databases and related tools – please contact us for a detailed setup sheet
Important Note: If you have purchased this class, please contact us for detailed setup instructions.
SQL Server 2005 Reporting Services Training Objectives
All attendees will:
- Master creating reports using SQL Server 2005 Reporting Services
- Discover how to add calculations and formatting to reports
- Group and sort data within reports
- Understand how to add report parameters and set their values at runtime
- Manage and secure Reporting Services
- Distribute reports via subscriptions
- Integrate Reporting Services into applications
|
SQL Server 2005 Reporting Services (SSRS) Training Outline
- Introducing SQL Server Reporting Services
- Tour of Features
- Reporting Services Architecture
- Reporting Services Terminology
- Reporting Services Editions
- Taking Reporting Services for a Spin
- Creating Reports
- Deconstructing Reporting Services
- Shared Data Sources
- Creating Reports from Scratch
- Calculations and Formatting
- Creating Expressions
- Using the Global Collections
- Formatting Items
- Conditional Formatting
- Grouping and Sorting
- Creating Groups
- Calculating Totals and Percentages
- Interactive Sorting
- Creating Drill-Down Reports
- Report Parameters
- Creating Report Parameters
- Creating Drop-Down Parameters
- Multi-Valued Parameters
- Debugging Parameter Issues
- Creating Matrix Reports and Charts
- Creating a Basic Matrix Report
- Matrix Subtotals
- Creating a Basic Chart
- Exploring the Charting Possibilities
- Managing Reporting Services
- Deploying Reports and Data Sources
- Exporting Reports and Printing
- Using the Web-Based Report Manager
- Using SQL Server Management Studio-based Reporting Services Manager
- Reporting Services Security
- Two Parts to Reporting Services Security
- Securing Access to Reports
- Data Source Security
- Programming Reporting Services
- The Many Reporting Services APIs
- Integrating Reporting Services into Applications using URL Access
- Using the Reporting Services Web Service
- Advanced Reporting Services Programming
- Using the Reporting Services Web Service
- Working with Custom Assemblies
- Snapshots and Subscriptions
- Caching and Snapshots
- Creating Standard Subscriptions
- Creating Data-Driven Subscriptions
- Managing Subscriptions
- Ad-Hoc Reporting with Report Builder
- The Report Builder Architecture
- Creating Report Model Projects
- Running Report Builder
- Conclusion
|
| |
Java® and all Java-based marks are trademarks or registered trademarks of Sun Microsystems, Inc. in the U.S. and other countries.
|
|
Accelebrate®
Focuses on You! |
|
Accelebrate’s courses are taught for private groups of 3 or more people at your site or online anywhere worldwide.
Don't settle for a "one size fits all" public class! Have Accelebrate deliver exactly the training you want, privately at your site or online, for less than the cost of a public class.
For pricing and to learn more, please contact us via information request form or phone, or email us at info@accelebrate.com today.
|
|
| |
 Instructor and materials were well organized and prepared to thoroughly cover the appointed topics.  |
| |
—Patrick Hickey
Wonderware
Lake Forest, California |
|
|
