As an exercise, which if you choose to accept,. Let's say we have the following tables with columns as such:
COURSE COURSE COURSE DEPT
CODE NAME OFFERED CODE
IST Information Systems and Technology
If I wanted to get the output to look as follows:
SQL for Business Information Systems and Technology Online
What would my query look like? Although you don't need to build any tables with data, it would help to do this so you can test your sql query. In order to better understand sql you need to practice writing sql.
This solution deals with a SQL query for related to courses and departments.