If your looking for a tutorial that goes deeper than the basics then I guess you are looking for one that is more or less application specific describing how the different  shader channels (color, bump, diffusion, spec color etc etc) should be textured. What app are you using?

I'm not sure though what you mean with professional texturing.. do you have an example?

www.colacola.se