3 resources — topics Best Practices
Avoid Common but Deadly Mistakes of Database Optimization
Avoiding the Pitfalls of Database Programming
A short book on SQL indexing and query performance for developers, with examples for MySQL, PostgreSQL, Oracle, and SQL Server — and a free web edition, Use The Index, Luke.