DML triggers are database objects that fire on a praticular operation for a particular table.In this essential 6-part series, your instructor will provide you with a great overview of how,when, and why to use the AFTER and INSTEAD OF triggers for SQL Server.

Highlights from this series:

• What are the different types of triggers (DML vs DDL)?
• About the two types of DML triggers
• AFTER
• INSTEAD OF
  
• When will the two triggers fire?
• Similarities between Triggers and Stored Procedures
  
• Creating an audit trail trigger
• Example of when to use an AFTER trigger for a business rule
• What is a ghost/virtual delete?
• Using the UPDATE() function to audit specific info