Custom Paint

Can anyone tell me or show me where to find how to learn to do exotic paint jobs, ghost flames, graphics... etc.?