CS W186. Introduction to Database Systems

Catalog Description: Broad introduction to systems for storing, querying, updating and managing large databases. Computer science skills synthesizing viewpoints from low-level systems architecture to high-level modeling and declarative logic. System internals, including the complex details of query optimization and execution, concurrency control, indexing, and memory management. More abstract issues in query languages and data modeling – students are exposed to formal relational languages, SQL, full-text search, entity-relationship modeling, normalization, and physical database design. Recent technological trends in the field, including “Big Data” programming libraries like MapReduce, and distributed key-value stores with various consistency models.

Units: 4.0

Prerequisites: COMPSCI 61B and COMPSCI 61C.

Fall: 3.0 hours of web-based lecture and 1.0 hours of discussion per week
Spring: 3.0 hours of web-based lecture and 1.0 hours of discussion per week
Summer: 6.0 hours of web-based lecture and 2.0 hours of discussion per week

Grading basis: letter

Final exam status: Written final exam conducted during the scheduled final exam period

Class Schedule (Fall 2019):
Joshua Hug

Class Schedule (Spring 2020):
Joshua Hug, Michael Ball

Class homepage on inst.eecs

General Catalog listing