I'm terrible when it comes to graphics programming but I have delusions of someday becoming competent at least with the concepts. I learned a lot from this blog post by one of the developers of Planetary Annihilation.
It's edifying to see that they are doing a lot of work to make their eventual product actually match the look and feel of their demo (which was created without any game tech in place, as far as I understand).