Exam: Midterm on SQL and Structured Data
This test is meant to ensure that you understand SQL well-enough to know when and how to use it for your own data projects.
Closed-book and closed-computer
Students are allowed to bring a standard
8.5 x 11piece of paper with handwritten notes (one-sided).
Memorization of and proficiency in using the following query clauses:
Proficiency in INNER JOINs
Proficiency in reading a SQL statement and writing out its tabular results.
The 2016 Midterm
Past midterms were take-home. See if you can do them: