Intermediate T-SQL - Programming Triggers
- Buy now
- Learn more
- Discussions
- Introduction
- DISCLAIMER
- Introduction Video
- Lesson 01 – Types of Triggers
- Lesson 01 - Types of Triggers - Video
- Lesson 02 – Trigger Templates
- Lesson 02 - Trigger Templates Video
- Lesson 03 – Trigger Headers Templates
- Lesson 03 - Trigger Header Video
- Lesson 04 – A Simple Example
- Lesson 04 - Simple Examples Video
- Lesson 05 – AFTER Triggers
- Lesson 05 - After Triggers - Video
- Lesson 06 – INSTEAD OF Triggers
- Lesson 06 - Instead of Triggers Video
- Lesson 07 – Before INSERT Trigger Simulation
- Lesson 07 - Before INSERT Trigger Simulation Video
- Lesson 08 – Multi Trigger Sequence
- Lesson 08 - Multi Trigger Sequence Video
- Lesson 09 – Inventory Example
- Lesson 09 - Inventory Example Video
- Lesson 10 – Database and Table Triggers
- lesson 10 - Database and Table Triggers - Video
- Lesson 11 – System Level Triggers
- Lesson 11 - System Level Triggers Video
- Lesson 12 - Module Summary
- Lesson 12 - Module Summary Video
Create Database, Tables and Load Data for Examples

CREATE DATABASE FINAL-10-15-25.sql
CREATE DATABASE TABLES FINAL-10-15-2025.sql
BCP IN HOBBY_SHOP FINAL-10-15-2025.sql
HOBBY_SHOP_TABLE_BCP_IMPORT-10-31-2025.zip
CREATE INVENTORYM4 DATABASE & TABLES.sql
Module Examples

SYSTEM DIAGNOSTIC TOOLS.sql
MODULE 04 - LESSON 01 - TRIGGER TYPES.sql
MODULE 04 - LESSON 02 - TRIGGER CODING TEMPLATES.sql
MODULE 04 - LESSON 03 - TRIGGER HEADER TEMPLATES.sql
MODULE 04 - LESSON 04 - SIMPLE TRIGGER EXAMPLES.sql
MODULE 04 - LESSON 05 - AFTER TRIGGER EXAMPLES.sql
MODULE 04 - LESSON 06 - INSTEAD OF TRIGGER EXAMPLES.sql
MODULE 04 - LESSON 07 - BEFORE TRIGGER SIMULATION.sql
MODULE 04 - LESSON 08 - MULTI TRIGGER SEQUENCE EXAMPLES.sql
MODULE 04 - LESSON 09 - ENHANCED INVENTORY TRIGGER EXAMPLES FINAL.sql
MODULE 04 - LESSON 10 - DATABASE & TABLE EXAMPLES.sql
MODULE 04 - LESSON 11 - SYSTEM LOGON QUERIES.SQL
Homework

Module 4 - Triggers Homework Assignments.sql
Module 4 - Triggers Homework Assignment Templates.sql
Module 4 - Triggers Homework Solutions V2.sql
SQL Server System Diagnostic Tools for Triggers

SYSTEM DIAGNOSTIC TOOLS.sql

Module Examples

Here is all the code for the examples discussed in each lesson.

12 Lessons