This mystical song can make cool things happen, such as making signs come
back together, making fairies appear at some place where Navi turns green,
and also at Gossip Stones.
You'll probably use it most often whenever you see a Triforce symbol on a
wall or on the ground, most memorably being in the Water Temple, where it is
used to change the water levels repeatedly throughout the temple.
The song is taught to you in Hyrule Castle by Impa, Princess Zelda's
nursemaid, in order to see the leaders of the Goron and Zora races on your
journey to collect the three Spiritual Stones.
This song allows you to summon your faithful steed, Epona. If she's already
in the general area, it will make her run to you instead. In order for this
to work. This song only works after you've saved Epona from Lon Lon Ranch.
Also, you can stand near any cow and play this song to get free milk
(assuming you have an empty bottle of course)! It's pretty handy for the
first half of the game, but after that, milk becomes obsolete.
To get this song, you have to go to Lon Lon Ranch and talk to malon in the
center of the corral. Take out your Ocarina once she asks you to sing with
her. After that, you have to complete the Epona side quest in order to be
able to summon Epona whenever you like.
This song lets you talk to Saria or Navi (same as pressing C-up) whenever
you like. So it's basically just something you can do if you're ever
confused about where to go.
Quest wise, you use this song twice in the game: To remove Darunia's
depression in order to access Dodongo's Cavern and to make Mido move out of
the way in the Lost Woods in order to get to the Forest Temple.
This song allows you to make the sun rise and set (taking you to 00:00 or
18:00 hours). This becomes very helpful for many side quests that are time
dependant.
There's two other cool things you can do with this song You can use it to
stun any undead enemies (ReDeads and Gibdos) which lasts a pretty long time
or until you harm them. The other use is to play it when you see Navi turn
green on an inconspicuous place, which sometimes has a Fairy.
This mysterious song is taught to you by the Princess Zelda who entrusts the
Ocarina of Time in your care. It's used along with the three Spiritual
Stones in order to open the Door of Time in the Temple of Time.
Though not specifically said, this song also can relocate "Time Blocks"
which are blue blocks that have the time symbol on them. In the original
version of Ocarina of Time, you are only required to do this a few times,
while in the Ocarina of Time Master Quest, you need to move Time Blocks
often to solve many complex puzzles.
This song makes it rain momentarily. You get it by talking to Guru Guru in
the Windmill in Kakariko Village. You're only required to play it once in
the game to drain the well in the center of Kakariko in order to access the
dungeon: Beneath The Well.
The only other thing worth mentioning about this song is that it can
occasionally make secret holes appear in the center of circles of stones as
well as make fairies appear in some locations where Navi turns green.
This song teleports you to the Sacred Forest Meadow near Kokiri Forest. You
learn it from Sheik as soon as you get to the entrance of the Forest Temple.
Bolero of Fire
C-down, A, C-down, A, C-right, C-down, C-right, C-down
This song teleports you to the Kakariko Graveyard and is the only way to get
to the entrance of the Shadow Temple. Sheik teaches you this song as soon as
you enter Kakariko Village after besting the Forest, Fire and Water temples.
This song teleports you to the Desert Collossus, just outside the Spirit
Temple. Sheik teaches you this song as soon as you exit the temple in order
to travel back in time and return as a child.
This song teleports you to the Temple of Time. Probably one of the most used
songs in the game, Sheik teaches it to you as soon as you return to the
Temple of Time after beating the Forest Temple.
Scarecrow's Song
This is a hidden, customizable song that allows you to summon Pierre the Scarecrow, whom you
can Hookshot/Longshot to get to secret areas. It's required to get some of the
Gold Skulltulas and Heart Pieces as well as some other secrets and shortcuts. To
learn more, check out our Scarecrow's Song guide.
Zelda's Lullaby 
Minuet of Forest 
Bolero of Fire 
Serenade of Water 
Nocturne of Shadow 
Requiem of Spirit 
Prelude of Light 
Scarecrow's Song 