Pirate bay and to a much lesser extent (didn't used to be so), demonoid are fantastic resources. I can send you an invite for demonoid if you want, although actually I think registation is open atm.
You won't really find textbooks that with take you from beginner to MSc level. Typically two to three books are needed. To get into cutting edge you need to add on a fourth book which would be looking at very spesific areas and would require a good amount of prior knowledge.
One the best texts on Neuroscience is Neuroscience (4 or 5 ed) by Dale Purves. Absoutely fantastic book.
Cognitive Psychology Student's Handbook 6th Edition 6e, is a fantastic book on the scientific principals of cognition from basics to higher cognitive functions. It can't really be described as a purely social science book and certainly contains elements of Biology. It really is worth a read.
Essential Cell Biology is a great book for learning the basics of cellular biology and in that of course will be a fair bit of molecular biology.
Human Biology.
Human Molecular Genetics by Tom Strachan and Andrew Read.
Assuming you have read those books and that your main interest is leaning towards Medical Neuroscience and Psychiatry then its really up to you where you choose to dip your toe into. If you had a good understanding of what you had read then any area of human biology is easily accessible to you and any area of biology (bar biochemistry) could quickly become so. A few clinical texts would have you able to deal with advanced medical understanding. For example you want to have an indepth understanding of affect, mood and its clinical relevence then a book on affective science (can't find it atm) and then one on clinical mood disorders would sort that out for you. Any book you read is typically at least 5 years but often as much as 10 (even more sometimes), behind actual advances in that scientific area. What you read almost always however is correct most of that advance is added information, not the revision of it.
If you want an indepth review of applied psychiatry and its underpinning science then look no further than Kaplin and Saddocks comprehensive text book of psychiatry (comes in two parts, fundermental scientific principles and the second is clinically oriantated). It is the authoritative text on the subject.
Anything by Stephen Stahl is fantastic for Neuropsychopharmacology and he has one book out on Neruopharmacology. He is one of the top academic clinicaians in the field as per generalis. There are people with more expert 'knowledge' (practice experience) in various areas (psychosis, mood disorders etc..).
Edited by Tom_, 16 July 2014 - 06:19 PM.