We intend this course to give you a solid background in database systems as well as managing and processing “big data” in general. Topics include data modeling, database design theory, data definition and manipulation languages (SQL and NoSQL), database application programming interfaces, storage and indexing, query processing and optimization, parallel and distributed data processing, transaction processing, as well as a sample of other topics such as data mining and web data. Programming projects are required.
Prerequisites: CompSci 201 or equivalent, or consent of the instructor. You will need 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!