Triggers and Functions

Database professionals responsible for implementing and maintaining SQL Server 2016

Prerequisite
None

Expected Duration
115 minutes

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.

Objective

Triggers

  • 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

Functions

  • 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

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.