The course table currently has a course_language field, that refers to the isocode (string) column of the language table.
This is not really optimal, as it diverges from other references to languages.
Convert this field to language_id and make it point to the language.id field.