Normally I'd start with google, but I'm humbly realizing that I'm completely ignorant and unqualified to establish the viability of any claims I find, so I thought I'd ask you kindly people.
I'm not a musician nor a composer. I played a beat up trumpet, poorly, in 6th grade band and put together a few lame tracks with fruity loops 15 years ago. I don't even know how to read sheet music. But music theory is interesting and I'd like to learn more, starting with a good foundation and with the eventual goal of being able to compose something decent in a DAW or MOD Tracker.
I can't carry a tune in a bucket, but I'm able to find and keep a beat, and in general can pick out and follow instruments within a song even when there's a lot happening. Those are the extent of my musical talents, such as they are.
Funds are not unlimited, but I'm willing and able to spend money towards the effort, as I would for any serious hobby or undertaking.
Where does one start? What books or other resources can you recommend?