• Online, Self-Paced
Course 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 covers 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.

Learning Objectives


  • 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


Practice: Configuring Triggers

  • configure triggers in SQL Server 2016


Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.