I presented my talk on Advanced SQL at PHP/JS Tek 2026.

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.

Links:

• Join.d
• T-Shirt Giveaway
• Podcast
• Support Community Corner
• UnleashedPodcasts

Slides:

Follow Scott:

• LinkedIn LinkedIn
• Mastodon: @scottkeckwarren@phpc.social
• X/Twitter: @scottkeckwarren (write only)
• Twitch: @scottKeckWarren
• Community Corner Podcast
• PHPdevelopers.tv