I also recommend Robert Czarny's "Procedural Terrains - A to Z". Has a lot on functions and acheiving materials that look good for near, mid and far use. I hear the free "Young Mountains" tutorial is also good.