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.

Table of contents
Deadline
Thursday, November 10 at 2:50 PM
Points
33 Exam points
Deliverables
Requirements

  • Closed-book and closed-computer

  • Students are allowed to bring a standard 8.5 x 11 piece of paper with handwritten notes (one-sided).

  • Memorization of and proficiency in using the following query clauses: SELECT, WHERE, ORDER, GROUP, SORT

  • Proficiency in INNER JOINs

  • Proficiency in reading a SQL statement and writing out its tabular results.

The 2016 Midterm

Past midterms

Past midterms were take-home. See if you can do them: