So the quick answer is that there is no difference between "D" and "D major" (as a scale or chord).

I found "Music Theory for Dummies" to be a very accessible way to get me head around all the stuff about sclaes, modes, intervals and triad chords.