It's not just one opera title unfortunately. But the composer you're thinking of is Richard Wagner. I think the song you mean is "Ride of the Valkyries".