About


This is a course on databases using SQL, Python, and Drupal.

Estimates of the required effort to do well are:

  • 5 hours per week of studying.
  • 10 hours per week of programming.
  • 5,000 lines of SQL/Python code.

Lecture


Unique Days Time Place
53355 MWF 11am WAG 214

Instructors


Type Name Days Time Place
Lecturer Glenn Downing
downing@cs.utexas.edu
Google+
Twitter
MF
W
12-12:50pm
2-2:30pm
GDC 6.308
Assistant Yuchen He
hychyc07@cs.utexas.edu
T
F
11am-12:30pm
4:30-6pm
GDC 3.302

Books


Title Authors Year
SQL: Visual QuickStart Guide
3rd Edition
Chris Fehily 2010 required
Database Design with UML and SQL Tom Jewett 2006
Dive Into Python 3 [online] Mark Pilgrim 2010 optional
Learning with Python 3 [online] Allen Downey
Jeffrey Elkner
Chris Meyers
2009
Pro Git [online] Scott Chacon 2009

Tools


Type Link
Discussion Piazza
Examples GitHub
Grades Blackboard
IDE MySQL Workbench

Prerequisites


Computer Science 307, 313E, 314, 314H, or Electrical Engineering 422C (or 322C) with a grade of at least C-.

Special Needs


Any student with a documented disability who requires academic accommodations should contact Services for Students with Disabilities at 471-6259 (voice) or 1-866-329-3986 (Video Phone) as soon as possible to request an official letter outlining authorized accommodations.

You must provide this letter to me by the 12th class day. Project deadlines will not be extended for special-needs students.

Incompletes


To be eligible for an incomplete you must have a letter grade of C or better and a written, verifiable excuse for missing the last test. This is a necessary but insufficient condition for receiving an incomplete.

Academic Integrity


Students who violate University rules on academic dishonesty are subject to disciplinary penalties, including the possibility of failure in the course and/or dismissal from the University. Since such dishonesty harms the individual, all students, and the integrity of the University, policies on academic dishonesty will be strictly enforced. For further information please visit the Student Judicial Services Web site: Student Judicial Services.

Programming assignments will be compared using Moss. You may share design ideas with your fellow students. You may not share code in any way with your fellow students.

The penalty for academic dishonesty will be a course grade of F and a referral of the case to the Dean of Students. Further penalties, including suspension or expulsion from the university may be imposed by that office.