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’