UMSL logo

Computer Education & Training Center

SQL Reporting Services

SQL Server Reporting Services Classes

Learn to use SSRS (SQL Server Reporting Services) to create, format, and manage reports.

Introduction to SQL Server Reporting Services

(Prerequisite: Introduction to SQL or equivalent experience.) Learn to create professional-quality reports from SQL Server and other ODBC-compliant databases. Discover how to create both standard and ad-hoc reports and deliver them via print, Web, e-mail, and PDF files. Create an environment where users can design their own reports with limited database knowledge. Learn to build and format reports with headers, footers, titles, totals, and calculations. The reports you create can contain tables, charts (or both), and can drill-down to other reports for greater detail. [Course Outline]
Fee: $239

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G7809 Tues., May 9West CountyBill Barry
E8094 Mon., Aug. 14West CountyBill Barry

Intermediate SQL Server Reporting Services

(Prerequisite: Introduction to SQL Server Reporting Services and Intermediate Applications of SQL or knowledge of joins, or equivalent experience.) Create sophisticated reports that are customized for your specific needs. Learn to display multiple data sets on one report and combine graphics with and without data for visual impact. Other topics include using multi-value parameters and preparing matrix (cross-tab) reports with drill-down capabilities. Learn how to protect your data through model item security, security filters, and opaque expressions. Generate practical reports that display the information needed for decision- making. [Course Outline]
Fee: $239

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G7810 Wed., May 10West CountyBill Barry
E8095 Tues., Aug. 15West CountyBill Barry

Advanced SQL Server Reporting Services

(Prerequisite: Intermediate SQL Server Reporting Services or equivalent experience.) Learn the techniques to make your reports more flexible and efficient. Topics include creating drill-down reports to display detail, either from other reports or from charts, and using lists for flexibility in arranging data on reports. Discover how subreports can increase your efficiency by reusing code, allow you to display reports inside the current report, and enable use of multiple data sources. [Course Outline]
Fee: $239

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G7811 Thurs., May 11West CountyBill Barry
E8096 Wed., Aug. 16West CountyBill Barry

If you would like to register for a course, call (314) 984-9000 or register online.

Classes are also available in the SQL Language that cover SQL syntax and beginning through advanced commands and queries.

You may also be interested in other SQL Server classes including SQL Programming (Transact-SQL), SQL Server Integration Services, SQL Server Administration, and SQL Server Relational Database Design.