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.

        Virtually Led Trainings: If you’re registering for a virtual training, the classroom link and materials will be sent to you separately within 1-2 business days before the scheduled class date.

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

        Virtual Training
        • Mar 30 2021 8:00am-4:30pm
        • Mar 31 2021 8:00am-4:30pm
        $595.00 Thu, 03/11/2021 - 16:00 Bernie Benson