Informatics: Advanced Database Systems

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.

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.

The following conceptual aspects are covered:

• Conceptual data modeling using Enhanced Entity Relationship (EER) diagrams in two different notations
• Transformation of conceptual data models to relations (Relational Database Theory)
• Implementation of relations in a Relational Database Management System (RDBMS)
• Normal forms and normalisation up to Fourth Normal Form (4NF)
• Database views and implementation of integrity constraints

The following technical aspects are covered:

• Implementation of centralised, decentralised, and distributed databases
• Transaction Management
• Data replication and distributed transactions
• Transaction Concurrency and Recovery
• Architectural issues related to RDBMS architecture and client architecture
• Advanced and embedded SQL scripting including SQL triggers and stored procedures
• Access management
• Efficient and secure data storage, access, and recovery
• Query optimisation and performance tuning

Course syllabus

The syllabus contains the formal and legal details of the entire course. It’s a legal document outlining the course structure and requirements, intended mainly for administrative use.

Course literature

The course literature listed may be updated up to eight weeks before the course begins.

The course is designed for practical, hands-on learning, using modern tools and platforms.

Teaching consists of a mix of lectures and lessons, but also of practical laboratory work, and recorded video materials that you can use to deepen your understanding at your own pace.

The examination consists of assignments, presentations, and a written hall exam.

Entry requirements

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.

Selection criteria

Seats are allocated according to: The general average (GPA) of your higher secondary school leaving certificate: 20 %, The Swedish national university aptitude test: 10 %, number of previous ECTS at application deadline (up to 165): 70 %.

Tuition fees for non-EU/EEA citizens

Citizens of countries outside:

• The European Union (EU)
• The European Economic Area (EEA) and
• Switzerland

are required to pay tuition fees. You pay an instalment of the tuition fee in advance of each
semester.

Tuition fees, payments and exemptions

Full programme/course tuition fee: SEK 16,250
First payment: SEK 16,250

Convert currency – xe.com

Note that you may also need to pay an application fee, or provide proof of exemption.

Application fee

No tuition fees for citizens of the EU, EEA and Switzerland

There are no tuition fees for citizens of the European Union (EU), the European Economic Area (EEA) and Switzerland.