Need more tutorials on material

I really need more tutorial on how to control and manipulate the material. Couldn't find any out there that offers the knowledge that I want. And also, is Octane really needed for those cool effects?