You learn this song from the great Impa inside Hyrule Castle. Use it to prove your connection to the royal family of Hyrule.
Talk to Malon at the Lon-Lon ranch, and she will teach you this song. After you acquire Epona, you can use it to call for her. You can also use it to get Milk from the cows situated around in Hyrule.
Saria will teach you this song when you talk to her in the Sacred Forest Meadow. You can speak to Saria using this song, even when you are as far away as Death Mountain! It is very upbeat, and you’ll need it to cheer up a certain Goron.
Song of Storms
As an adult, talk to the man inside the Windmill of Kakariko Village. Guru Guru will teach you this song, and it is used to create storms.
This song is taught to Link by one of the Royal Composer Brothers, who used to compose music for the Royal family of Hyrule. When playing this song, you will change day into night or the other way around, night into day.
Song of Time
This song will be learned when you touch the Ocarina of Time for the very first time! Use it to open the door to the Temple of Time and later on remove various blocks that seem to create nothing but trouble.
Minuet of Forest
This is the song of the Forest Temple, and it is learned from Sheik right before entering this temple. Playing it will warp you back to the temple entrance.
Bolero of Fire
In the Death Mountain Crater just as you are about to enter the Fire Temple, Sheik will appear and teach you this song. Use it to warp back to that location at any time.
Serenade of Water
Before getting into the Water Temple, Sheik will teach you this song. When you play it you can warp back to the Water Temple.
Requiem of Spirit
Yes you guessed it. Sheik will teach you this song right before you enter the Spirit Temple, and playing it will take you right back to that temple again!
Nocturne of Shadow
Just as with all the other warp songs, this is learned right before entering a temple, and this time it is the Shadow Temple! Playing it will allow you to get there without walking an inch.
Prelude of Light
Perhaps the most beautiful song you will learn in the game. Using it will instantly transport you back to the Temple of Time.