COM2038 - SQL Server Reporting Services 2016

Course Description

Report writing is one of the most important IT related jobs in an enterprise. This course is for you if you would like to master report writing/authoring using SQL Server Reporting Services. The course begins with a presentation of essential technical background, after which you will work through guided hands-on exercises. During each class meeting you will be assessed for your knowledge, competency and proficiency in installing, configuring, authoring, deploying, and managing reports.

During this course you will install and configure SQL Server 2016, configure Native Mode Reporting Services, and install sample databases which provide data for the reports. You will learn through guided hands-on exercises the basic skills necessary to administer SQL Server 2016, deploy reports to Report Server and work with Report Manager. You will learn how to author using Report Builder, deploy reports to report server, and learn how to manage and schedule reports using Report Manager.

Learner Outcomes

At the end of the course you will have gained:

• A solid understanding of how to interact with SQL Servers
• Knowledge and experience installing and configuring reporting Services
• A working knowledge of using Report Builder to author reports and deploy them to report server
• A working knowledge of Report Manager's ability to carry out administrative tasks related to all aspects of reports; creating shared data sources, folder and folder hierarchies on the report server, and report models; managing security and subscriptions; and configuring data driven subscriptions
• An understanding of how to embed report viewer controls in windows and web projects.