Triggers and Functions


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description
Triggers in SQL Server 2016 are sets of statements that execute automatically when a specific event occurs in a database. This course covers the design and implementation of the various types of triggers found in SQL Server 2016. In addition, this course cover functions, including scalar-valued, table-valued, deterministic, and nondeterministic. This course is one of a series of courses that cover the objectives for 70-762: Developing SQL Databases exam.

Target Audience
Database professionals responsible for implementing and maintaining SQL Server 2016

Prerequisites
None

Expected Duration (hours)
1.9

Lesson Objectives

Triggers and Functions

  • start the course
  • create DML triggers
  • create CLR triggers
  • recognize best practices regarding DML trigger security
  • implement DDL triggers
  • gather information regarding DDL triggers
  • describe DDL events and event groups
  • recognize when to use the various types of triggers
  • implement first and last triggers
  • manage transactions within a logon trigger
  • disable logon triggers
  • demonstrate how to use the AFTER trigger
  • demonstrate how to use the INSTEAD trigger
  • describe user-defined functions
  • recognize the various components of user-defined functions
  • use scalar-valued functions
  • use table-valued functions
  • use built-in functions
  • use deterministic functions
  • use nondeterministic functions
  • configure triggers in SQL Server 2016

    • Course Number:
    df_sqld_a05_it_enus

    Expertise Level
    Expert