I always have this opened in a tab:

http://wiki.lessthandot.com/index.php/Category:Microsoft_SQL...

It's not exactly a beginner's tutorial but I like it because it covers a lot of use cases. Also, it's short and to the point.

I hope you find it useful.