Dec 03: Review for Final Exam
Learning Objectives
After today's class, you should be able to:
- Explain the format and the contents of the final written exam.
- Identify areas that you need to review and practice this week.
Lesson Outline¶
HW6 Debrief [15 min]
- Pair up with another team
- Briefly explain your design
Final Review [30 min]
- See table/notes below
- Final Exam Review
GP6 Planning [20 min]
- GP6 spec and instructions
- Practice before Thursday!
Course Eval [10 min]
- Course Evaluation Tasks on Canvas
- Thank you for your honest feedback
Exam Content¶
This is what we are planning. The question order and point values are not 100% guaranteed.
| Question | Points | Homework | Readings | Class Days |
|---|---|---|---|---|
| 1. SQL Aggregation | 10 | HW4 | 5.1–5.3 | (first half) |
| 2. SQL Joins+Other | 10 | HW4 | 5.4–5.7 | (first half) |
| 3. Web Dev: CRUD | 15 | HW5 | Flask, Jinja | Oct 22 |
| 4. Web Dev: Views | 15 | GP4 | 5.8, Charts | Oct 24 |
| 5. System Catalogs | 5 | N/A | PG37 | Oct 29 |
| 6. SQL Injection | 10 | GP5 | 11.5 | Oct 31 |
| 7. Indexes / Explain | 10 | GP4 | 6.7 | Nov 05 |
| 8. Transactions | 10 | GP5 | 7.1, 7.5 | Nov 07 |
| 9. Big Data / NoSQL | 10 | HW6 | 9.1, 9.4, 9.6 | Nov 14 |
| 10. Full-Text Search | 5 | N/A | PG12, F.35 | Nov 21 |
Not on the exam: