This video is mainly focused on HD 2D game art, but will be applicable to pixel art as well. It'll be less applicable to 3D, but what can you do..
If you want to see more unscripted content, I have started a Patreon: https://patreon.com/Nonsensical2D