The invention relates to a silicon oxide-based super-hydrophobic coating and a preparation method thereof. The coating comprises a substrate. The coating is characterized in that a base film which isprepared by spherical quartz powder A and ethanol, an intermediate film which is prepared by spherical quartz powder, tetraethoxysilane, ethanol and dilute hydrochloric acid, and a surface film whichis prepared by spraying a silicon fluoride solution are coated on the substrate. The method comprises the following steps: spherical quartz powder A is dispersed in ethanol, in order to form a fluid suspension; b. a glass plate is cleaned, the glass plate is placed in mixed liquor of concentrated sulfuric acid and hydrogen peroxide for immersion, and drying is carried out in order to obtain a glass substrate; c. the glass substrate is immersed in a fluid suspension, and the glass substrate is taken out and dried in order to obtain the quartz powder base film; d. tetraethoxysilane and ethanol are mixed with stirring, and dilute hydrochloric acid is added in order to obtain silicon dioxide sol; e. spherical quartz powder B is added into silicon dioxide sol, and mixing is carried out in orderto obtain mixed liquor; f. the mixed liquor is coated on the quartz powder base film, and drying and sintering are carried out in order to obtain the intermediate film; g. a silicon fluoride solutionis sprayed on the surface of the intermediate film, and solidification is carried out in order to obtain the product. The silicon oxide-based super-hydrophobic coating is sturdy and durable with goodchemical stability, and the product can be applied to surfaces of ceramic, glass and other materials in order to perform the characteristics of pollution prevention, fingerprint prevention, oxidationresistance, hydrophobization, and the like.