Building and Optimizing Triggers in SQL Server

Description

In this course, you will learn :

• An overview of the fundamental concepts of SQL Server triggers. Use T-SQL code to create your first trigger.
• Discover how triggers are used and what alternatives are available.
• Learn about SQL Server triggers, including AFTER triggers (DML), INSTEAD OF triggers (DML), DDL triggers, and logon triggers.
• Learn how to delete and edit triggers. Familiarize yourself with the trigger management process.
• In practise, learn how to investigate problematic triggers.

Syllabus :

• Introduction to Triggers
• Classification of Triggers
• Trigger Limitations and Use Cases
• Trigger Optimization and Management