CSE Roadmap

Common tier · about 3 hours · 5 parts

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.