A great book to look at is Digital Texturing and Painting by Owen Demers. It's not software specific, and it covers a lot of information about texturing techniques, fundamentals of painting, approaches to building textures and materials, etc. Excellent book and required reading for my students.