SQL Server Reporting Services Part 2 (SSRS)
What you'll learn
- At the end of this course, the student will be able to understand how to configure, design, manage and deploy SSRS report to the Web Portal for users to view reports. He will be versed in managing and configuring the Report Builder for end users, design and create technically advanced Mobile Reports Publisher and initiate the security measures needed to secure the SSRS environment and much more
Course content
- Preview14:41
- 07:05INSTALLING DATA TOOLS
- 05:29INSTALLING DATA TOOLS PART 2
- 10:00REPORT SERVER CONFIGURATION PART 1
- 10:23REPORT SERVER CONFIGURATION PART 2
- 08:52WHAT ARE THE SSRS DATABASES
- 13:00USING THE WEB PORTAL TO VIEW REPORTS PART 1
- 13:07USING THE WEB PORTAL TO VIEW REPORTS PART 2
- 11:28FOLDER MANAGEMENT
- 12:00SSRS SECURITY PART 1
- 12:43SSRS SECURITY PART 2
- 07:05CREATING YOUR OWN ROLE
- 05:16SYSTEM ADMIN AND SYSTEM USER ACCOUNTS
- 10:00SUBSCRIPTION PART 1
- 10:04SUBSCRIPTION PART 2
- 15:38DEPLOY SUBSCRIPTION
- 09:27BACKUP REPORTSERVER
- 14:53REPORT BUILDER DOWNLOAD
- 09:41REPORT BUILDER USING WIZARD
- 06:01REPORT BUILDER FROM SCRATCH
- 19:23WHAT ARE KPIS?
- 06:27KPI CACHING
- 02:43KPI: VIEWING A JOB
- 10:00SQL SSRS MOBILE REPORT PART 1
- 12:42SQL SSRS MOBILE REPORT PART 2
- 07:30REAL LIFE DEMO
- 10:00FROM DATA TO MOBILE PUBLISHER PART 1
- 17:08FROM DATA TO MOBILE PUBLISHER PART 2
- 15:00IMPORTING DATA FROM ACCESS DATABASE PART 1
- 12:08IMPORTING DATA FROM ACCESS DATABASE PART 2
- 17:55CREATING A MOBILE REPORT
- 10:00CREATING A PAGINATED REPORT FROM SCRATCH PART 1
- 11:36CREATING A PAGINATED REPORT FROM SCRATCH PART 2
- 18:00CREATE A REPORT FOR USA UNIVERSITY PART 1
- 18:41CREATE A REPORT FOR USA UNIVERSITY PART 2
Requirements
- It is highly recommended that the student take SSRS part 1 and SSIS before taking this course as it is built upon those two courses. Additionally, it is suggested to take Learn T-SQL, SQL admin part 1, 2, 3 as those courses build the foundation to SQL Server administration. All software and appropriate SQL scripts and documents will be provided by the instructor via zip file to emails that request the files
Description
The following course SQL Server Reporting Services (SSRS) part 2 is designed for those individual that are in the IT industry, SQL DBAs, developers, or want to learn how to design, manage, and deploy rich interactive reports for their business needs. This course is a follow up course to SQL Server Reporting Services (SSRS part 1), which is a requisite along with SQL Server Integration Services (SSIS) course. The student at the end of this course will be able to deploy SSSR reports to the web portal for end users to view and interact with, build the easy to use report builder for the non techie individuals in the company to interact with, create and design complicated mobile reports that can be viewed not only on the PC computer but also on tablets and the phone.
Who this course is for:
- This course is designed for SQL dbas, developers, IT professionals, and anyone who want to learn how to configure, design manage, deploy and secure an SSRS reporting environment. It is built upon SSRS part 1 course, which is a pre requisite to this course. It is highly recommended that the student take both SSRS part 1 and SSIS course before embarking on this course.
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.