I really liked Reading Statistics and Research for figuring out what stats mean in the context of other papers. I think it covered everything through my 3rd stats course.
When I'm trying to figure out which tests to use in my own research, how to do them (in SPSS), and how to interpret them, Laerd Statistics is my go-to. There's some information on there for free, but a subscription is super cheap and worth every penny. I'm not usually the type to drop money on something that I could figure out for free with Google, but having one website to go to that includes most of the basic stats, and where the explanations always make sense, are super detailed, have good sources, and are step-by-step (including things like checking for assumptions and how to write about your results) --I think it's totally worth $26 per year.
ETA: I'm also in social science.