How do I overcome the fear of failure?

Set the right goal. Set realistic goals that you can reach, make sure you have enough support from others so that you can overcome your fear and get opportunities to proof to yourself that you can succeed, too.