AI engineering glossary · SQL databases
What is stored procedure?
Stored procedure: A named block of SQL and control logic saved inside the database and run by calling it. It centralises rules, reduces network round trips and can restrict direct table access.
Stored procedure: an example
CALL apply_monthly_interest(); runs a saved routine that updates all savings accounts.
Related terms
- Trigger
- Transaction
- SQL injection
More SQL databases terms
Where you learn it
Stored procedure is part of the AI Engineering Program, which teaches it with notes, a hands-on lab and an exam. The first lesson is free.