SQL Server Reporting Services (SSRS) with Project @ SQL School

[sqlschool]

[b]SQL School[/b] offers Real-time Quality Training on SQL Server 2005 & 2008. We trust in providing quality and interactive trainings that is making us one of the pioneers in the software training market with trusted relationship with our trainees.

Course Duration for Reporting Services [SSRS] 2005 / 2008 is for 25 hours - for ONLINE Training. We discuss practical orientation of advanced concepts including [b]Email Schedules [/b]and [b]SSAS Integration[/b].

[u][b]Please get an overview of the concepts we discuss:[/b][/u]


[b]1. Introduction to Reporting Services 2005 and 2008[/b]
[list]
[*]Why Reporting Services?
Specialty of SSRS 2005 and SSRS 2008
Reporting Services Fundamentals
Reporting Services Architecture
Reporting Services Components Overview
Reporting Life Cycle

[/list]

[b]2. Authoring Reports[/b]
[list]
[*]Developing Basic Reports
Enterprise Reports
Ad Hoc Reports
Report designing tools
Structuring and Formatting
Grouping and Sorting
Expressions and Reports
Aggregations usage in SSRS
Static and Dynamic Report Parameters
Matrix Reports and Charts
Organizing data in Reports
Char Based Reports
Sub Reports and Applications

[/list]

[b]3. Dynamic Reports[/b]
[list]
[*]Conditional Formatting
Conditional Representation
Visibility and Toggles
Customizing Report Definitions
[/list]

[b]4. Managing Reporting Services[/b]
[list]
[*]Report Server Configuration
Publishing Reports
Organizing and Managing Content
Managing Report Execution
Virtual Directory Configuration Management
[b]Security Management[/b]
[b]Performance Management[/b]
[/list]

[b]5. Delivery of Reports[/b]
[list]
[*]Accessing Reports
Rendering Reports
Managing Subscriptions
Creating Reports with Report Builder
[b]Report Models[/b]
Report Builder over IIS Manager
SSRS and Excel Sources
[/list]

[b]6. Automatic Delivery of Reports[/b]
[list]
[*]Windows File Share
Email Delivery
[/list]

[b]7. SQL Server 2008 Reporting Services[/b]
[list]
[*]New Features
Differences w.r.t SSRS 2005
Deployment Changes
IIS Administration and Share point Compatibility
Performance Considerations
Scalability and Optimization Tips
[/list]

[b]8. Security Parameters and Roles[/b]
[list]
[*]Server Level Security
Report Level Security
Data Source level Security
[/list]

[b]9. Working with Analysis Services and Reporting Services[/b]
[list]
[*]Use of OLAP Databases in Reports
MDX Implementation in SSRS
WriteBacks in SSRS
Security Mechanism over OLAP
[/list]

[b]10. Best Practices and Project [/b]