Database Systems I (ST 2023)

Dr. Hazar Harmouch


Database systems are at the core of almost all large applications and are used in all enterprises. In this lecture, we will discuss database systems from an application perspective. We start with the conceptual design of databases using ER diagrams and their translation into the relational data model. Then, we dig into the relational algebra that enables us to operate on top of these models. We also learn the SQL querying language, i.e., how we can create, update and search data tables. The second part of this lecture discusses advanced topics such as transaction management, programming database systems. From time to time, we will leave the application perspective and learn how a database system implements user instructions, for example during query processing or for consistency assurance.

Lectures

Date: April 19, 2023
Language: English
Duration: 01:14:34
Date: May 3, 2023
Language: English
Duration: 01:14:44
Date: May 8, 2023
Language: English
Duration: 01:22:10
Date: May 10, 2023
Language: English
Duration: 01:20:49
Date: May 15, 2023
Language: English
Duration: 01:25:42
Date: May 22, 2023
Language: English
Duration: 01:19:44
Date: May 24, 2023
Language: English
Duration: 01:15:09
Date: June 12, 2023
Language: English
Duration: 01:20:06
Date: June 21, 2023
Language: English
Duration: 01:20:26
Date: June 26, 2023
Language: English
Duration: 01:11:17
Date: June 28, 2023
Language: English
Duration: 00:35:48
Date: July 3, 2023
Language: English
Duration: 01:18:16
Date: July 10, 2023
Language: English
Duration: 01:24:59