Building and Optimizing Triggers in SQL Server
Learn how to design and implement triggers in SQL Server using real-world examples.
Comece O Curso Gratuitamente4 horas15 vídeos49 exercícios13.018 aprendizesDeclaração de Realização
Crie sua conta gratuita
ou
Ao continuar, você aceita nossos Termos de Uso, nossa Política de Privacidade e que seus dados são armazenados nos EUA.Treinar 2 ou mais pessoas?
Tentar DataCamp for BusinessAmado por alunos de milhares de empresas
Descrição do 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.
Treinar 2 ou mais pessoas?
Obtenha acesso à sua equipe à plataforma DataCamp completa, incluindo todos os recursos.Nas seguintes faixas
SQL Server Developer
Ir para a trilhaSQL Server para administradores de banco de dados
Ir para a trilha- 1
Introduction to Triggers
GratuitoAn 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.
Introduction50 xpTypes of trigger50 xpCreating your first trigger100 xpPracticing creating triggers100 xpHow DML triggers are used50 xpWhen to use triggers50 xpCreating a trigger to keep track of data changes100 xpTrigger alternatives50 xpTriggers vs. stored procedures100 xpTriggers vs. computed columns100 xp - 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 xpTracking retired products100 xpThe TrackRetiredProducts trigger in action100 xpPracticing with AFTER triggers100 xpINSTEAD OF triggers (DML)50 xpPreventing changes to orders100 xpPreventOrdersUpdate in action50 xpCreating the PreventNewDiscounts trigger100 xpDDL triggers50 xpTracking table changes100 xpUsing FOR in a trigger50 xpPreventing table deletion100 xpLogon triggers50 xpEnhancing database security100 xpDefining a logon trigger50 xp - 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 triggers50 xpTrigger limitations50 xpCreating a report on existing triggers100 xpUse cases for AFTER triggers (DML)50 xpKeeping a history of row changes100 xpTable auditing using triggers100 xpUse cases for INSTEAD OF triggers (DML)50 xpPreventing changes to Products100 xpChecking stock before placing orders100 xpUse cases for DDL triggers50 xpDatabase auditing100 xpPreventing server changes100 xp - 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 triggers50 xpRemoving unwanted triggers100 xpModifying a trigger's definition100 xpDisabling a trigger100 xpRe-enabling a disabled trigger100 xpTrigger management50 xpManaging existing triggers100 xpCounting the AFTER triggers50 xpTroubleshooting triggers50 xpKeeping track of trigger executions100 xpIdentifying problematic triggers100 xpWrapping up50 xp
Treinar 2 ou mais pessoas?
Obtenha acesso à sua equipe à plataforma DataCamp completa, incluindo todos os recursos.Nas seguintes faixas
SQL Server Developer
Ir para a trilhaSQL Server para administradores de banco de dados
Ir para a trilhacolaboradores
pré-requisitos
Intermediate SQL ServerFlorin Angelescu
Ver MaisDatabase Developer
O que os outros alunos têm a dizer?
Junte-se a mais de 15 milhões de alunos e comece Building and Optimizing Triggers in SQL Server hoje mesmo!
Crie sua conta gratuita
ou
Ao continuar, você aceita nossos Termos de Uso, nossa Política de Privacidade e que seus dados são armazenados nos EUA.