课程

Building and Optimizing Triggers in SQL Server

中级技能水平

更新时间 2022年2月

Learn how to design and implement triggers in SQL Server using real-world examples.

免费开始课程

SQLProgramming

4 小时

15 视频

49 练习

3,800 经验值

14,820

成就声明

深受数千家公司学习者的喜爱

Training a Team?

Try for Business

课程描述

Auditing your SQL Server database and keeping data integrity can be a challenging task for DBAs and database developers. SQL Server triggers are special types of stored procedures designed to help you achieve consistency and integrity of your database. This course will teach you how to work with triggers and use them in real-life examples. Specifically, you will learn about the use cases and limitations of triggers and get practice designing and implementing them. You will also learn to optimize triggers to fit your specific needs.

先决条件

Intermediate SQL Server

1

Introduction to Triggers

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

50 经验值

Types of trigger

50 经验值

Creating your first trigger

100 经验值

Practicing creating triggers

100 经验值

How DML triggers are used

50 经验值

When to use triggers

50 经验值

Creating a trigger to keep track of data changes

100 经验值

Trigger alternatives

50 经验值

Triggers vs. stored procedures

100 经验值

Triggers vs. computed columns

100 经验值

2

Classification of 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)

50 经验值

Tracking retired products

100 经验值

The TrackRetiredProducts trigger in action

100 经验值

Practicing with AFTER triggers

100 经验值

INSTEAD OF triggers (DML)

50 经验值

Preventing changes to orders

100 经验值

PreventOrdersUpdate in action

50 经验值

Creating the PreventNewDiscounts trigger

100 经验值

DDL triggers

50 经验值

Tracking table changes

100 经验值

Using FOR in a trigger

50 经验值

Preventing table deletion

100 经验值

Logon triggers

50 经验值

Enhancing database security

100 经验值

Defining a logon trigger

50 经验值

3

Trigger Limitations and Use Cases

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

50 经验值

Trigger limitations

50 经验值

Creating a report on existing triggers

100 经验值

Use cases for AFTER triggers (DML)

50 经验值

Keeping a history of row changes

100 经验值

Table auditing using triggers

100 经验值

Use cases for INSTEAD OF triggers (DML)

50 经验值

Preventing changes to Products

100 经验值

Checking stock before placing orders

100 经验值

Use cases for DDL triggers

50 经验值

Database auditing

100 经验值

Preventing server changes

100 经验值

4

Trigger Optimization and Management

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

50 经验值

Removing unwanted triggers

100 经验值

Modifying a trigger's definition

100 经验值

Disabling a trigger

100 经验值

Re-enabling a disabled trigger

100 经验值

Trigger management

50 经验值

Managing existing triggers

100 经验值

Counting the AFTER triggers

50 经验值

Troubleshooting triggers

50 经验值

Keeping track of trigger executions

100 经验值

Identifying problematic triggers

100 经验值

Wrapping up

50 经验值

Building and Optimizing Triggers in SQL Server

课程完成

获得成就证明

将此证书添加到你的 LinkedIn 档案、简历或履历中
在社交媒体和绩效评估中分享立即注册

加入超过19百万学习者，今天就开始Building and Optimizing Triggers in SQL Server！

通过 DataCamp for Mobile 提升您的数据技能

随时随地通过我们的移动课程和每日 5 分钟编程挑战提升技能。