I think this tutorial would be a great start, it goes from modeling 2 texturing 2 rendering, and easy to follow
http://www.3dtotal.com/team/Tutorial.../yellow_01.asp
then the Visualization Insider tutorials is also a must. It was Tailored made for everyone here at CGarchitect.com
http://www.cgarchitect.com/upclose/VI/default.asp