TOIT Training

Facebook X-twitter Linkedin Instagram
Menu
Intermediate
SQL Server

SQL SSRS

Overview
Curriculum

 

The SQL SSRS online training course provides students with the knowledge and skills to create and run SQL reports. The course focuses on teaching individuals how to use the SQL SSRS product features and tools related to created reports, charts, dashboards, and more.

Curriculum

  • 8 Sections
  • 132 Lessons
  • 9h 5m Duration
Expand All
Preparing the Work Environment
9 Lessons
  1. SSRS Installation 
  2. SQL Server Database Engine Required 
  3. Download SSMS 
  4. Download VS Community 2019 
  5. Download SSDT SSRS Extension 
  6.  SSRS Configuration
  7. Report Server Configuration Manager 
  8.  SSRS Web Service URL
  9. Web Service API 
Web Portal URL
9 Lessons
  1. Exploring SSRS Web Portal URL
  2. New
  3. Upload 
  4. Report Manager Upload Text, PDF, and Images
  5. Manage Folder
  6. Tiles
  7. Settings 
  8. Download 
  9. Help 
 Data Sources and Datasets
15 Lessons
  1. Report Data
  2. Query types
  3. Text
  4. Table
  5. Views
  6. Stored Procedures 
  7. Reports
  8. Table
  9. Matrix
  10. List
  11. Report Add-Ins
  12. Image
  13. Textbox
  14. Rectangle
  15. Line
Report Formatting
31 Lessons
  1. Formatting Basics
  2. Table Report Groups 
  3. Matrix Report Row and Column Groups
  4. Report Totals and Subtotals 
  5. Report Headers and Footers 
  6. Report Headers 
  7. Scrolling Headers  
  8. Exporting to PDF, XML, Excel, Word
  9. Formatting Properties
  10. Properties
  11. Alignment 
  12. Border 
  13. Fill 
  14. Font 
  15. Font 
  16. Font 
  17. General 
  18. CanGrow/CanShrink 
  19. Number 
  20. Format 
  21. Position 
  22. Visibility 
  23. PageName 
  24. Filters and Sorting
  25. Filters 
  26. Tablix 
  27. Dataset 
  28. Sorting 
  29. Sorting 
  30. Tablix 
  31. Interactive
Charts and Formatting
24 Lessons
  1. Charts
  2. Column 
  3. Line
  4. Shape 
  5. Funnel 
  6. Pie 
  7. Pyramid 
  8. Tree Map
  9. Bar 
  10. Area 
  11. Range
  12. Boxplot
  13. Scatter 
  14. Bubble
  15. Polar
  16. Radar 
  17. Data Bars & Gauges
  18. Data Bars
  19. Gauges
  20. Radial
  21. Linear 
  22. Sparklines & Indicators 
  23. Sparklines
  24. Indicators  
Advanced Reports
20 Lessons
  1. Expressions
  2. Add Custom Code 
  3. Dashboards & Drill Functions
  4. Dashboards
  5. Document Map
  6. Report Drill Functions
  7. Drill Down
  8. Drill Through
  9. Matrix Drill Down
  10. Go to URL Action
  11. Page Breaks
  12. Subreports
  13. Parameters
  14. Dataset
  15. Data type
  16. Drop down
  17. Multiple Values
  18. Available Values
  19. Defualt Values
  20. Cascading
Report Manager & Deployment
16 Lessons
  1. Report Manager & Configuration Manager
  2. Configuration Manager
  3. Report Manager Title
  4. Deploy Reports
  5. Visual Studio
  6. Report Manager
  7. Report Builder
  8. Report Customization
  9. Shared Data Sources in Report Manager
  10. Shared Datasets in Report Manager
  11. Cached Reports
  12. Linked Reports
  13. Report Parts
  14. Report Snapshot
  15. Security
  16. Subscriptions
Report Builder
8 Lessons
  1. Install Report Builder
  2. Creating and Managing Reports
  3. Report Wizards
  4. Create a new Dataset using Report Builder
  5. New Table or Matrix Report using Wizard
  6. Table Report Without Wizard
  7. Pie Chart Using Wizard
  8. Bar Chart without a Wizard

Deleting Course Review

Are you sure? You can't restore this back

Course Access

This course is password protected. To access it please enter your password below:

Buy for group

SQL SSRS
No groups Found

You don't have any groups yet

Create a group and add group members. Sync Group(s)
Choose Group(s)
Sync Group(s)
    Create a new group Go to Checkout