LearnNowOnline

Completion of our SQL Server Developer path is recommended, but not required. You should have a basic familiarity with the concept of relational databases, as well as a basic understanding of Microsoft SQL Server and the primary tools within it including Management Studio. You should know the fundamentals of Transact-SQL to write basic queries to retrieve and update data, and how to execute scripts using the Query Editor. It would be helpful, but not absolutely necessary, to have experience with .NET development using Visual Studio 2010 or later.

SQL Server Reporting Services is part of the Microsoft suite of SQL Server Business Intelligence tools or BI Tools. In this path you will learn the fundamentals of working with SQL Server Reporting services. You will begin by exploring the reporting services architecture along with the individual components. You will move on to focus on the Report Builder, its features, the user interface, and how to use it to build some basic reports. You will see how to use the Data Tools, the Report Designer and two key report server project types. You will learn about tablix and how it is able to morph into a table, matrix, and list at your whim. You will learn the essentials of expressions, how to write and use them within reports, and about the extensive set of built-in Reporting Services functions that you can use in your own expressions. You will see how the Report Designer can be used to create an effective layout and online version to provide a level of interactivity that will make reports more useful for users.