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 to take this class!

Important notice: This is the second 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:

Mo We 10:35 am - 11:50 am, CS 140


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

Teaching Assistant:

Xiaolan Wang
Contact: xlwang [at] cs [dot] umass [dot] edu
Office Hours: Tue /Thu, 3-4pm (CS 207)


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.

Talk to the instructor if you want to consider a different textbook, or to not use a textbook at all, in order to understand the tradeoffs before you make this choice.