Fall 2019

Databases

Listed in: Computer Science, as COSC-257

Faculty

Matteo Riondato (Section 01)

Description

This course is an introduction to the use of relational databases and the inner workings of systems to manage these databases. Relational databases allow one to store, retrieve, and operate on data in a well-defined way, independent of the nature of the data. Database Management Systems (DBMS) are computer systems designed with the goal of making operations on relational databases as efficient as possible.

Students will learn about: the Entity-Relationship model and its algebra, the Structured Query Language (SQL), the actual implementation of the relational algebra operation in a DBMS, the creation and use of indices, the execution of transactions, and DBMS internals such as disk layouts, query planning, and concurrency control. These notions will be made concrete with implementation projects.

Requisite: COSC 211. Fall semester. Professor Riondato.

Offerings

2019-20: Offered in Fall 2019