SEO is all about marketing your online business over the globe. It is a standard set of rules to follow that search bots can understand so that whenever a customer searches for your services, the search engines can fetch your site and give it to them. It builds authority and trust among your audience while helping your business/website to get visibility among hundreds and thousands of website out there on the internet and reach out to your niche audience.
You do not require hardcore programming knowledge to do SEO. You just have to know the basics of HTML, CSS. Today, many user-friendly sites like Wordpress have been popular among the non-technical people that lets you get started with just drag and drop feature! (as mentioned in your trivia)
All you need is a good marketing knowledge that will help you analyze the competition and work in direction for your business to succeed.
Hope this helps. All the Best!