A comprehensive talk about database indexing fundamentals and best practices, focusing on MySQL/MariaDB. The speaker explains how B-tree indexes work, demonstrates common indexing pitfalls, and shows how to properly design indexes based on query patterns. Through live coding examples, he illustrates how to analyze query execution plans and optimize index usage for better performance.

A deep dive into dependency injection containers in Laravel and PHP, explaining how they work under the hood. The speaker demystifies 'magic' concepts like auto-wiring by building a simple DI container from scratch and explaining the recursive nature of dependency resolution. The talk focuses on making complex concepts more approachable by showing how containers use reflection to automatically resolve dependencies.