Syllabus
Overview
The course syllabus for Databases for Public Policy (CAPP 30235).
Lectures
Lectures are twice a week, Tuesday and Thursday 1:30-2:50 pm in Harper 151. Attendance is mandatory and you are expected to arrive on time and participate in class.
Topics Covered
The course will cover the foundations of Database Management Systems (DBMS). This includes data models, database design, SQL, core database system components (e.g. transactions, recovery, query processing), distributed databases, NewSQL/NoSQL, and systems for data analytics (e.g. column-orientated databases, data warehouses).
The goals for this class are for you to have:
- The ability to model and design a database
- An understanding of the core components of a database management system
- The ability to write SQL
- An understanding of the differences between databases and data models
Grading
Grades will be based on the following criteria:
- Class Participation: 10%
- Exams: 40%
- Homework/Projects: 50%
Requirements
- Get Ubuntu 14.04+ running on bare metal or VM.
- Ability to install open source databases (psql and others).
- Install Java 1.7+ and refresh yourself on Java.
- Install git. Setup a github account. Learn GIT
- Email aelmore@cs.uchicago.edu with an email subject of [CAPPDB] subscribe; I will likely need to cancel and reschedule a class last minute in the upcoming weeks.
Recommended Textbook
Database System Concepts by Silberschatz, Korth, and Sudarshan. Other paper readings will be assigned.
TA
Adam Dziedzic ady@uchicago.edu is the course TA.
Office Hours
Aaron’s office hours are in Ryerson 150. Time is TBD.
Adam’s office hours are TBD.
Policies
Communication
Please send emails to aelmore@cs.uchicago.edu with [CAPPDB] in the subject heading.
Plagiarism
Don’t do it. Guidelines if you need them
Issues with Grades
You must wait 24 hours to talk about issues with grading and it must be sent via email.
Cell Phones
Please keep your cell phones on silent/vibrate while in class.
Late Projects and Homeworks
Each day an assignment is late, it is marked down 20%. You have three total slack days to use at your discretion – extensions beyond this will be under extreme circumstances. Please notify Adam and myself when you use slack days and how many you are using.