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.

This course is offered in a flipped classroom setting. This means that the students need to study resources, watch videos, and process other provided material in preparation for each class. The material relevant for the topic of each week will be posted on Moodle. During class time, the students will engage in group work, some of it guided, and some less structured. The group work will include exercises, active practice of the week's topics on real applications, and other activities.

In this blended instruction model, students guide their own learning and are in charge of their preparation and learning experience. Studying the preparation materials before each class is crucial in ensuring a productive experience for each student and their working group. Note that the study materials and course participation are both necessary to succeed in the class.

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

Course Time:

Mo 10:10 am - 12:05 pm, ILC S220

Instructional team:

Alexandra Meliou Instructor
Assan Toleuov Teaching Assistant
Liam Rothschild-Shea Teaching Assistant
Aisiri Murulidhar Undergraduate Course Assistant
Charles Mednieks Undergraduate Course Assistant

Contact:

Please use Piazza for questions to the instructional team

Office hours:

Fri 2:30 pm - 3:45 pm, ILC S220
Wed 12 pm - 1 pm, CS 207, Cube 1

Tutoring:

You can make a tutoring appointment for our class through the Learning Resource Center




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 textbook is optional, but strongly recommended. A student who studies all the provided materials and who remains actively engaged in the class activities may not need the textbook. However, a student who may have several absences may find the textbook valuable to get up to speed with material they missed during class. We strongly recommend the textbook to all students who are unfamiliar with the flipped classroom setting and would benefit from more traditional study resources. All students are likely to find the textbook a useful resource to prepare for exams.


Technology:

The course is taught in a TBL classroom, and every team of 3 students will have access to a laptop with all the necessary software. Students are also welcome to use the classroom during the booked office hour times. At that time, TAs will be present to assist with questions. Students are also encouraged to set up a database system to practice on their personal computers. We have instructions on setting up a database system on personal computers here.