SQL
$1185
Per Participant
In this two-day course for students, the fundamentals of report writing using Microsoft® SQL Server® Report Builder and SSRS will once again be taught. The focus will be on producing table and matrix reports, grouping report data, formatting reports, developing simple and complex expressions, showing aggregated data, sorting and filtering data, charting data, and preparing reports for printing and exporting. Microsoft® SQL Server® versions 2014, 2012, and 2008 R2 are compatible with Report Builder 3.0.
Microtek Learning is a Microsoft Certified Partner for Learning Solutions. This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).
This module introduces the Report Builder application and its features. You will explore the Ribbon and its Tabs, Command groups, and Commands, the available Window panes for creating and manipulating reports, and the report design surface using Design and Run modes.
Lessons
Lab 1: Exploring the Report Builder Application
After completing this module, students will be able to:
This module introduces how to populate a report with data and display that data in a table data region on the report. We will begin with defining the data source and continue with query building through data sets to bring data into the report. Next, we will explore the elements of the tablix data region including rows, columns, cells, handles, and field choosers, you will use in displaying your data.
Lessons
Lab 1: Creating Table Reports
After completing this module, students will be able to:
This module introduces report formatting techniques which allow a report writer to control how and where data displays in the report. Additional data may also be required and this can be accomplished by adding data from a source or adding a calculated field to the dataset. Simple and complex epressions will also be introduced in this topic.
Lessons
Lab 1: Formatting Reports
After completing this module, students will be able to:
This module introduces data groupings in reports using dataset fields and using expressions. This module also discusses group hierarchies and adding aggregates to summarize grouped data.
Lessons
Lab 1: Creating Reports with Groups and Aggregates
After completing this module, students will be able to:
This module introduces matrix data regions which are used in reports to control how crosstabular data can be used. While table reports rely on rows and columns, matrix reports rely on row groupings, column groupings, and aggregated values.
Lessons
Lab 1: Creating Matrix Reports
After completing this module, students will be able to:
This module introduces the ability to create and add charts to reports. Whether through wizard or individual effort, chart reports or charts as report components allow us to visualize data with or without the details.
Lessons
Lab 1: Creating Charts and Chart Reports
After completing this module, students will be able to:
This module introduces report printing and exporting. Reports can be created for electronic display, paper display, or display in another application. This module covers the basics of those three scenarios.
Lessons
Lab 1: Printing and Exporting Reports
After completing this module, students will be able to:
For many years, Microtek Learning has been helping organizations, leaders, and professionals to reach their maximum performance by addressing the challenges they are facing.
I'm really impressed with the storytelling skills of the instructor. She makes the session exciting by keeping things simple and easy to understand.
Texas
I was recommended the ITIL 4 Foundation course by an IT professional who had completed the same course at Microtek Learning. The training gave me a thorough understanding of service management that I felt I could take back to my job as an IT Project Management and apply it to improve the value of products and services.
Texas
I was sceptical at first whether to enrol with Microtek Learning or not, however, I am glad that I did- I got everything that was promised (maybe more). The trainer was very patient and knowledgeable and with his effort and mine, I was able to clear the exam with ease! Keep up the good work everyone.
MARTIN
TORONTO, CANADA