To find journal titles in your chosen field, try the Journals A-Z List:
To find information about a potential faculty advisor, including recent research by their graduate students, try searching in the "Advisor" field in ProQuest Dissertations and Theses (Advanced Search):
To find articles by your potential advisor, look at their departmental website, and/or try searching under Author or Indexes / Author in the PsycINFO database: