Master the full reporting lifecycle of designing, managing, and accessing reports in a Microsoft SQL Server.
This is a hands-on course. It includes plenty of time to experiment with what you are being taught and try things out for yourself.
By the time you finish, you’ll be comfortable working independently in SSRS.
✔ A complete SSRS course that covers all of MS SQL Reporting Services.
✔ Plenty of one to one attention and time to ask questions.
✔ Friendly expert trainers, small groups and a comfortable place to learn.
✔ All the materials and extras that you’ll ever need.
✔ Ongoing support and help with issues you have after the course.
This course is in three discrete parts.
Days 1 & 2
You will become familiar with SQL Server Reporting Services’ (“SSRS”) development tools and learn to use them to create and author reports. Initially these are simple but the course soon progresses to more complex reports.
You will also learn about the data regions used in report design, 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.
You build on the knowledge gained over the previous two days by covering advanced report design concepts such as using Analysis Services as a data source, making your reports more dynamic (eg. allowing users to interactively select groups for a matrix through parameters), alternating background colours for table rows, and other handy tips to enable developers to design truly professional reports.
The last day of the course deals specifically with the role of the Report Server itself. Here, you will learn how to deploy reports to a Report Server, manage Report Server content, handle subscriptions, and control access to reports.
No prior knowledge of SSRS is required for this course.
Ideally, you should already be familiar with basic programming concepts, and understand the fundamentals of relational databases and data normalization.
Some prior working knowledge of SQL Server and the use of SQL Server Management Studio is assumed. In addition, you should be familiar with the SQL query language and, in particular, the SELECT statement used for retrieving data.
Our courses run from 9.30am to roughly 4.15pm with refreshments throughout the day and a break for lunch.
We offer a relaxed, supportive learning environment, fully air-conditioned training facilities and some of the best instructors on the planet.
Also, you’ll receive:
✔ A full-colour A4 manual covering everything in the course so that you can recap.
✔ A USB stick for the course exercises to let you practise more in your own time.
✔ A Certificate of Attendance.
To attend this MS SQL Server course online, you will need:
✔ MS SQL Server Management Studio connected to a SQL database (these can be downloaded for free from the Microsoft website) on your Windows PC/laptop with a camera, speakers & microphone
✔ A stable internet connection capable of running Zoom
✔ To be a confident computer user and able to use Zoom to attend the course
If you have access to a second screen, we would encourage you to use it as it improves the experience.