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

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:00:00 - Start
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

About Great Learning:
- Great Learning is an online and hybrid learning company that offers high-quality, impactful, and industry-relevant programs to working professionals like you. These programs help you master data-driven decision-making regardless of the sector or function you work in and accelerate your career in high growth areas like Data Science, Big Data Analytics, Machine Learning, Artificial Intelligence & more.

[palakgrover]

Your explanation is very plain and I understood the difference between Before and After Insert, as an Almuni of GL, it's privilege to have mentors like you!

[artyworldh]

Ist triggers 13:16
2nd tri 20:54
31:21 third trigger
39:30 4 trigger

[ShwetaSharma-py]

very helpful video..thanks. after watching many videos.

[maniator]

Thank you so much. It would be greatful if you have explained 'before delete' and 'after delete' examples also. Anyways, You explained it in detail.

[tankokping]

Your video is very helpful, thank you so much.

[ALLINONE-fhpw]

How the trigger, set, begin, NEW Commands are differ in SQL Server, PostgreSQL and MySQL and Oracle .Pls anyone answer it and let me know.

[swetasingh]

Waooo 😍 😍
Great video 🔥🔥
Educator is so clear in his way of explanation ✊
Looking forward to more videos.

[biplovkhanal]

How to use trigger when we have to select salary between 1000 and 1200 and salary must be even ?? Should i use if condition to create statement or what??

[Jay-jvfo]

please tell me why did you write delimiter // in case of before update ? how to know at which time we should write delimiter or not /?

[sid-harthsid-harth]

Sir nice explanation....
No need to mention delimiter //?

[prashantkanaujia]

how can I run the same query on PostgreSQL?

[sunilkumarkushawaha]

How can we implement trigger on sqlalchemy. Help me bro.. thanks in advance

[itsarpana]

I am working on SQL Server and it always shows error at 'before insert' step. why is that so?? it is not allowing me to create trigger. please help