Course details

Triggers and Functions

Triggers and Functions

Target Audience
Expected Duration
Lesson Objectives
Course Number
Expertise Level

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


Expected Duration (hours)

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:

    Expertise Level