For anybody that hasn’t been,
Go check out these great 3D tutorials at the Computer Arts site,everything from lighting techniques,specific software,modelling,texturing etc etc.
I love that site.

Well written tutorials.
The blender tutorials are a little on the sparse side. Oh well.