The invention discloses a ceramic coating material with effects of environmental protection, self-cleaning property, antibacterial property and scratch resistance, wherein the ceramic coating materialcomprises a sol, water, a coloring pigment, a filler, an auxiliary agent and alkoxysilane, the sol is one or two selected from a metal oxide sol and a non-metal oxide sol, the emulsion is one or twoselected from an acrylic emulsion and an alkyd emulsion, and the auxiliary agent comprises a dispersant, an anti-settling agent, an antifoaming agent, a thickener, an antibacterial agent, an acid anda film forming auxiliary agent. The invention further discloses a preparation method of the ceramic coating material with effects of environmental protection, self-cleaning property, antibacterial property and scratch resistance. According to the present invention, the prepared ceramic coating material has the characteristics of no formaldehyde, stain resistance, high hardness, sterilization, bacterial inhibition and the like, and can be used for the coating of concrete wall surfaces, calcium silicate boards and concrete members.