How to display integer value as a category and link a table to it which has the value dictionary

Hi all, 

Apologies if this has been posted, I'm a bit new to this so I wasn't entirely sure how to phrase my question. I have a table (lets call it course table) with course ID's (1, 2, 3, etc) as the identifier, I want to show the occurrence (count) of these courses in a bar graph, while displaying the names instead of the number which are in an alternate table (course calendar) that it is linked to it. I have the database from SQL which I imported so the relationships are already defined. 

Thanks in advance.