Surface-enhanced Raman spectroscopy (SERS) has emerged as a powerful technique for the detection and analysis of biomolecules due to its high sensitivity and selectivity. In recent years, SERS-based sensors have received significant attention for the detection of deoxyribonucleic acid (DNA) molecules, offering promising applications in fields such as medical diagnostics, forensic analysis, and environmental monitoring. This paper provides a concise overview of the principles, advancements, and potential of SERS-based sensors for DNA detection. First, the fundamental principles of SERS are introduced, highlighting its ability to enhance the Raman scattering signal by several orders of magnitude through the interaction between target molecules with metallic nanostructures. Then, the fabrication technologies of SERS substrates tailored for DNA detection are reviewed. The performances of SERS substrates previously reported for DNA detection are compared and analyzed in terms of the limit of detection (LOD) and enhancement factor (EF) in detail, with respect to the technical parameters of Raman spectroscopy (e.g., laser wavelength and power). Additionally, strategies for functionalizing the sensor surfaces with DNA-specific capture probes or aptamers are outlined. The collected data can be of help in selecting and optimizing the most suitable fabrication technology considering nucleotide sensing applications with Raman spectroscopy.