- [Instructor] The main reasons why your DBA…is harping on you to use stored procedures are many.…By encapsulating all of the data logic…into the stored procedures, the number of records…that are pulled from the database will be much smaller.…This is simple to think about,…but if I'm passing in account number to a balance sheet,…I'm only returning the records…for that account number as opposed to all the records…and handling that account logic in the application tier.…And what this does is reduce the overall…load on the database server.…So, in general, it's just about filtering,…but stored procedures also allow you…to grant very fine-grained access control…to applications and end users.…
A common example of this might be a business…intelligence pattern that's pretty commonly used,…where developers will build a single-stored…procedure for each report that's run.…What this does is allows fine-grained access control…to be granted for different groups of business users.…For example, a salary report might not be granted to all,…
Released
11/9/2018- Schema design
- Building good queries
- Writing stored procedures
- Building a CI/CD pipeline for database deployment
Share this video
Embed this video
Video: But you should still use SPs