SQL Server 2008 Reporting Services Overview
In this 3-day hands-on course, you will learn how to use
SQL Server 2008 Reporting Services to create, execute, and manage reports. You will
learn how to create tabular, matrix (cross-tab), and chart reports using Visual
Studio 2008 and SQL Server 2008 Business Intelligence Studio. You'll explore creating
reports with groups, expressions, conditional formatting, and parameters. The reports
you create in the course will employ shared data sources, interactive sorting, and
drill-down capabilities. You'll explore the deployment and printing of reports and
the export of reports to PDF, Excel, and other formats. You'll gain a thorough understanding
of Reporting Services security, report snapshots, subscriptions, and the use of
custom assemblies. You'll also discover how to integrate reports into your ASP.NET Web Forms, ASP.NET MVC
and WinForms applications using URL access and the Reporting Services Web Service
API. Finally, you'll learn how
to empower your users to create ad-hoc reports using Report Builder and Report Model
projects.
Note: Class can be customized to SSRS 2008 or SSRS 2008 R2. We can even teach SSRS 2005, if you prefer.
Format
3-day lecture with hands-on labs.
Schedule of Public Classes
Sign Up Now!
Cost
$1395. (3 days)
Who Should Attend
Any programmer, power user, database professional, or data base administrator who
wishes to learn just about everything there is to learn about SQL Server 2008 Reporting
Services.
Prerequisites:
- Familiarity with databases and the SQL language.
- Knowledge of SQL Server helpful but not required.
- Knowledge of Visual Studio .NET/2008 helpful but not required.
- Knowledge of C# or VB helpful but also not required.
What You'll Learn
In this course, you will learn to:
- Create complex reports employing expressions, the global collections, and conditional
formatting.
- Create reports with nested groups and multiple parameters.
- Manage reports using both the browser-based Report Manager and SQL Server Management
Studio-based Report Manager.
- Secure reports using integrated security and SSL.
- Program reports using URL Access, the Reporting Services Web Service API, the Report
Viewer controls, and custom assemblies.
- Employ report caching and create report snapshots.
- Create standard and data-driven report subscriptions.
- Empower users to create ad-hoc reports using Report Builder and the models you create
using Report Model projects.
- And lots more...
Syllabus available upon request.
If you need more information by phone, please call Deep Training at 206-282-5096 or send
email.
|