To add on to what spunky said, I would say that the group of procedures that you absolutely must be familiar with, more than anything else, is those procedures which fall under the blanket of the General Linear Model. This includes all the varieties of t-tests, ANOVAs, simple and multiple regression, ANCOVA, moderated regression, etc. All of these different-sounding techniques are special cases of the general linear model, because they can all be expressed in the same mathematical form (a linear combination of the parameters) and they draw on basically the same set of assumptions. If you browse the top empirical journals in psychology today and look at the statistical procedures being used and reported, >90% of them are cases of the general linear model. Knowledge of other statistical techniques is also great, and spunky named the big ones, but knowledge of the general linear model is pretty much the minimum requirement to be considered a competent researcher in psychology.