Join over 2 million IT and cyber professionals advancing their careers

Video Transcription

00:00

I welcome back to Module five sequel development. This is less than three triggers, and this lesson is going to have a few different sub lessons that linked together to create a nicely formed procedure that works off a trigger to record when an article is deleted.

00:17

And this is an example of an audit trigger that you might want to implement

00:22

when certain actions such as the leading important objects occurs because occasionally you will have users delete objects, and either they forget that they have deleted it or they don't realize that they've deleted it. And it's a good idea to have some kind of audit trails so that you can tell that it's been deleted.

00:41

Otherwise,

00:43

you may create this perception that data is just disappearing.

00:47

So with that said, let's go ahead and get started.

00:51

We're currently in sub Listen,

00:53

three point to the audit table, so first things first, we're gonna go ahead and create the audit table that will get populated when an article is deleted.

Up Next

Introduction to SQL

This introductory SQL training course teaches SQL core concepts that are applied in professional environments. Once completed with the course, students will be able to query and interact with an SQL database, and know how to design database schemas.