Song titles follow title case—principal words capitalized, minor words lowercase—with a few curveballs that trip up even seasoned writers. Getting it right signals professionalism; getting it wrong signals... well, that you didn't check the style guide.
Capitalize all major words: nouns, pronouns, verbs, adjectives, adverbs, and subordinating conjunctions (because, although, since). This applies regardless of the word's position in the title.
Exception to the exception: These words are capitalized if they're the first or last word of the title.
When a title appears within a sentence, style guides differ. Some maintain title case throughout; others lowercase the initial article if it's not the sentence's first word: "She sang 'the Star-Spangled Banner' beautifully." Consistency within a publication matters more than the specific choice.