Enterprise Services Engineering and Architectural Services is open and providing full level services for funded projects

Class / Schedule

Information Technology

SQL Server Reporting Services (3 Days)

01-04-T834
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 2012 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 2012 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 This course will help those using both SQL Server 2012 and 2008.

        Recommended Pre-requisite: SQL Fundamentals

        Scheduled Class Location and Dates
        City Facility Date and Time Course Cost Cancel Date Instructor
        Lacey SPSCC - LACEY
        4220 6th Ave SE Bldg. 1
        Lacey, WA 98503
        • Aug 9 2017 8:00am-4:30pm
        • Aug 10 2017 8:00am-4:30pm
        $595.00 Sun, 07/23/2017 - 17:00 Bernie Benson
        Lacey SPSCC - LACEY
        4220 6th Ave SE Bldg. 1
        Lacey, WA 98503
        • Oct 24 2017 8:00am-4:30pm
        • Oct 25 2017 8:00am-4:30pm
        • Oct 26 2017 8:00am-4:30pm
        $595.00 Thu, 10/05/2017 - 17:00 Bernie Benson