Database Design and Implementation

Course goals

This course covers the design and implementation of traditional relational database systems as well as advanced data management systems. The course will treat fundamental principles of databases such as the relational model, conceptual design, and schema refinement. We will also cover core database implementation issues including storage and indexing, query processing and optimization, and transaction management. Additionally, we will address challenges in modern information systems, including scalability and parallelization, big data systems, cloud databases, dealing with graph and vector data, and the integration of database management systems and machine learning. Prerequisites: an undergraduate-level course on operating systems or databases.

3 credits.

Schedule

Monday - Wednesday at 2.30 pm, Hasbrouck Lab Add room 124