Out-of-equilibrium many-body dynamics in Atomic, Molecular and Optical systems