Blood Magic gets some
sort of tough attack spells before the demo ends, but that's all I can think of aside from your generic attack spells. As for less attack-y options, Earth Magic has a spell that stops enemies from moving, and one that can boost the strength of an entire bunched-together army. I think they're Enchantment.
EDIT: Oh! How could I forget! There's a nature/death (I think) spell that causes a rain of toads to fall on any province, within the demo limits. Literally, raining death!
