Suspension of Services

The Department of Enterprise Services will suspend certain services starting July 1 in the unlikely event the Legislature does not enact state budgets before July 1. View more information...

Class / Schedule

Information Technology

SQL Level 2: Stored Procedures and More (2 Days)

01-04-T830
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
        Lacey SPSCC - LACEY
        4220 6th Ave SE Bldg. 1
        Lacey, WA 98503
        • Aug 2 2017 8:00am-4:30pm
        • Aug 3 2017 8:00am-4:30pm
        $595.00 Sun, 07/16/2017 - 17:00 Jim Parshall