CMPSCI 390DB: Practice and Applications of Data Management

This course will provide a comprehensive introduction to the use of data management systems within the context of various applications. Some of the covered topics include data models, basic and advanced SQL, design and tuning of relational schemas, implementation of basic transactions, and data visualization tools. The class will alternate between lecture and practice, and the students will experience the covered topics through a semester-long collaborative mini-project.

Course work will include homework assignments, web quizzes, a collaborative mini-project, and a midterm and final exam.

Prerequisites: CS 187 (grade C or greater). 3 credits.

Students who have taken CMPSCI 445 are not eligible for this class!

Important notice: This is an experimental offering for the class and all materials are subject to change throughout the semester. Check the schedule and requirements often. Any changes will be reflected on this website, and will also be announced in lectures.

Course Time:

Tu Th 2:30 pm -3:45 pm, LGRC A310


Alexandra Meliou
Contact: ameli [at] cs [dot] umass [dot] edu
Office Hours: (changed:) Wednesday, 2:30pm-3:30pm, or by appointment (Room 330)

Teaching Assistant:

Sandeep Kalra
Contact: skalra [at] cs [dot] umass [dot] edu
Office Hours: Monday, 1pm-2pm, CS207


The textbook for this course is the 2nd Edition of "Database Systems: The Complete Book" by Garcia-Molina, Ullman, and Widom. The textbook is available from Amazon. The lecture notes will be posted online after each class.

Alternative textbook: 3rd Edition of "Database Management Systems" by Ramakrishnan and Gehrke