You buy spells from shops. I believe there is only one shop that sells each spell. At the start you can only get level 1 spells in Corneria, and as you progress in towns you get access to higher tier spells.

Generally though the best spells you want are healing and nukes. Then everything else is fluff.