Implementing and Maintaining Microsoft SQL Server 2012 Reporting Services培训
About this Course
Elements of this syllabus are subject to change.
This two-day instructor-led course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution.
This course is intended for information technology (IT) professionals and developers who need to implement reporting solutions by using Microsoft SQL Server 2008 Reporting Services.
At Course Completion
After completing this course, students will be able to:
Describe SQL Server Reporting Services and its components.
Create a Reporting Services report.
Enhance a Reporting Services report.
Create and manipulate data sets.
Use report models to implement reporting for business users.
Configure report publishing and execution settings.
Implement subscriptions for reports.
Administer Reporting Services.
Implement custom Reporting Services applications.
Module 1: Introduction to Microsoft SQL Server Reporting Services
Overview of SQL Server Reporting Services
Installing Reporting Services
Reporting Services Tools
Module 2: Authoring Basic Reports
Creating a Basic Table Report
Formatting Report Pages
Module 3: Enhancing Basic Reports
Module 4: Manipulating Data Sets
Defining Report Data
Using Parameters and Filters
Using Parameter Lists
Module 5: Using Report Models
Creating Report Models
Using Report Builder
Module 6: Publishing and Executing Reports
Creating Cached Instances
Creating Snapshots and Report History
Module 7: Using Subscriptions to Distribute Reports
Introduction to Report Subscriptions
Creating Report Subscriptions
Managing Report Subscriptions
Module 8: Administering Reporting Services
Reporting Server Administration
Performance and Reliability Monitoring
Administering Report Server Databases
Upgrading to Reporting Services 2008
Module 9: Programming Reporting Services
Querying for Server Information Using a Web Service
Automating Report Management
Creating Custom Code