Building and Optimizing Triggers in SQL Server
Learn how to design and implement triggers in SQL Server using real-world examples.
Kurs Kostenlos Starten4 Stunden15 Videos49 Übungen13.049 LernendeLeistungsnachweis
Kostenloses Konto erstellen
oder
Durch Klick auf die Schaltfläche akzeptierst du unsere Nutzungsbedingungen, unsere Datenschutzrichtlinie und die Speicherung deiner Daten in den USA.Trainierst du 2 oder mehr?
Versuchen DataCamp for BusinessBeliebt bei Lernenden in Tausenden Unternehmen
Kursbeschreibung
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.
Trainierst du 2 oder mehr?
Verschaffen Sie Ihrem Team Zugriff auf die vollständige DataCamp-Plattform, einschließlich aller Funktionen.In den folgenden Tracks
SQL Server-Entwickler
Gehe zu TrackSQL Server für Datenbankadministratoren
Gehe zu Track- 1
Introduction to Triggers
KostenlosAn 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
Trainierst du 2 oder mehr?
Verschaffen Sie Ihrem Team Zugriff auf die vollständige DataCamp-Plattform, einschließlich aller Funktionen.In den folgenden Tracks
SQL Server-Entwickler
Gehe zu TrackSQL Server für Datenbankadministratoren
Gehe zu TrackMitwirkende
Voraussetzungen
Intermediate SQL ServerFlorin Angelescu
Mehr AnzeigenDatabase Developer
Was sagen andere Lernende?
Melden Sie sich an 15 Millionen Lernende und starten Sie Building and Optimizing Triggers in SQL Server Heute!
Kostenloses Konto erstellen
oder
Durch Klick auf die Schaltfläche akzeptierst du unsere Nutzungsbedingungen, unsere Datenschutzrichtlinie und die Speicherung deiner Daten in den USA.