While I do think that sound design is an extremely important aspect of making music, I don't think it's the first thing you should tackle as a beginner imo. Learn composition and mixing first, your amazing epic sounds won't mean shit unless you properly know how to fit them into a track first. Look at Pendulum for example, their sound design (for the most part) is relatively simple, but they mix them and make it fit in with the track extremely well. Hell, they've even used plain square waves as leads before, but it sounds amazing simply because they know how to fit it in their track. Here's a really good in-depth guide to mixing, I highly recommend that you read it: http://www.scribd.com/doc/11995844/Guide-to-Mixing
But if you really want to start with sound design, it would help if you made your request more specific, "sound design" is an incredibly broad term, narrow it down to something like "How do I make this *insert specific sound here*?" or "How does subtractive synthesis work?" or something along those lines.
Oh, and if you're going to make music solely for being "brony famous" or something along those lines, please take the time to kindly delete your DAW and not touch music ever again until you've reevaluated yourself. You should make music simply because you LIKE it (oh and if you don't make music because you like it in the first place you're probably going to quit within the first 6 months or so anyway).
And saying that you don't see anything about sound design on this forum is some bullshit because I literally see like 5 different threads on creating a specific sound in the first page of the Technique section alone. There is even a search feature at the top of the site page, use it.