Many-body physics and non-equilibrium dynamics in ultracold atomic systems