Stored Procedures are Better than Raw SQL

📝 Get my free SQL Cheat Sheets: https://www.databasestar.com/get-sql-...
🎓 Learn and become confident in SQL: 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