Database background (3/4)
n"SQL", or “Structured Query Language”, is a syntax for specifying in an almost English manner what is to be done to data. Examples:
nSELECT * FROM Student
WHERE LEFT(Last_Name,1)=’M’
nUPDATE Grade SET
Grade.Final=’A’ FROM Grade LEFT JOIN STUDENT ON Grade.Student_ID=Student.ID
WHERE Student.Major=’Physics’