2015
Pluralsight
Pankaj Jain
2:45
English
In this course, we will talk extensively about Triggers. Triggers help us centralize table validations at the lowest level along with providing support for auditing and logging. We will take an in-depth look at how to define triggers, trigger types, row level and statement level triggers, and mutating triggers. We will take an in-depth look at both DML triggers as well as System triggers. We will talk about Compound Triggers and look at various scenarios where triggers can be useful.
Overview
Introduction
Why Care to Learn?
Triggers Overview
Course Overview
Prerequisites
Audience
Tools
Summary
Understanding Triggers
Module Overview
Row and Statement Triggers and Timing Points
Creating Triggers
Demo: Creating Triggers and Order of Execution
Trigger Conditions and Conditional Predicates
Demo: Trigger Conditions and Conditional Predicates
Enabling/Disabling Triggers and Trigger Dependencies
Demo:Enabling/Disabling Triggers and Trigger Dependencies
Summary
Trigger Order & Compound Triggers
Module Overview
Follows and Precedes Clauses
Demo: Follows Clause
Compound Triggers
Demo: Compound Triggers
Summary
Handling Trigger Exceptions & Avoiding Mutating Table Error
Module Overview
Exception Flow & Side Effects
Demo: Exception Flow & Side Effects
Mutating Table Error
Demo: Solving Mutating Table Error
Summary
Understanding Trigger Scope
Module Overview
System Triggers
System Trigger Events
Event Attributes
Demo: Database & Schema Triggers
Instead of Create Triggers
Demo: Instead of Create Triggers
Instead of DML Triggers
Demo: Instead of DML Triggers
Summary
Trigger Applications
Module Overview
Value-based Auditing
Demo: Value-based Auditing
Logging & Autonomous Triggers
Demo: Logging & Autonomous Triggers
Automating Maintenance Tasks
Enforcing Referential Integrity
Demo: Enforcing Referential Integrity
Publishing Information
DML Against Views
Enforcing Complex Security Checks
Enforcing Complex Check Constraints
Demo: Enforcing Complex Check Constraints
Guidelines for Trigger Usage
Summary
Download File Size:360.38 MB
|
