If you're starting with Cinema there are lots of tuts check for example
http://www.meltinglight.com

http://www.gotmyidea.com/cat/cinema-4d-video-tutorials

And a nice Matte Painting/Camera Mapping tut here

http://www.3dfluff.com/cameramapping/cameramappingtut.htm