Practice, practice, practice and a hell of a lot of reading.

Start with you basic skills in writing queries. If you don't know how to write queries well, you won't be able to tune them effectively.