Class / Schedule


Information Technology

SQL Server Reporting Services (3 Days)

Organizations require comprehensive, highly scalable reporting solutions that will assist them in making real-time decisions across all levels of the enterprise. This course will help you design, create, view, and manage SQL Server reports. After setting a strong foundation in the basics, you’ll progressively add calculations, interactivity, queries, charts, and models to your reports. This course is taught on 2016 but is applicable to past versions of SQL.

    Performance Objectives: Upon successful completion of this course, you should be able to:

    • Explain the enterprise reporting lifecycle and architecture
    • Understand the installation process and requirements for Reporting Services
    • Create a new report using Data Tools, Visual Studio or Report Builder
    • Design a reporting structure and enhance its appearance
    • Develop expressions with calculations, functions, and variables
    • Work with parameters to add interactivity
    • Create charts and work with images and gauges
    • Add maps and spatial data types to reports
    • Develop report templates
    • Deploy to the report servers
    • Use Report Manager
    • Configure security policies for reports

    Competencies covered in this course: Prepares people to design, implement, and deliver data visualization.

      Intended Audience: Anyone responsible for creating SQL Reports with Reporting Services.

        Recommended Pre-requisite: SQL Fundamentals

        Scheduled Class Location and Dates
        City / Facility Date and Time Course Cost Cancel Date Instructor
        1 Lacey

        SPSCC - LACEY
        4220 6th Ave SE Bldg. 1
        Lacey, WA 98503
        • Mar 9 2020 8:00am-4:30pm
        • Mar 10 2020 8:00am-4:30pm
        • Mar 11 2020 8:00am-4:30pm
        $595.00 Wed, 02/19/2020 - 16:00 Jillian Bates
        2 Lacey

        SPSCC - LACEY
        4220 6th Ave SE Bldg. 1
        Lacey, WA 98503
        • Jun 8 2020 8:00am-4:30pm
        • Jun 9 2020 8:00am-4:30pm
        • Jun 10 2020 8:00am-4:30pm
        $595.00 Wed, 05/20/2020 - 17:00 Jillian Bates