Oct 14: ORM with SQLAlchemy

Learning Objectives

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

• Install and run SQLAlchemy and sqlacodegen with TPC-H.
• Explain how SQLAlchemy can be used in addition to SQL.

Lesson Outline

• Introduction to SQLAlchemy
  • [10 min] Getting Started
  • [25 min] Exercise 1
  • [25 min] Exercise 2
  • [15 min] HW4/GP4
• Supporting files:
  • quick_start.py
  • TPC-H Schema

Your To-Do List

• Read the SQLAlchemy ORM Quick Start
• Skim the SQLAlchemy Unified Tutorial
• Continue to make progress on your project
• Keep an eye out for HW4 (coming soon!)