These tutorials were basically written for making games in AGS, but i think they can still be applied to other art forms.

Hi-Res Background Art Tut

Low-Res Background Art Tut

Anti-Alias in low-res

Walkcycle Images for free!

Drawing a character from a scanned image

Drawing a character from a photo source