https://www.wingfox.com/c/8421_510_4660
This tutorial will give you a great overall cover of the techniques used to design and create an environment.
You will learn :
-Reference&Sketching
-Modeling&Animation
-Texturing,lighting and rendering
-Painting in PS
-3D Projection