This is a HUGE subject and you'll never learn what you need over message boards - it's a practical skill after all! I second Denise above and say get a private lesson with a local MUA, who can recommend good products for YOU since this is so variable between every person. And hire an MUA who works in print make-up and they can tailor your lesson for photography.
Have a look at Kevyn Aucoin's book 'Making Faces' too. Some of the looks and methods are a bit dated now, but it goes over lots of basic techniques in much more detail than other books and is a brilliant resource. Practice like crazy!