== Viewing Available Courses

==== Actors: **Guest User, Registered User**

**1.** Open Course Catalog:
A guest user or a registered user opens the course catalog page.

**2.** The system displays all active courses.


{{{#!sql
SELECT c.course_id, c.name, c.price, c.status,
       ue.first_name || ' ' || ue.last_name AS instructor
FROM course c
JOIN instructors i ON c.instructor_id = i.id
JOIN user_entity ue ON ue.id = i.id
WHERE c.status = 'ACTIVE';

}}}