CMPSCI 345: 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!

Course Time:

Mo We 2:30 pm - 3:45 pm, Goessmann Lab Addtn rm 151

Professor:

Alexandra Meliou
Contact: ameli [at] cs [dot] umass [dot] edu
Office Hours: Wednesday 10-11am, CS 330 (subject to change; please check back for updates)

Teaching Assistant:

Matteo Brucato
Contact: matteo [at] cs [dot] umass [dot] edu
Office Hours: Tuesday 2-3pm, CS 207

Text:

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.

The textbook is optional. However, you should 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.