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: Computer Science 61B and Computer Science 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 (Spring 2019):
Joe Hellerstein

Class Schedule (Fall 2019):
Joshua A. Hug

Class homepage on inst.eecs

General Catalog listing