Class / Schedule


Information Technology

SQL Level 2: Stored Procedures and More (2 Days) - Virtual or In-person

This course presents the rules for creating stored procedures and provides practical advice on maximizing their use. You will learn extended, system, and user-defined procedures as well as triggers. During this course you will study examples that show how stored procedures and triggers are used in the real world to implement database solutions.

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

    • View system stored procedures
    • Work with the SQL server security model
    • Use system-supplied stored procedures
    • Create custom extended stored procedures
    • Program user-defined stored procedures
    • Call stored procedures from applications
    • Handle errors
    • Work with triggers

    Competencies covered in this course: Database concepts and management

      Intended Audience: Public sector employees who are experienced database developers.

        Pre-requisites: SQL: Querying with Transact-SQL (2 Days) or equivalent knowledge.

        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
        • Oct 27 2020 8:00am-4:30pm
        • Oct 28 2020 8:00am-4:30pm
        $595.00 Thu, 10/08/2020 - 17:00 Bernie Benson
        2 Virtual

        Virtual Training
        • Nov 18 2020 8:00am-4:30pm
        • Nov 19 2020 8:00am-4:30pm
        $595.00 Sun, 11/01/2020 - 16:00 Bernie Benson