Thick fully-depleted charge-coupled devices (CCDs) with high-resistivity silicon are used in a wide range of scientific applications, from particle detection to astronomical imaging. Their low noise and high charge collection efficiency allow us to reach unprecedented sensitivity to physical processes with low-energy transfers. The newly-developed Skipper-CCD enhances this sensitivity by reducing the read-out noise reaching a sub-electron resolution. In this work, we summarize the fundamentals of the skipper-CCD operation and the prospects for both sub-GeV dark-matter searches and the detection of coherent elastic neutrino-nucleus scattering. A brief discussion of the challenges associated with the construction of the foreseen detectors with multi-kilogram target mass is also presented.