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

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.