What tutorials should i look under to create these type of icons or effects?

made by:

last_crescendo xx_sleeper

I'm not sure which program to look under to achieve these effects i know there are many and there are brushes involved as well but thats all i know.

I apologize for the broad subject.