Query analysis techniques, execution plan reading, index strategies, partitioning patterns, and anti-pattern catalog.