Ballad of the Goddess

The "Ballad of the Goddess" is a song featured in SS undefined. The melody and lyrics of this song have been passed down for generations in Skyloft. The Ballad is heard many times throughout the game.

Skyward Sword
The "Ballad of the Goddess" is first heard sung by Zelda on the day of the Wing Ceremony, preformed on the Goddess Harp as well as sung with Hylian lyrics.

Link learns the song from the old woman in the Sealed Temple after obtaining the Goddess's Harp. The woman tells him that the lyrics of the song can be used to locate the Sacred Flames, which Link must find to strengthen his blade. Link can learn the lyrics from Gaepora, which reveal that the two large windmills in Skyloft must face the Light Tower. Link must then search for the remaining sail to activate the windmills. Once that is done, Link must play the Ballad on top of the tower to reveal a path into the Thunderhead and the Isle of Songs contained inside it.

After the end credits, Link plays the "Ballad of the Goddess" atop the Statue of the Goddess with the Goddess's Harp.

A Link Between Worlds
In, the "Ballad of the Goddess" makes a cameo appearance as one of the songs that can be played by the musicians in the Milk Bar in Kakariko Village. The "Ballad of the Goddess" can only be heard while playing Hero Mode.

English Lyrics
Oh youth, guided by the servant of the goddess, unite earth and sky, and bring light to the land.

Oh youth, show the two whirling sails the way to the Light Tower...and before you a path shall open, and a heavenly song you shall hear.

Theory

 * This relationship between the two songs may have been more than a simple aesthetic choice. Skyward Sword, the first game to feature the Ballad, is the first game chronologically in the Zelda Timeline, and the incarnation of Zelda seen in this game would go on to found the Royal Family of Hyrule as its matriarch. It is therefore logical to assume that the Ballad continued to be handed down along her line, eventually becoming the melody referred to as "Zelda's Lullaby" (though the circumstances under which the song was reversed are unclear).

Trivia

 * "Zelda's Lullaby" can be heard by playing the Ballad of the Goddess backwards, and vice versa, although the latter case is somewhat less obvious.
 * The "Ballad of the Goddess" was also featured as the 8th track on The Legend of Zelda 25th Anniversary Special Orchestra CD.