It's not a question of being able to learn spells from missions in general, you can't learn the SoA ones (cesspool, tearing gust) because the mobs that use them don't actually die when you fight...