Part 1 of 5 · 1 min read
Why this page comes first
In this module you will
- Explain the difference between a stored function and a stored procedure.
- Write a simple trigger that runs automatically on an INSERT or UPDATE.
- Name one real reason to put logic in the database, and one real reason not to.
- Recognize when application-layer logic is the better choice than a trigger.
Level 0's module on tiers placed business logic in the application server, not the database. This page covers the database's own way of running logic. It is honest about when that choice helps, and when it quietly causes problems later.