Good tutorials for texturing.

I am fairly new to blender (have 7 “finished” models), and was wondering what the best techniques for texturing, and any good tutorials for them.
Please note I am abysmal at 2d artistry.