Accidental DBA Series at SQLSkills website. Index All about SQL Server Indexes from Brent Ozar Find SQL fast in SQL Server Management Studio SQL Search from redgate Introduction to Query Processing and Optimization by Michael L. Rupley, Jr. Indiana University at South Bend mrupleyj@iusb.edu
Practice until you can't make it wrong.