MySQL & Databases Guides & Tutorials

Relational database schema design, indexing strategies, transactions, and PDO query optimization.

2 Published Articles

MySQL & Databases

Database Indexing Strategies: B-Trees, Composite Indexes & Query Plans

Understand how B-Tree indexes work under the hood, how the leftmost prefix rule governs composite indexes, and how EXPLAIN reveals bottlenecks.

By Marcus Thorne 8 min read

MySQL & Databases

Learn how to model relational data properly from day one: 1NF through 3NF, foreign key integrity constraints, and strategic index placement.

By Marcus Thorne 8 min read