12. Triggers and Audit Trail - Designing Database Solutions with Microsoft SQL Server 2022

In this lesson, Joed Goh explains the use of Triggers in Microsoft SQL Server. Triggers are commonly used to maintain data integrity, control server operations, or perform auditing tasks to strictly implement business rules.
This lesson demonstrates how to create DML triggers to perform basic auditing actions on a table when DML commands such as INSERT, UPDATE, or DELETE operations are being performed.

Table of Contents:
00:00 Introduction
01:14 AFTER Trigger (INSERT)
04:45 AFTER Trigger (DELETE)
05:41 AFTER Trigger (UPDATE)
07:36 The UPDATE() Function
10:35 INSTEAD OF Trigger (DELETE)

PLAYLISTS:
Designing Database Solutions with Microsoft SQL Server 2019
   • Designing Database Solutions with Mic...  

Artificial Intelligence and Machine Learning Foundations
   • Artificial Intelligence and Machine L...  

IoT Development
   • Internet of Things  

Android App Development in Kotlin
   • Android App Development in Kotlin  

Embedded Systems using Arduino Uno
   • Embedded Systems using Arduino Uno  

Data Structures and Algorithms using C#
   • Data Structures and Algorithms