SQL Server Reporting Services Core Skills (1 day)
SQL Server Reporting Services is Microsoft's premier reporting tool. This course is designed to take you through the most important components of SSRS, with just the right amount of depth, within a single day.
The course is most suitable for developers that need to learn to work with the Microsoft BI platform or for existing SQL Server developers and DBAs that want to cross-train into BI work. The course can also help business analysts and project managers that need a solid understanding of the technologies involved. While not essential to complete the labs (as full detailed instructions are provided), some knowledge of T-SQL would be helpful.
In the course, you'll see how to create rich server-based reports using SQL Server Reporting Services, see how to create dynamic reports with parameters and interactivity, and how to manage the reports in terms of security and scheduling. You'll also see how end-users can build their own reports using Report Builder.
While our courses are based on SQL Server 2017, we realise that many customers are not yet running that version. Rather than provide you a course that only covers a single version of SQL Server, our courses are designed to be relevant (wherever possible) to a range of SQL Server versions including SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014 and SQL Server 2016. Where there are differences between versions, the differences are clearly highlighted.
|CITY||DATES||COURSE PRICE||EARLY BIRD PRICE|
|On-demand||Please contact us||
|DAY 1||RS201||INTRODUCING SERVER-BASED REPORTING SERVICES|
|Server-based Reporting Fundamentals|
|Common Report Items|
|LAB: Creating and Deploying Reports|
|DAY 1||RS202||WORKING WITH COMMON REPORT ELEMENTS AND CREATING DYNAMIC REPORTS|
|Additional Common Report Elements|
|Creating Dynamic Reports Using Parameters|
|Creating Dynamic Reports Through Links and Document Maps|
|LAB: Creating Dynamic Reports|
|DAY 1||RS203||MANAGING REPORT EXECUTION AND SECURITY|
|Extending Reports with Custom Logic|
|Reporting from Analysis Services|
|Optimising Report Execution|
|Securing Report Server Items and Data|
|Delivering Reports with Subscriptions|
|LAB: Managing Report Execution and Security|
|DAY 1||RS204||END-USER REPORTING WITH REPORT BUILDER|
|Introduction to Report Builder|
|Creating Map-Based Reports|
|Data-Feeds as Data Sources|
|LAB: Report Builder Self-service Reporting|