Oct 08: Review Weeks 1–7, venv

Learning Objectives

After today's class, you should be able to:

• Summarize the types of questions that will be asked on the midterm.
• Create a Python virtual environment and install packages using pip.

Lesson Outline

Exam Review [40 min]

• See table/notes below
• Sample Midterm

Python venv [15 min]

• Open your repository folder in VS Code
• From the command pallette (press F1)
  • Python: Create Environment…
  • Venv (in current workspace)
• Open a terminal in VS Code
  • Prompt should begin with (.venv)
  • Run the following commands:

    pip install --upgrade pip
    pip install mysql-connector-python
    pip install "psycopg[binary]"
    pip install faker
    

Faker module [20 min]

• faker_demo.py
• Documentation
• Get ready for GP3

Midterm Outline

This is what we are planning. The question order and point values are not 100% guaranteed.

Question	Points	Homework	Readings	Class Days
1. Read EER Diagram	15 pts	HW3	3.1–3.6	Sep 10, Sep 12
2. Relational Mapping	15 pts	HW3	3.7–3.9	Sep 17, Sep 19
3. Normalization	10 pts	N/A	3.10–3.12	Sep 24, Sep 26
4. Database Updates	15 pts	HW1	2.1–2.6	Aug 27, Sep 03
5. SQL Joins, etc.	15 pts	HW2	2.7–2.12	Sep 05, Oct 01
6. SQL Aggregation	15 pts	HW4	5.1–5.2	Aug 22, Aug 29
7. SQL Set Operation	15 pts	HW4	5.3–5.7	Oct 03

Not on exam:

• Python DB-API (and other Python code, libraries)
• Software tools (db browser, workbench, pgadmin)
• Group project (GitHub, Markdown, DBML, etc.)
• Relational algebra (optional section of textbook)

Your To-Do List

• Study for the midterm exam (Thursday in class)
• Revise GP2 design based on all the feedback