Library PHP Tek 2026 Advanced SQL: The Features You’ve Been Ignoring (But Shouldn’t)
PHP Tek TV

Log in to watch this talk

You need to be logged in to access this video. If you don't have an account, purchase a virtual pass for the latest php[tek] conference to get access to the full video library.

Advanced SQL: The Features You’ve Been Ignoring (But Shouldn’t)

Scott Keck-Warren Scott Keck-Warren PHP Tek 2026 Intermediate (some prior knowledge necessary) Standard (50 minutes)

While your app sleeps, your database dreams... of being useful. This talk pulls back the curtain on powerful, often-ignored features hiding inside every relational database: triggers that act like observers, stored procedures that encapsulate logic, views that simplify access, and replication that scales without tears. We’ll walk through real examples, why these tools matter, and how you can start using them without falling into vendor traps or overengineering doom.