Skip to content

Oct 20: Loading a Database

Learning Objectives

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

  • Write scripts that drop, create, and populate a database.
  • Import real data from files and web APIs, and mix it with generated data.

Lesson Outline

Exam 1 [20 min]

  • Go over the exam and the most common mistakes

GP3 [15 min]

  • Build and Load, in your new <area>/gp3 branch
  • The faculty table was renamed to employee
  • Be sure to run pip install -e ".[dev]" again

Loading [25 min]

Team time [15 min]

  • Start GP3: divide the tables, and look at your area's real data

Your To-Do List

  • Finish up HW4 ← due tonight
  • Week 9 reading ← due Wednesday
  • Start on GP3 ← due Monday