Ab-initio Electronic and Optical Properties of Low Dimensional Systems: from Single Particle to Many Body Approaches