Well, it depends on the procedures followed. If all the procedures are properly followed then it won’t affect the SEO rankings and other factors. But if done without proper measures, it could become a disaster for the website.
Aiming for a career as an SEO expert? Then I would recommend you to take up the SEO course from Intellipaat.
Also, do check out the YouTube tutorial video on SEO to get started.