Retrieving Student, Course, Section, Instructor, and Enrollment Data Using SELECT

Overview

In education administration, one of the most important tasks is retrieving data from different tables. The SELECT statement allows you to extract specific information about students, courses, sections, instructors, and enrollments.

Each table stores a different part of the academic system. The students table stores student details, the courses table stores course information, the sections table shows course offerings, the instructors table stores faculty data, and the enrollments table tracks which students are registered in which sections.

By selecting specific columns, you can retrieve only the information you need. This makes your queries more efficient and easier to interpret.

Common uses of SELECT include:
• Viewing student lists
• Listing available courses
• Checking section details
• Reviewing instructor information
• Tracking student enrollments

---

The Basic Pattern

SELECT column1, column2
FROM table_name;
  

---

Examples

Example 1 — Retrieve Student Names and Program

Example 2 — Retrieve Course Details

Example 3 — Retrieve Enrollment Records

---

Practice Tasks (Your Turn!)

Task 1

Retrieve instructor names and their employment type.

Task 2

Retrieve section details including section number and delivery mode.

Task 3

Retrieve student IDs and their admission dates.