A trigger is a block of SQL statements that are automatically executed whenever data in underlying table is affected by DML statements - INSERT, UPDATE or DELETE.

Triggers help in maintaining consistent, reliable, and correct data in tables. It cannot be explicitly invoked or executed, as in the case of the stored procedures.

Whenever a trigger fires in response to the INSERT, UPDATE, or DELETE statement, two special tables are created. These are the inserted and the deleted tables. They are also referred to as the magic tables. These are similar in structure to the trigger table.
The inserted table contains a copy of all records that are inserted in the trigger table.
The deleted table contains all records that have been deleted from the trigger table.
Whenever an update takes place, the trigger uses both the inserted and deleted tables.

where,WITH ENCRYPTION - Obfuscates the text of the CREATE TRIGGER statement.AFTER - fired only when all operations specified in the triggering SQL statement have executed successfully.INSTEAD OF - trigger is executed instead of the triggering SQL statement.