How to reference a field other than the forign key field in the referenced table?

Question

To simplify the issue I have two tables students and courses where student_id is the foreign key in the courses table. Now, in the courses controller, I want to access the student_name field to pass to the Index view. How can I achieve it? The present Index view lists all fields in courses table along with student_id.