# prepare query
$cursor = $dbh->prepare('SELECT * FROM grades WHERE className=?');

# cycle through courses
foreach $course (@courses) {

  # execute query
  $cursor->execute($course);

  ...
}

...