tutorials for painting textures in photoshop?

Does anyone know of any tutorials, videos, or books on learning how to paint textures for 3D models? I have Adobe CS6 Master Collection, which includes Photoshop Extended so I would like it to be specific to that but I can reapply the knowledge from another piece of software (such as Gimp) if necessary.

This book is outstanding:

http://www.amazon.com/Game-Textures-Third-Edition-Professional/dp/0240820770/ref=sr_1_1?ie=UTF8&qid=1346732870&sr=8-1&keywords=3d+game+textures

The Game Institute is rolling out a new course for game textures
using photoshop. The Instructor is very good and has worked in the
industry for some time. If you have played the Unreal series
games then you are familiar with his work. Check out the web site
for info.

http://www.gameinstitute.com

wow I didn’t even know that website existed. Thanks! I’ll definitely be getting the package for 99 USD.

Should also check out Vertex Magazine. Jam packed with free art tips.

http://www.artbypapercut.com/

I also want to learn adobe photoshop paint texture for 3D models. Many online tutorials are available on the web which you can easily learn photoshop designing with advanced tools and features. I like to learn from the video tutorials to gain knowledge about various kind of photoshop designing technology.