Training Course:SQL Server 2005 Reporting ServicesSchool/Trainer:Hands On Technology Transfer, Inc.
Boise, Cincinnati, Cleveland, Kansas City, Memphis, Milwaukee, Minneapolis, Oklahoma City, Omaha, etc., United States
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' Students Will Learn:Rendering Reports in Multiple Formats
Managing Security of Reports and Report Models
Automating the Creation and Delivery of Reports
Generating Reports
Creating Report Models
Customizing Reports
Description: This three-day hands-on course thoroughly covers Microsoft’s SQL Server 2005 Reporting Services utility. It begins with an overview of the Reporting Services architecture, and then it walks students through creating reports of all types. This includes parameter reports, drill-through reports, matrix reports (pivot tables) and linked reports. It also covers how to create Report Models, which allow end users to create their own ad-hoc reports. The security model of Reporting Services is reviewed, as well as how to schedule the automatic generation and distribution of reports. Finally, writing code to fully customize reports and their generation is discussed.
Students who are also interested in other Business Intelligence Services including Integration Services (SSIS), Analysis Services (SSAS), and Notification Services along with Reporting Services should take the 5-day SQL Server 2005 Business Intelligence Application Development course instead of this course.
Prerequisites: Familiarity with database concepts and Windows desktop navigation. Attendance at HOTT’s 3-day SQL Programming course, or equivalent knowledge, is helpful but not required.
SQL Server 2005 Reporting Services Course Overview:
Reporting Services Architecture
Report Server Components Defined
Review of the Report Server Databases
Reporting Services Web Service Interface
Report Lifecycle Step by Step
Creating Basic Reports
Creating Table Reports
Formatting Options
Adding Headers and Footers
Using Subtotals and Formulas
Using Charts
Working with Lists
Paging and Sorting
Managing Data Sources
Advanced Report Features
Creating Parameter Reports
Using Cascading and Multi-Select Parameters
Drill-through Reports
Linked Reports and Subreports
Adding Report Maps
Setting Report Links
Matrix Reports
Creating Matrix Reports
Adding Data Regions
Grouping and Sorting on Columns
Adding Subtotals to Matrix Reports
Implementing Report Models
Creating Report Models
Adding Subtotals and Formulas
Managing Data Sources
Publishing Report Models
Report Builder Utility
Accessing Report Models
Using the Report Builder
Filtering Data
Adding Expressions
Building a Chart Report
Reporting Services Security
Setting up Folders for Users
Setting Permissions
Creating Custom Security Roles
Securing Report Models
Automating Report Creation and Delivery
Creating Snapshot Reports
Storing Report Histories
Using Report Caching
Creating Report Subscriptions
Rending Reports in Excel, XML or PDF
Adding Custom Code
Querying the Report Server
Creating Custom Data Extensions
Creating Command Objects
Creating Data Reader Objects
Generating Report Definition Language
.NET Integration with Reporting Services
Writing User-Defined Functions
Report Functions
Using Custom Functions
Referencing .NET Libraries
Creating and Building Libraries
Managing Report Servers from .NET Applications
Accessing SSRS from .NET Applications
Retrieving Report Items
Listing Report Metadata
Using the ReportViewer Control in .NET Applications
...''
Please go to the school's official website for training price and schedule:
http://www.traininghott.com/
Phone:1-800-413-0939
School Address:
Hands On Technology Transfer, Inc.
14 Fletcher Street
One Village Square, Suite 8
Chelmsford, MA 01824 USA
Jobs & Resumes: Boise, Cincinnati, Cleveland, Kansas City, Memphis, Milwaukee, Minneapolis, Oklahoma City, Omaha
Houses & Roommates: Boise, Cincinnati, Cleveland, Kansas City, Memphis, Milwaukee, Minneapolis, Oklahoma City, Omaha
Other training courses offered by Hands On Technology Transfer, Inc.:
Visual Basic.NET 2.0 Programming for Windows Applications
Windows Applications Programming for Experienced Visual Basic.NET Programmers
ASP.NET 2.0 Programming for Experienced C# Programmers
ASP.NET 2.0 Programming for Experienced Visual Basic.NET Programmers
Advanced C# Programming with the .NET 2.0 Framework
Advanced Visual Basic.NET Programming with the .NET 2.0 Framework
SQL Programming
Relational Database Design Concepts
Microsoft SQL Server 2005 Administration
Microsoft SQL Server 2005 Database Developer
SQL Server 2005 Business Intelligence Application Development
SQL Server 2005 Business Intelligence: Integration Services and Analysis Services
Windows 2003 Server and XP Administration
Windows Server 2003 Active Directory and Security Design
MCSE 2003 Certification
MCSA 2003
MCDBA
MCTS: SQL Server 2005 Certification
MCITP: Database Administrator
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Facts:
We provide free training course catalog service since 2003, in English and Chinese. Tens of thousands of visitors search our database from our portal and partners' websites each day. |
|
|
