Hey. You can check out the links for all detailed information. These are just two , you can find a few more places over Google that offer courses based on the level of expertise, prior experience and duration. You can opt for certification or diploma as per your liking .
https://www.eurochroma.com/communication/blog/career-special-effects-sfx-makeup
https://india.smamakeupacademy.com/