When: TuTh 1:25PM – 2:40PM
Where: Biological Sciences 111
Instructor: Jun Yang
Grad TAs: Xixiang Chen and Yameng Liu
UTAs: Sarah Cogan, Fangge Deng, Yuxiang He, Daniel Rubinstein, Wilson Zhang, Liuyi Zhu
We intend this course to give you a solid background in database systems as well as data management in general. Topics include data modeling, database design theory, data definition and manipulation languages, storage and indexing techniques, query processing and optimization, concurrency control and recovery, and database programming interfaces. Besides relational and semi-structured (e.g., XML and JSON) data, this course may also sample, time permitting, a number of other topics related to data management, such as Web search, data warehousing, data mining, and “big data.” Programming projects are required.
Prerequisites: CompSci 201 or equivalent, or consent of the instructor. At the minimum, you will need CompSci 101, and familiarity (or ability to quickly become familiar) with the Unix command line (such as “Terminal” in Mac OS).
Special thanks to Google for their support of Google Cloud credits for this course!