SQL Server Reporting Services Part 1 (SSRS)
What you'll learn
- Install SQL Server 2016, Microsoft Visual Studio 2015, create from scratch simple to complex reports that allow the upper management and end users to make important business decisions based on the reports generated
Course content
- Preview06:37
- Preview08:24
- 13:49Download site for SQL 2016 Server
- 01:12Correction of next Video
- 08:28Download and install SQL Server Data Tools
- 12:19Download and attach database AdverntureWorks2016
- 19:22Creating a first simple SSRS report
- 18:37The basics of formatting a simple report
- 15:43Freezing the header columns of report
- 10:29Creating a table using the table item object part 1
- 10:21Creating a table using the table item object part 2
- 17:12Create a Header and a Footer
- 14:37How to group columns and use drill down
- 13:08Grouping and creating subtotal and totals
- 04:52Creating Grand Totals for numbers
- 13:13Creating multiple drill down on columns part 1
- 07:34Creating multiple drill down on columns part 2
- 09:15Importing images
- 09:22What is a matrix report
- 12:09Creating charts
- 13:16What are indicators
- 16:01Using and creating a powerful list report
- 09:03What are parameters
- 19:53Creating a parameter
- 10:01Creating a cascading parameter part 1
- 10:59Creating a cascading parameter part 2
- 11:50Using conditional formatting on a report
- 10:00Creating and using templates
- 10:08Creating and using templates part 2
- 14:41Creating sub reports
- 05:15Creating an embedded sub report
- 05:53What is the benefit of a bookmark
Requirements
- All material, applications, documents, SQL scripts will be provided by the instructor via a zip file that is requested. Student need to take Learn T-SQL course before taking this course (and or SQL Admin part 1, 2, 3 not mandatory but helpful)
Description
After completing this course, the student will be able to install SQL Server 2016, install Microsoft Visual Studio and create from scratch reports from simple to complex reports that aid in upper management in making important business decisions; and at the same time, aid the end user to view, interact with, and distribute reports in various platforms. He will be versed in creating, formatting, designing, and submitting reports that the users will benefit from each business day. The student will learn how to navigate through Microsoft visual Studio, learn how to to save .rdl files, create templates, render reports in various format, apply different methods of creating rich reports, help the end user with avoiding redundant input of data, examine ways to insure end user has aggregates for reports and be able to communicate the needs of the company via reports. This knowledge will make the student become well versed in the ability to help the organization in moving forward with summary visual data.
Who this course is for:
- Any student that want to learn about creating, configuring, and managing reports for their business needs and those responsible for creating reports for upper management that make important business decisions
- Any student that want to learn about creating, configuring, and managing reports for their business needs and those responsible for creating reports for upper management that make important business decisions. Students will need Learn T-SQL course created by me to help understand the T-SQL scripts created for each report.
Instructor
![Raphael Asghar](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.5 Instructor Rating
- 18,216 Reviews
- 110,366 Students
- 25 Courses
Worked as a Production SQL Database Administrator and developer for over 15 years for various companies such as Neutrogena, BakeMark, Solutions2Go and NextGen. Want to help those students that want more that the basic SQL Language. Creating real life courses for those students who want a simple path to becoming a SQL DBA. I love SQL Administration and all that is involved in managing and creating a stable SQL architecture environment. I want to pass that experience and information to my students.