The song is the one that Picard played on the flute in the episode, "The Inner Light". This particular rendition of the same song is from the episode, "Lessons", where Picard plays a duet with Commander Darren.
This song is a rather simple melody but, incredibly beautiful and I truly love it.
It begins at approximately the 7:45 minute mark.
Enjoy.