Leslie that's a pretty broad question, but I will try to respond to all what the question implies.
The first important thing is to have the theorical capacity of piles in compression and tension. They are of course different, because in compression you have point-bearing capacity plus friction...