Patent Agent vs Patent Attorney?

Sorry in advance if this has been asked already, but I was given an opportunity by my company to study to become a patent attorney. And upon my own research, I had some questions

Now, based on the conversation with the owner, I think he meant to say patent agent and not attorney since he didn't mention nothing about law school and was focused more on my science background.

When I found out there are two types, it got me wondering...what exactly is the difference? It seems that the agent can do most of what an attorney does aside from legal opinions (tbh don't even know what that means in this context).

Then there's a patent examiner too which another category too

In all, I'd just like to know the in world differences between the two since the major one for training is the attorney attenda law school.

Please enlighten me if any of my info is wrong!