Something that Paul from South West College has drummed into me is the need to have a knowledge of C# to get the best from Unity. I found these tutorials on Youtube via the Unity forums.
The beautiful thing about Unity 3D for me is that you can achieve so much without code. In an ideal world your artist can achieve much, your designers can achieve much and your storyboard-ists can achieve much…all before a line of code is written. In theory it allows everyone to focus on where they have strengths.