Super solidity is a highly counter-intuitive phenomenon in which a system spontaneously breaks translational symmetry, resembling a solid, while maintaining the frictionless flow characteristic of a superfluid. While the concept of super solidity has been extensively studied and debated in the context of ^{4}He, ultracold atoms have emerged as a promising alternative platform. Particularly following the ground-breaking experiments [Phys. Rev. X 9,011051 (2019), Phys. Rev. Lett. 122, 130405 (2019), Phys. Rev. X 9, 021012 (2019) ], the dipolar Bose-Einstein condensate (dBEC) has become an exceptional testbed for exploring the fascinating properties of the super solid state. In this presentation, I will discuss the underlying mechanisms involved in the formation of the super solid state in a trapped dBEC. Furthermore, I will discuss the collective excitation spectra across the superfluid-super solid phase transition and provide examples of out-of-equilibrium dynamics in a trapped dBEC. Additionally, I will briefly talk about my ongoing research in this area, which focuses on tunneling dynamics and considers a setup of an anti-dipolar condensate.