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 | |
| Ke Yang | Assisting Instructor | |
| Mohammad Hadi Nezhad | Teaching Assistant | |
| Aman Malali | Teaching Assistant | |
| Stanley Araki | Undergraduate Course Assistant | |
| Maahi Goel | Undergraduate Course Assistant | |
| Joseph Ismael | Undergraduate Course Assistant | |
| Kirin Sarangkasiri | Undergraduate Course Assistant | |
Contact: |
Please use Piazza for questions to the instructional team | |
Office hours: |
Fri 2:30pm - 3:45 pm, ILC S220 (open classroom time) [to be confirmed] | |
| Wed 11am-12pm, Zoom link (with Aman) | ||
| Thu 2:30pm-3:30pm, Zoom link (with Hadi) | ||
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.