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.
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.gitLoading 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.pdfas well as an HTML document viewable athandout/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
| 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 |