Introduction to SQLAlchemy - Pycon 2013
This package contains the student prerequisite handout as well as the in-class software we'll be running.
We've been given access to the page at https://us.pycon.org/2013/community/tutorials/16/ 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 https://bitbucket.org/zzzeek/pycon2013_student_package.git
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 https://bitbucket.org/zzzeek/pycon2013_student_package/get/master.zip.
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 install.py.
Course Time: Thursday, March 14, 1:20 PM - 4:40 PM
Location: Great America Floor 2B R3
|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|