Informatics: Advanced Database Systems
Lund University
Lund
Startdatum:
Slutdatum:
Studietakt: 50 %
Publicerad utbildningskatalog
Informatics: Advanced Database Systems
Utbildningsinformation från den publicerade källan. Utbildningen och dess tidsbundna tillfällen hålls åtskilda.
Utbildningsfakta
Kod: INFC20
<p>Advanced Database Systems provides you with a deep and thorough understanding of both conceptual and technical topics connected to Relational Databases, Relational Database Management Systems (RDBMS), and Structured Query Language (SQL).</p><p>The course assumes that you already know the basics of conceptual data modelling and SQL. Here, you will learn how to design and deploy databases that support business operations and objectives. You will gain a deeper understanding of relational database theory, models and methods. </p><p>You will use modern, AI-based tools for the development of database backends and clients. You will deploy your databases to a cloud platform - Microsoft Azure. </p><p>The following conceptual aspects are covered: </p><ul><li>Conceptual data modeling using Enhanced Entity Relationship (EER) diagrams in two different notations</li><li>Transformation of conceptual data models to relations (Relational Database Theory)</li><li>Implementation of relations in a Relational Database Management System (RDBMS)</li><li>Normal forms and normalisation up to Fourth Normal Form (4NF)</li><li>Database views and implementation of integrity constraints</li></ul><p>The following technical aspects are covered: </p><ul><li>Implementation of centralised, decentralised, and distributed databases</li><li>Transaction Management</li><li>Data replication and distributed transactions</li><li>Transaction Concurrency and Recovery</li><li>Architectural issues related to RDBMS architecture and client architecture</li><li>Advanced and embedded SQL scripting including SQL triggers and stored procedures</li><li>Access management</li><li>Efficient and secure data storage, access, and recovery</li><li>Query optimisation and performance tuning</li></ul><p> </p><p> </p>
Behörighet
General and completed courses corresponding to SYSA21 Informatics: Introduction to Information Systems, 30 ECTS credits, and SYSB13 Information Systems: IS and Business Development, 30 ECTS credits. English course 6/B.
Utbildningstillfällen
Varje tillfälle har egna datum och villkor. Avslutade tillfällen behålls som historik och innebär inte att en ny ansökan är öppen.
Källa och uppdatering
Hämtad: .
Publicerad: .
Visa källversion
Publiceringsversion: 8e217193-f5fa-4778-b085-a4521fd03e8d
Kontrollsumma: 1b0dc54c0fc8a359f83ba9dc8f9d468479ce432de4c03bce3b8b33dd67fe3f6c
Senast ändrad enligt källan: 2026-03-25T09:23:50