Databases and Web

The course provides the fundamental knowledge and skills for the design and management of relational databases and the corresponding data management systems. Additionally, the course introduces the main techniques for developing web applications that exploit the information stored in a relational database. The course is structured into theoretical lectures and laboratory sessions. The theoretical lectures cover models, languages, and database design methodologies, as well as the technologies underlying web programming, and the management of multimedia information (such as sound, images, and video). The laboratory sessions focus on the development of web applications and the use of data management tools.

The student will acquire the knowledge and practical skills to manage relational databases and develop simple web applications. Specifically, they will be able to design the conceptual and logical schema of a database based on a description of the relevant application domain; understand and execute SQL queries and define the corresponding execution plan in terms of relational algebra operations; and learn and apply the main technologies for web application development.