Anil  Sakhiya

Anil Sakhiya

1626103802

SQL Triggers | SQL Tutorial for Beginners in 2021| SQL Triggers with Examples

In this video we discuss SQL Triggers. A SQL trigger is a database object which fires when an event occurs in a database. We can execute a SQL query that will “do something” in a database when a change occurs on a database table such as a record is inserted or updated or deleted. A trigger is a stored procedure in a database that automatically invokes whenever a special event in the database occurs. For example, a trigger can be invoked when a row is inserted into a specified table or when certain table columns are being updated.

  • 00:01:20 - Agenda
  • 00:02:01 - Introduction
  • 00:05:13 - Syntax of Trigger
  • 00:06:46 - Before Insert Trigger
  • 00:17:18 - After Insert Trigger
  • 00:28:58 - Before Update Trigger
  • 00:35:47 - After Update Trigger
  • 00:45:00 - Advantages
  • 00:45:58 - Summary

#sql #database

SQL Triggers | SQL Tutorial for Beginners in 2021| SQL Triggers with Examples