DMX cables do not power DMX fixtures. DMX is just a communications protocol and the data is transmitted via DMX cable. You will need to power the fixture with an AC power source. Most fixtures have a tethered power cord or an attachable IEC cable for power.
You can program fixtures with a controller, such as the Op 192, but you can use software-based controllers, such as MyDMX as well. In addition, you can run fixtures in stand-alone modes or even sound-active modes (assuming the fixtures feature such a thing).
DMX can give you far more control over your fixtures than relying on stand-alone operation or built-in programs that are a part of the unit and you have no control over them (other than turning the fixture on and off). It is a very worthwhile endeavor to learn. It will take some time, but the payoffs can be tremendously rewarding.
Take a look through the past posts on the forum to read about some DMX Primers to gain some more insight into how everything works.
One of the best ways to learn is to just DO IT. Hands-on tinkering is extremely valuable. These forums are a great place to gain some knowledge and opinions, but it can never replace actually pushing buttons and moving faders and seeing what happens.
Welcome to the forums.