This thesis addresses the many-body physics of ultra-cold bosons loaded in optical lattices. Ultracold atoms in an external trap has received most attention from both experimental and theoretical research as it is considered ...