Introduction to Database Triggers with PostgreSQL

Focused View

Bluelime Learning Solutions

1:54:16

152 View

1. PostgreSQL Setup

1. Introduction.mp4

00:20

2. What is PostgreSQL.mp4

03:44

3. Installing PostgreSQL on Windows.mp4

09:53

4. Installing PostgreSQL on Macs.mp4

02:54

5. Installing PgAdmin on Macs.mp4

05:23

6. Connecting to PostgreSQL with PgAdmin.mp4

09:35

7.1 dvdrental.zip

7. Restore a sample database.mp4

11:49

8. Create a new table.mp4

06:35

9. Populate a table.mp4

08:32

10. Query Table.mp4

06:44

2. Database Triggers

1. What are Triggers.mp4

08:38

2. Creating your first trigger Part 1.mp4

11:06

3. Creating your first trigger Part 2.mp4

08:49

4. Creating your first trigger Part 3.mp4

13:48

5. Managing Triggers.mp4

06:26

Description

Automate Database Tasks Using Triggers

What You'll Learn?

Install PostgreSQL on Windows
Install PostgreSQL on Macs
Installing PgAdmin on Macs
Connect to PostgreSQL with PgAdmin
Restore a sample database
Create a new table
Populate a table
Creating a trigger
Manage Triggers

Who is this for?

Beginners to creating Triggers

More details

Description
A database trigger is procedural code that is automatically executed in response to certain events on a particular table or view in a database. The trigger is mostly used for maintaining the integrity of the information on the database. For example, when a new record (representing a new worker) is added to the employees table, new records should also be created in the tables of the taxes, vacations and salaries. Triggers can also be used to log historical data, for example to keep track of employees' previous salaries.
A PostgreSQL trigger is a function invoked automatically whenever an event associated with a table occurs. An event could be any of the following: INSERT, UPDATE, DELETE or TRUNCATE.
A trigger is a special user-defined function that binds to a table. To create a new trigger, you must define a trigger function first, and then bind this trigger function to a table. The difference between a trigger and a user-defined function is that a trigger is automatically invoked when an event occurs.
PostgreSQL provides two main types of triggers: row and statement level triggers. The differences between the two are how many times the trigger is invoked and at what time. For example, if you issue an UPDATE statement that affects 20 rows, the row level trigger will be invoked 20 times, while the statement level trigger will be invoked 1 time.
You can specify whether the trigger is invoked before or after an event. If the trigger is invoked before an event, it can skip the operation for the current row or even change the row being updated or inserted. In case the trigger is invoked after the event, all changes are available to the trigger.Â Â
Who this course is for:
Beginners to creating Triggers

User Reviews

Rating

average 0

Total votes0

Focused display

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.