Exciting News! Systematix is rebranding to Future Savvy. Same great services, with a fresh new look. Learn More
This 4 day course is intended for students who need to learn and understand the full reporting lifecycle of designing, managing, and accessing reports in a Microsoft SQL Server 2016 or 2017 environment. Days 1 and 2 will familiarise attendees with the Reporting Services development tools used to create and author reports, and will enable students to design initially basic, then more complex, reports. All of the data regions utilised in report design are covered here including tables, matrices, lists, and charts. Interactive features such as drilldown and drill-through reports are also covered in this section, as are the implementation and use of report parameters.
Day 3 builds upon the knowledge gained over the previous two days by covering advanced report design concepts, such as making reports more dynamic (for example, allowing users to interactively select groups for a matrix using parameters), alternating background colours for table rows, and other handy tips to enable developers to design truly professional reports. We round off the development phase of the reporting lifecycle by considering the implementation of mobile reports and KPIs. Day 4 of the course deals more specifically with the role of the Report Server itself. Here, students will learn how to deploy reports to a Report Server, manage Report Server content, handle subscriptions, and control access to reports.
Concise coverage of the subject matter is augmented with plenty of hands-on exercises to facilitate the learning process and to enable students to quickly gain confidence in using Reporting Services. Additionally, with the course structure being fully modularised, customised versions of this course can also be devised and delivered.
Prerequisites
No prior knowledge of the subject matter is assumed. However, students should ideally be familiar with basic programming concepts, and understand the fundamental design of relational databases and data normalization. Some prior working knowledge of SQL Server 2017 (or previous version), and the use of SQL Server Management Studio, is assumed. Attendees should additionally be familiar with the SQL query language, in particular the SELECT statement used for retrieving data. The course, “Microsoft SQL Server 2016 and 2017 Querying Data for Report Developers”, would be an ideal primer for anyone considering taking this course.
Course Objectives
Upon successful completion of this course, students will be able to:
We can arrange your own private Microsoft SQL Server course.
Have us build a custom private course tailored to your needs.
If you are looking to training a group of people private courses can be very cost effective.
Unlimited post course email support on the course topics.
Very good, trainer was excellent.
Really enjoyed this course. It delivered exactly what I wanted out it.
Course was well adjusted to consider the business perspective - considering commonly needed calculations, time based data analysis etc.
The trainer was a really good instructor, he took the time to help us with individual issues and also tried to cater the course to meet our collective needs.
The trainer did a fantastic job of delivering the course and providing understanding
The trainer was an amazing lecturer and the vba course was very usefull and well structured. Thank you.