SQL Server 2008 R2 Reporting Services
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
Course Description: This course thoroughly covers Microsoft's SQL Server Reporting Services utility, including the generation and distribution of parameter reports, drill-through reports, matrix reports (pivot tables) and linked reports. It begins with an overview of the Reporting Services architecture, and then presents the procedures for creating reports of all types. The course 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) and Analysis Services (SSAS) along with Reporting Services should take the 5-day SQL Server 2008 Business Intelligence Application Development (SSRS, SSIS, SSAS) course instead of this course.
Course Prerequisites: Familiarity with database concepts, Windows desktop navigation and software installation techniques. Attendance at HOTT's SQL Programming course or Microsoft Transact-SQL Programming course is highly recommended although not required.
SQL Server 2008 Reporting Services Course Overview:
|Reporting Services Architecture
||Creating Basic Reports
|Advanced Report Features
|Implementing Report Models
||Report Builder Utility
|Reporting Services Security
||Automating Report Creation and Delivery
|Adding Custom Code
||.NET Integration with Reporting Services
"This was a well organized course and well taught. I learned exactly what I need to begin using SSRS. This was a great course and I would highly recommend it."
M.P., Hiawatha Behavioral Health