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! 
