The Practical Guide to SQL Server Reporting Services (SSRS)

Description

This is a comprehensive tutorial that guides you, step by step, on how to create reports using SSRS.

Neither the Report Builder nor the Report Wizard is covered in this course.

The lessons in this course are designed so that each teaches only one major topic at a time. In each lesson, we will build a complete report from start to finish, and along the way, there will be several minor topics introduced, contributing to that major topic.

There will be some lessons that will take reports from a previous lesson and build on them accordingly for those topics that are being introduced.

What You Will Learn!

• How to create dynamic and visually appealing reports using Visual Studio 2019 and SQL Server 2019.
• How to install reporting services and configure the report server
• A little bit of database administration
• How to use SQL Server Management Studio to construct your queries
• How to apply basic and advanced features of SSRS
• Some best practices in report authoring
• How to create views and stored procedures
• How to apply appropriate formatting to enhance the readability of your reports
• How to export your reports
• How to deploy and manage your reports
• How to set user permissions on your reports
• How to set up subscriptions on your reports
• How to handle errors you may encounter

Who Should Attend!

• The Information Systems professional who is tasked with providing management reporting for their organization
• Software developers who are creating and maintaining applications, and who will need to create reports based on such applications
• Database developers and administrators
• Individuals with experience using relational databases such Microsoft SQL Server, MySQL or Oracle, who would like to expand their knowledge into reporting
• Those who are curious about reporting, with the drive to learn a new skill that will benefit them now or in the future

TAKE THIS COURSE