Introduction to SQLAlchemy - Pycon 2013

This package contains the student prerequisite handout as well as the in-class software we'll be running.

Tutorial Updates

We've been given access to the page at to provide updates on tutorial status. We're hoping to be around at least for the Wednesday 6:30 setup session.

Preparing for the Tutorial

Prior to the class, all students should:

  • Download this package. It is available using git as follows:

    git clone

    Loading the package via git is preferred, so that on the day of the tutorial students can update the package in-place with the latest updates. For those students not yet familiar with git, it is also available as a .zip file from this link via

  • Read through the handout. It is included as a PDF file handout.pdf as well as an HTML document viewable at handout/index.html. The handout includes a "Relational Review" section which discusses the basics of SQL, relational algebra, and transactions; the course will assume a basic understanding of this material.

  • Install and test the software environment. Full instructions are available in the handout in the "Package Setup" chapter. As detailed in that section, students should first install virtualenv, then create a virtual environment, then install the local software packages using .venv/bin/python


Course Time: Thursday, March 14, 1:20 PM - 4:40 PM

Location: Great America Floor 2B R3

Time Topic
1:20 - 1:30 Welcome / Setup
1:30 - 1:40 Prerequisite Material Review
1:40 - 1:45 Overview of SQLAlchemy
1:45 - 2:00 Engine, Connection, Transactions
2:00 - 2:20 Table Metadata, Reflection, DDL
2:20 - 2:50 SQL Expressions
2:50 - 3:10 break
3:10 - 4:40 ORM