Ab-initio electronic and optical properties of low dimensional systems: From single particle to many-body approaches