Where's a great way to learn efficient querying?

I'm looking to write some high-performance queries and was wondering if there are any good guides out there specifically on this? Right now my SQL is sorta shotty so I think I'm doing it right, but there may be more efficient ways to do things. Thanks.