Test 1 Review

Bring a GradeMaster form and a pencil to the test. The test will take 50 minutes.

Overall Scope

• Know key terms and definitions from the lecture notes

SQL

• Be able to write SELECT statements to solve queries similar to the ones in the homework
• Given a SELECT statement and sample data, be able to determine what results the statement would produce
• Be able to identify malformed SELECT statements
• Know the evaluation sequence for SELECT statements: FROM, WHERE, GROUP BY, HAVING, ORDER BY, SELECT.
• Know the types of joins and what they do
• Know the three ways to solve difference problems we discussed
• Know the 3-valued logic rules we discussed and be able to apply them when executing a query