Don't use the build winglord posted, that build would get you killed instantly.
If you aren't a greatclub or a main ode, you don't need to be focusing on songs. Cleric is good because it's got the highest healing output due to zeal and healing hymn. Ode is amazing, but again if you aren't a main ode type or you have low healing power don't worry about it.
You shouldn't be holding songs for long, you lose out on potential healing through vitalism. The ideal rotation is to play either attack or defense song, then immediately switch to real healing. Does it take a lot of mana? Yes but that's how cleric is played correctly. There's very few people that can sit there and hold songs due to high healing power.
For a beginner use this build.
http://archeagedatabase.net/us/calc/495707
You need shrug it off in order to avoid being stunned, or get out of being sucked into a bunch of mages. If you're meditating in the middle of a raid, you're doing it wrong, learning how to use pots on cooldown is the very first step.
As for songcraft, hold the note is a wasted skill, because of what I explained above. The idea is if multiple clerics are weaving songs, no song should ever be dropped. If you're alone in a raid or small scale, same principle applies. Play song, heal, play song.
There's more that I'm sure needs explaining, so if you have questions let me know.