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
        1 Lacey

        SPSCC - LACEY
        4220 6th Ave SE Bldg. 1
        Lacey, WA 98503
        • Nov 19 2019 8:00am-4:30pm
        • Nov 20 2019 8:00am-4:30pm
        $595.00 Thu, 10/31/2019 - 17:00 Bernie Benson
        2 Lacey

        SPSCC - LACEY
        4220 6th Ave SE Bldg. 1
        Lacey, WA 98503
        • Dec 18 2019 8:00am-4:30pm
        • Dec 19 2019 8:00am-4:30pm
        $595.00 Sun, 12/01/2019 - 16:00 Bernie Benson
        3 Lacey

        SPSCC - LACEY
        4220 6th Ave SE Bldg. 1
        Lacey, WA 98503
        • Feb 20 2020 8:00am-4:30pm
        • Feb 19 2020 8:00am-4:30pm
        $595.00 Sun, 02/02/2020 - 16:00 Bernie Benson