Instructor: Jing Gong, Section 002/004

Review and Exam Study Guides

Exam 3 Study Guide

Here is the Exam 3 Study Guide.

Remember, the exam is on Thursday, 4/26/2018 during class time. There will be an in-class review session on Tuesday, 4/24/2018.

  • For this exam, please bring (i) a No. 2 pencil, and (ii) a calculator. You will not be able to use a computer or your smartphone’s calculator during the exam.

 

Exam 2 Study Guide & Review Session & Office Hour

Here is the Exam 2 Study Guide.

Remember, the exam is on Tuesday, 3/27/2018 during class time. There will be an in-class review session on Thursday, 3/22/2018.

  • In addition, Aaron will hold a review session on SQL advanced queries outside class time.
    • Time/location will be on Friday, 3/23/2018, 1:00 pm-2:30pm, at Alter 034.
  • Nathan will hold office hour for Exam 2.
    • Time/location will be Monday, 3/26/2018, 2:00 pm-3:30 pm, at Alter 240D.

Exam 1 Study Guide

Here is the Exam 1 Study Guide.

Here is the SQL Quick Reference 1 (a summary of all the queries we learned in Module 2 – SQL 1: Getting Information Out of a Database).

  • Note that advanced queries ( joins and subselect statements) will not be covered in Exam 1; instead, these advanced queries will be covered in Exam 2.

Remember, the exam is on Tuesday, 2/20/2017 during class time. There will be an in-class review session on Thursday, 2/15/2017.