Does anybody know any good sites or books for learning arpeggio theory.

I want to understand the theory behind songs like "Seemann" by Rammstein or "My friend of Misery" by Metallica.

-Chris