May 02: Review for Final Exam
Learning Objectives
After today's class, you should be able to:
- Explain the format and the contents of the final program exam.
- Identify areas that you need to review and practice this week.
Lesson Outline¶
Reminders [5 min]
- Group Evaluation Survey
- Due yesterday; submit ASAP if needed
- How the group project will be graded
- Midterm exam Q3–Q6 replacement
- Will be Q1–Q4 on the final exam
Slide Deck [60 min]
- See table/notes below
- Final Exam Review
Course Eval [10 min]
- Course Evaluation Tasks on Canvas
- Thank you for your honest feedback
Exam Questions¶
This is what we are planning. The question order and point values are not 100% guaranteed.
| Question | Points | Homework | Readings | Class Days |
|---|---|---|---|---|
| 1. Relational Mapping | 15 | GP2 | 4.7–4.9 | Feb 08, Mar 28 |
| 2. Database Updates | 15 | GP3, GP5 | 2.8–2.11 | Feb 15, Apr 04 |
| 3. SQL Aggregation | 15 | GP4 | 3.1–3.3 | Feb 20 |
| 4. SQL Joins+Other | 15 | GP4 | 3.4–3.6 | Feb 22, Feb 27 |
| 5. Normalization | 10 | GP2 | 4.10 – 4.12 | Mar 19, Mar 21 |
| 6. SQL Indexes | 5 | GP2, GP3 | 5.1 – 5.7 | Mar 28 |
| 7. Web Development | 10 | GP3, GP4 | 7.1 – 7.4 | Apr 02, Apr 04 |
| 8. SQL Functions | 5 | GP4 | 9.1 – 9.3 | Apr 09 |
| 9. SQL Injection | 5 | GP4, GP5 | 9.4 – 9.5 | Apr 11 |
| 10. Transactions | 5 | GP5 | 6.1 – 6.5 | Apr 16, Apr 18 |
Not on the exam:
- ER Modeling (GP1)
- Mar 26 – Git / GitHub
- Chapter 8. Complex Data Types
- No class days for this topic
- Chapter 10. NoSQL Databases
The End
We have enjoyed working with you this semester. Thank you for your attendance and participation. We hope you learned a lot and enjoyed the course. Good luck on all of your final exams next week!