Stored Procedures are Better than Raw SQL
Автор: Database Star
Загружено: 2022-05-03
Просмотров: 8302
📝 Get my free SQL Cheat Sheets: https://databasestar.mykajabi.com/lpk...
🎓 Master SQL Fundamentals: https://databasestar.mykajabi.com/sql...
Using stored procedures for your SQL operations is better than putting SQL in your application code.
That may seem like a bold claim, but I explain why in this video.
In this video, you’ll learn a few reasons why I think stored procedures are useful. You’ll also learn a few disadvantages of using stored procedures, a couple of which can be overcome.
This concept is relevant regardless of which database vendor you work on.
Of course, you are welcome to disagree with this video!
Let me know in the comments below whether you agree or disagree with this claim!
Timestamps:
00:00 Using SQL in application code
01:12 More business logic
02:31 Business logic in one place
03:09 Helpful for other systems
04:08 Simplify application code
04:54 Disadvantage: version control
05:59 Disadvantage: convincing your team
06:22 Disadvantage: vendor lock-in
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
