Database Management Systems · Query languages

Stored procedures and triggers

Code that lives inside the database itself: called on demand (procedure) or fired automatically on an event (trigger).

Also known as: stored procs, triggers, PL/SQL.

Start a lesson on Stored procedures and triggers

Learn first

• SQL filtering and projection: Picking which rows and columns you want back with SELECT and WHERE.

Related topics

• Transactions and ACID properties: The four guarantees (atomicity, consistency, isolation, durability) that make a transaction feel like one indivisible unit.