arrow_back
Course Introduction
About this course
Introduction to SQL Triggers
Triggers- An Introduction
SQL Triggers
Creating a DDL trigger
Creating a DML-INSTEAD OF trigger
Creating a DML-AFTER trigger
SQL Triggers- Scripts
Managing SQL triggers
Disabling triggers
Enabling triggers
Listing all triggers
Viewing trigger definition
Removing triggers
SQL scripts
Introduction to SQL Views
SQL Views-An Introduction
System-Defined Views
System Defined Views
Catalog View
Information Schema View
Dynamic Management View
SQL scripts
User-Defined Views
User-Defined Views: Introduction
VIEW to fetch all records of a table
VIEW to filter results using WHERE clause
VIEW to fetch records from multiple tables
DML operations (Insert, Update & Delete) using User-Defined Views
SQL scripts
Managing SQL Views
Listing views & Get view definition
Removing a view
SQL scripts
Course completion
Thank You!