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.

Trigger AFTER (DML)

Melacak produk yang dipensiunkan

Trigger TrackRetiredProducts dalam praktik

Berlatih dengan trigger AFTER

Trigger INSTEAD OF (DML)

Mencegah perubahan pada orders

PreventOrdersUpdate dalam aksi

Membuat trigger PreventNewDiscounts

Pemicu DDL

Melacak perubahan tabel

Menggunakan FOR dalam sebuah trigger

Mencegah penghapusan tabel

Pemicu logon

Meningkatkan keamanan basis data

Mendefinisikan 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.

Known limitations of triggers

Trigger limitations

Creating a report on existing triggers

Use cases for AFTER triggers (DML)

Keeping a history of row changes

Table auditing using triggers

Use cases for INSTEAD OF triggers (DML)

Preventing changes to Products

Checking stock before placing orders

Use cases for DDL triggers

Database auditing

Preventing server changes

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

Mengaudit database SQL Server Anda dan menjaga integritas data bisa menjadi tugas yang menantang bagi DBA dan pengembang database. Trigger SQL Server adalah jenis stored procedure khusus yang dirancang untuk membantu Anda mencapai konsistensi dan integritas database. Kursus ini akan mengajarkan cara bekerja dengan trigger dan menggunakannya dalam contoh nyata. Secara khusus, Anda akan mempelajari kasus penggunaan dan keterbatasan trigger serta berlatih merancang dan mengimplementasikannya. Anda juga akan belajar mengoptimalkan trigger agar sesuai dengan kebutuhan spesifik Anda.

Intermediate SQL Server

Pelajari cara merancang dan menerapkan trigger di SQL Server dengan contoh nyata.

Membangun dan Mengoptimalkan Trigger di SQL Server

Pelajari cara merancang dan mengimplementasikan pemicu (trigger) di SQL Server menggunakan contoh-contoh nyata.

Pengembang SQL Server

SQL Server untuk Administrator Database

Mendefinisikan logon trigger

Membangun dan Mengoptimalkan Trigger di SQL Server

Latihan interaktif praktis