http://www.willgoldstone.com/tutorialdemo/menu.html
This will give you the basics of how to do something in UNity like a fps
Then you gotta pick a script language: whatever works for you!; there are thousands of resources on the wiki made by Unity users in JS, and as far as it goes for C#, you can get very good tutorials/dvd that will teach you the basics to use Unity:
Loops
Variables and constant
Data types
data manipulation and conversion between types
decisional cycles (IF Then Else; Case Switch)
That’s the basic; AFAIK there is not more to learn when using Unity, since many operations are already coded in teh engine, so you simply have to look in teh manual for the section that has what you need, and find the syntax to do what you need
is easier to do than to explain 
You can find a lot of models online for free, to train yourself with Unity; plus the tutorials on the site are pretty good, if you resist the initial feeling of “how did he do that?”
As far as game design goes…is like an instrument player that wanna compose music too…either you have the inspiration or you don’t have it; in the second case you can always make a FPs or a racing game and you resolve the design problem and have fun making a game 
Then here on teh forum you will find a bunch of very knowledgeable users that will help you for sure, if you make a specific request (that is not like " i wanna make HL2, can you help me? ), like how to resolve a specific problem, or how to make a specific routine, etc.
Hope that this helps! it took me a lot of time to get a hold of the code part, and now i am able to move around with less frustration 
The manual of the Unity API is your friend…always!