An introduction to the basic concepts of SQL Server triggers. Create your first trigger using T-SQL code. Learn how triggers are used and what alternatives exist.

Introduction

Types of trigger

Creating your first trigger

Practicing creating triggers

How DML triggers are used

When to use triggers

Creating a trigger to keep track of data changes

Trigger alternatives

Triggers vs. stored procedures

Triggers vs. computed columns

Introduction to Triggers

Learn about the different types of SQL Server triggers: AFTER triggers (DML), INSTEAD OF triggers (DML), DDL triggers, and logon triggers.

AFTER triggers (DML)

Tracking retired products

The TrackRetiredProducts trigger in action

Practicing with AFTER triggers

INSTEAD OF triggers (DML)

Preventing changes to orders

PreventOrdersUpdate in action

Creating the PreventNewDiscounts trigger

DDL triggers

Tracking table changes

Using FOR in a trigger

Preventing table deletion

Logon triggers

Enhancing database security

Defining a logon trigger

Classification of Triggers

Find out known limitations of triggers, as well as common use cases for AFTER triggers (DML), INSTEAD OF triggers (DML) and DDL triggers.

Limitazioni note dei trigger

Limitazioni dei trigger

Creare un report sui trigger esistenti

Casi d’uso per i trigger AFTER (DML)

Conservare lo storico delle modifiche alle righe

Audit delle tabelle con i trigger

Casi d’uso dei trigger INSTEAD OF (DML)

Impedire modifiche a Products

Controllare lo stock prima di inserire gli ordini

Casi d’uso per i trigger DDL

Audit del database

Impedire modifiche al server

Trigger Limitations and Use Cases

Learn to delete and modify triggers. Acquaint yourself with the way trigger management is done. Learn how to investigate problematic triggers in practice.

Deleting and altering triggers

Removing unwanted triggers

Modifying a trigger's definition

Disabling a trigger

Re-enabling a disabled trigger

Trigger management

Managing existing triggers

Counting the AFTER triggers

Troubleshooting triggers

Keeping track of trigger executions

Identifying problematic triggers

Wrapping up

Trigger Optimization and Management

Discounts table

Orders table

Products table

Verificare (audit) il tuo database SQL Server e mantenere l’integrità dei dati può essere impegnativo per DBA e sviluppatori di database. I trigger di SQL Server sono tipi speciali di stored procedure pensati per aiutarti a garantire coerenza e integrità del database. In questo corso imparerai a lavorare con i trigger e a usarli in esempi pratici. In particolare, scoprirai casi d’uso e limitazioni dei trigger e farai pratica nel progettarli e implementarli. Imparerai anche a ottimizzare i trigger in base alle tue esigenze specifiche.

Intermediate SQL Server

Impara a progettare e implementare trigger in SQL Server con esempi pratici.

Creare e ottimizzare i trigger in SQL Server

Scopri come progettare e implementare trigger in SQL Server usando esempi reali.

Casi d’uso dei trigger INSTEAD OF (DML)

Create Your Free Account