1000+ Free Courses With Free Certificates: https://www.mygreatlearning.com/acade...

Looking for a career upgrade & a better salary? We can help, Choose from our no 1 ranked top programmes. 25k+ career transitions with 400 + top corporate companies. Exclusive for working professionals: https://glacad.me/3r2d0rb

Get your free certificate of completion for the SQL for Data Science Course, Register Now: https://glacad.me/3kgKNv4

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

Visit Great Learning Academy, to get access to 300+ free courses with 1000+ hours of content on Data Science, Data Analytics, Artificial Intelligence, Big Data, Cloud, Management, Cybersecurity, Software Development and many more. These are supplemented with free projects, assignments, datasets, quizzes. You can earn a certificate of completion at the end of the course for free. https://glacad.me/3xFecTK

Get the free Great Learning App for a seamless experience, enroll for free courses and watch them offline by downloading them. https://glacad.me/3cSKlNl

About Great Learning:
Great Learning is an online and hybrid learning company that offers highquality, impactful, and industryrelevant programs to working professionals like you. These programs help you master datadriven decisionmaking 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.