Saltar al contenido principal

Curso

Building and Optimizing Triggers in SQL Server

IntermedioNivel de habilidad

Actualizado 2/2022

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

Comienza El Curso Gratis

Incluido conPremium or Teams

SQLProgramming4 h15 vídeos49 Ejercicios3,800 XP13,723Certificado de logros

Crea Tu Cuenta Gratuita

o

Al continuar, aceptas nuestros Términos de uso, nuestra Política de privacidad y que tus datos se almacenan en los EE. UU.

¿Entrenar a 2 o más personas?

Probar DataCamp for Business

Preferido por estudiantes en miles de empresas

Descripción del curso

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.

Prerrequisitos

Intermediate SQL Server

1

Introduction to Triggers

Iniciar Capítulo

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

2

Classification of Triggers

Iniciar Capítulo

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

3

Trigger Limitations and Use Cases

Iniciar Capítulo

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

4

Trigger Optimization and Management

Iniciar Capítulo

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

Building and Optimizing Triggers in SQL Server

Curso
Completo

Obtener certificado de logros

Añade esta credencial a tu perfil, currículum vitae o CV de LinkedIn
Compártelo en las redes sociales y en tu evaluación de desempeño

Incluido conPremium or Teams

Inscríbete Ahora

Únete a más 17 millones de estudiantes y empezar Building and Optimizing Triggers in SQL Server hoy

Crea Tu Cuenta Gratuita

o

Al continuar, aceptas nuestros Términos de uso, nuestra Política de privacidad y que tus datos se almacenan en los EE. UU.