Skip to main content

IT Courses – Microsoft SQL Server 2016 and 2017 Reporting Services

This course provides concise coverage of the subject matter, including hands-on exercises which enable delegates to gain confidence quickly in using Reporting Services.

Book Now

Course Summary

Subject Area: IT, Digital Skills and Computer Science
Adult and Community
Location: Ilkeston
Full Time or Part Time: PT
Level: 2
Number Of Years:
Interview Required?: N
Weeks:
Hours: 21.00
Start: Flexible
Days/Times:
Tuition: £1050
Ilkeston

Apply now at: https://www.derby-college.ac.uk/course/it-courses-microsoft-sql-server-2016-and-2017-reporting-services
QR Code

Course Information for Students

This course provides concise coverage of the subject matter, including hands-on exercises which enable delegates to gain confidence quickly in
using Reporting Services. On the first two days you will become familiar with the development tools used to create and author reports, enabling you to design basic and then more complex reports. We cover all of the data regions used in report design as well as various interactive features and the implementation and use of report parameters.

Day 3 focuses on advanced report design concepts, such as ways of making reports truly dynamic and professional, as well as the implementation of mobile reports and KPIs. On the final day, we deal more specifically with the role of the Report Server itself, so you will learn how to deploy reports to a Report Server, manage Report Server content, handle subscriptions, and control access to reports.

Delegates should ideally be familiar with basic programming concepts and understand the fundamental design of relational databases and data
normalisation. Some prior working knowledge of SQL Server 2017 (or the previous version), and the use of SQL Server Management Studio, is assumed. In addition, you should be familiar with the SQL query language: our Microsoft SQL Server 2016 and 2017 Querying Data for Report Developers course would be an ideal primer.

• Understand the Reporting Services architecture and report lifecycle

• Create and edit reports using tables, matrices and lists

• Use expressions to enhance report capabilities

• Enhance reports by implementing interactive features

• Incorporate charts, indicators and other graphical features into reports

• Work with data sources and datasets

• Understand advanced report design concepts

• Implement mobile reports and KPIs

• Set up report publishing and execution settings

• Manage Report Server content with the Reporting Services web portal

• Distribute reports with subscriptions

• Secure Report Server resources

For more information contact the Roundhouse Thinking team on 01332 836 638 or enquiries@roundhousethinking.co.uk

Course Information for Employers

If you are an employer and would like to know more about the apprenticeships and professional training we deliver or how you can get involved in co-creating and co-delivering curriculum, please contact us via email on businessenquiries@derby-college.ac.uk, call us on 01332 387 421 or visit our employer pages here.

Career Information

Sorry - no lmi data
More Careers Information at: https://www.derby-college.ac.uk/career-pathways
QR Code

DCG Success Stories

Discover how our students have achieved success. Their hard work and dedication to learning has enabled them to succeed in rewarding careers or progress onto higher education.

role model

We encourage progress and aspirational outcomes by guiding people onto learning pathways that lead to positive destinations. Our students have gone on to achieve great things since leaving the College. We would like to share some of their inspiring success stories with you.

View Role Models

online application form

Get Started...

Check availibility and book now on this course.

Book Now

Course Information Last Updated On: November 22, 2021 3:57 pm