Course Details

Previous Page


Microsoft SQL Server 2014: Process Report and Create Subscriptions and Schedules


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number



Overview/Description
An important administration task for SQL Server Reporting Services is to ensure users can only access reports and parts of the reports they require. Once users have access to the reports subscriptions can be created to ensure the reports being accessed have up-to-date data, as well as the creation of schedules to process the reports at specific intervals. This course will demonstrate how to process and view reports and how to create different subscriptions and schedules. This course is one in a series of Skillsoft courses to help learners prepare for the 70-466 Implementing Data Models and Reports with Microsoft SQL Server certification exam.

Target Audience
Business intelligence developers who create reporting and analysis solutions and individuals interested in taking the Implementing Data Models and Reports with Microsoft SQL Server certification exam

Prerequisites
None

Expected Duration (hours)
1.3

Lesson Objectives

Microsoft SQL Server 2014: Process Report and Create Subscriptions and Schedules

  • start the course
  • publish reports to a Report Server
  • publish reports to a SharePoint library
  • deploy custom assemblies with reports
  • save reports using Report Builder to a report server and SharePoint library
  • find and view reports in Report Manager and a browser
  • describe what requirements need to be met before a subscription can be created, the different extensions, and their parts
  • create a standard subscription for a report in Report Manager
  • create an e-mail subscription in Report Manager
  • create a data-driven subscription in Report Manager
  • modify settings for subscriptions and delete them
  • create a schedule for a report
  • create a shared schedule for a report when Reporting Services is in Native mode
  • create a shared schedule for a report when Reporting Services is in SharePoint mode
  • manage schedules, including pausing, resuming, and changing settings
  • monitor the status of running jobs on the Report Server
  • configure security, process and view reports, manage subscriptions and schedules, and manage the Report Server
  • Course Number:
    md_idmr_a12_it_enus