Database Systems

Description

This course is designed to introduce the fundamental concepts and implementations of modern database management systems. This is not a course that teaches you how to build database applications (e.g., schema design, SQL programming). It is designed as a systems course, with an emphasis on database internals. Topics include relational model and SQL, storage and indexing, query processing and optimization, transactions and concurrency control, distributed and cloud databases, as well as advanced research topics in the field. Students taking this course should have basic knowledge on computer systems. No prior database experience is assumed. The course consists of lectures, written assignments, and projects.Assignments and projects are designed to reinforce what the student learned in lectures and to provide hands-on experience in building a database system. Upon successful completion of this course, the student should feel confident taking a job as a database developer or conducting database-related research in graduate school.