Deviantart is a site of contrasts. You find a lot of crap there, but there’s also a lot of very inspiring artwork, and a lot of talented artists. There’s also a lot of useful resources.
This tutorial is one of those: Tutorial for CG Shading in Photoshop by iruka-loves-kakashi