You can enchant yourself but like alchemy there is a success/failure rate.
There are NPC's that can enchant but it's expensive, bonus with that is 100% success rate.

There aren't many trainers for this skill iirc and after checking it seems there's only one master trainer who is by default hostile towards you.