Before retiring, I taught statistics for many years to psychology graduate students. J. P. Stevens's "Intermediate Statistics: A Modern Approach'" is excellent. If you need an advanced statistics text, I would recommend "Applied Multivariate Statistics for the Social Sciences" by the same author.
Are you looking for a statistics text or a broader textbook that covers topics like experimental design and surveys? If it is the latter, that may be hard to find in a pure form, since publishers seem to prefer introductory methods textbooks that cover both quantitative and qualitative approaches.
I think it is hard to give a good advise without further information. What are you looking for? What kind of analyses are yo likely to conduct? In my experience, the field of statistical methods is vast and no single book is able to cover every topic. Therefore, in my opinion the best starting point is to figure out, which methods are used in your specific field and understand that methods. With this approach you will find examples that are familiar to you, which will make it easier to understand. In turn, you can "play" with examples and try them out by yourself, to get used to it. I would prefer textbooks that support the software, which you are using (R, SPSS, Stata or whatever) to directly practice it.
"Social Sciences" is such a large research field that tons of different methods are used, e.g. general linear models (including [multiple] regression, ANOVA etc.), linear mixed models, generalized linear (mixed) models, exploratory factor analysis, confirmatory factor analysis... and each topic has lots of subtopics. So, if you could narrow it a bit down and tell which software you are planning to use, we might give a better recommendation.
I agree with the comments by David L Morgan and Rainer Duesing. But meanwhile, you might find something useful in this old thread that asked the same question.
@ Professor David L Morgan and Professor Rainer Duesing I am looking for the broader text book which covered all the topics from design to data analysis. I am teaching to social sciences (Phschology, International Relations, Socioclogy and Economics) students. Please suggest the book which is must suitable for social sciences students and covered the topics from destricptive statistics as well inferential statistics in the case of data analysis.
The choice of the "best" quantitative research methods textbook can be subjective and may depend on the specific focus of your research, your familiarity with quantitative methods (surveys), and your instructor's preferences. However, there are several widely recognized textbooks in the field of quantitative research methods for social sciences at both the Ph.D. and M.S. levels. You can use below references (books):
"Applied Multivariate Statistical Analysis"
"Discovering Statistics Using IBM SPSS Statistics".
"Multivariate Data Analysis.
"Statistics for Social Sciences.
"Multilevel and Longitudinal Modeling Using Stata.
"Structural Equation Modeling: A Second Course.
"Regression Analysis for the Social Sciences.
"Experimental and Quasi-Experimental Designs for Research.
I also prefer Discovering Statistics Using IBM SPSS Statistics by Andy Field for MS level (for beginers).
I used these texts with my M.S. and D.Sc. Social Science students (Civil Security) for decades (since 3rd edition):
2017 Publish date
Witte, Robert & Witte, John. Statistics (11th ed.). New York: Harcourt Brace & Co.
Not all social science students start at the same level of statistical and research knowledge. These texts are written in a easy to read and understand format. Should bring your students in alignment within six to ten weeks.
Here is the direct Amazon link:
https://a.co/d/jh91I7b
Also consider:
The Basics of Social Research 7th Edition
2016 Publish date
Babbie, Earl R. The Basics of Social Research (7th ed.). New York: Harcourt Brace & Co.
Here is the direct Amazon link:
https://a.co/d/3spE8E7
Hope these recommendations help - from a retired professor (full rank). 😀