Informatics: Advanced Database Systems
Course · 7.5 credits
Description
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).
The course uses AI-based tools and modern Integrated Development Environments (IDE) for development of database backends and clients. The course utilizes the cloud platform Microsoft Azure for development and deployment of databases.
The course assumes a basic knowledge of conceptual data modelling and basic skills in SQL. Taking this course, you will develop your skills in designing and implementing database solutions that support business operations and business objectives. You will gain a deeper understanding of relational database theory, models, methods, and an ability to use these in different scenarios.
Course content, conceptual aspects:
- Conceptual data modeling using Enhanced Entity Relationship (EER) diagrams in two different notations and comparisons to Object Oriented modelling.
- Capturing business requirements related to persistent data storage in EER diagrams.
- 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.
Course content, technical aspects:
- 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.
- Techniques for efficient and secure data storage, access, and recovery.
- Query optimization and performance tuning.
Teaching consists of lectures, lessons, laboratory work, and recorded video materials. The examination comprises assignments, presentations, and a written test.
Course director
Course documents
Closed for applications
Application opportunitiesContact
Department of Informatics
Visiting address
Ole Römers väg 6, 223 63 Lund
Postal address
Box 7080, 220 07 Lund
+46 46 222 80 19
Viktoria Svenby
Study advisor
+46 46 222 80 25
viktoria [dot] svenby [at] ics [dot] lu [dot] se
Requirements and selection
Entry requirements
Admission to the course requires general requirements and English 6 as well as the courses: ”Informatics: Introduction to Information Systems, 1-30 cr” and ”Informatics: Information Systems and Business Development, 31-60 cr” or the equivalent.
An exception for the general entry requirement in Swedish will be granted when the course is given in English.
Selection criteria
English language requirements
Most of Lund University’s programmes require English Level 6 (unless otherwise stated under 'Entry requirements'). This is the equivalent of an overall IELTS score of 6.5 or a TOEFL score of 90. There are several ways to prove your English language proficiency – check which proof is accepted at the University Admissions in Sweden website. All students must prove they meet English language requirements by the deadline, in order to be considered for admission.
How to prove your English proficiency – universityadmissions.se
Country-specific requirements
Check if there are any country-specific eligibility rules for you to study Bachelor's or Master's studies in Sweden:
Country-specific requirements for Bachelor's studies – universityadmissions.se
Country-specific requirements for Master's studies – universityadmissions.se
Apply
Start Autumn Semester 2024
Day-time Lund, part time 50%
In English
Study period
2 September 2024 - 31 October 2024
Application
You can only apply for this course in the 'Swedish student' application round. Find out more: Applying for studies – when to apply
How to apply
Lund University uses a national application system run by University Admissions in Sweden. It is only possible to apply during the application periods.
Step 1: Apply online
- Check that you meet the entry requirements of the programme or course you are interested in (refer to the section above on this webpage).
- Start your application – go to the University Admissions in Sweden website where you create an account and select programmes/courses during the application period.
Visit the University Admissions in Sweden website - Rank your programme/course choices in order of preference and submit them before the application deadline.
Step 2: Submit documents
- Read about how to document your eligibility and how to submit your documents at the University Admissions in Sweden website. Follow any country-specific document rules for Master's studies or Bachelor's studies
Country-specific requirements for Bachelor's studies – universityadmissions.se
Country-specific requirements for Master's studies – universityadmissions.se
- Get all your documents ready:
- official transcripts and high school diploma (Bachelor's applicants)
- official transcripts and degree certificate or proof that you are in the final year of your Bachelor's (Master's applicants)
- passport/ID (all applicants) and
- proof of English proficiency (all applicants).
- Prepare programme-specific documents if stated in the next paragraph on this webpage.
- Upload or send all required documents to University Admissions before the document deadline.
- Pay the application fee (if applicable – refer to the section below on this webpage) before the document deadline.
* Note that the process is different if you are applying as an exchange student or as a part of a cooperation programme (such as Erasmus+).
* If you have studied your entire Bachelor's programme in Sweden and all of your academic credits are in Ladok, you do not have to submit transcripts or your diploma when applying for a Master's programme. However, there may still be other documents you need to submit! See the link below.
* Svensk student?
Läs instruktionerna om att söka till ett internationellt masterprogram på lu.se
Tuition fees
Non-EU/EEA citizens
Full programme/course tuition fee: SEK 15 000
First payment: SEK 15 000
Citizens of a country outside of the European Union (EU), the European Economic Area (EEA) and Switzerland are required to pay tuition fees. You pay one instalment of the tuition fee in advance of each semester.
Tuition fees, payments and exemptions
EU/EEA citizens and Switzerland
There are no tuition fees for citizens of the European Union (EU), the European Economic Area (EEA) and Switzerland.
Application fee
If you are required to pay tuition fees, you are generally also required to pay an application fee of SEK 900 when you apply at the University Admissions in Sweden website. You pay one application fee regardless of how many programmes or courses you apply to.
- Paying your application fee – universityadmissions.se
- Exemptions from paying the application fee – universityadmissions.se
- Convert currency – xe.com
*Note that there are no tuition or application fees for exchange students or doctoral/PhD students, regardless of their nationality.
Scholarships & funding
Lund University Global Scholarship programme
The Lund University Global Scholarship programme is a merit-based and selective scholarship targeted at top academic students from countries outside the EU/EEA.
Lund University Global Scholarship
Within the framework of the Lund University Global Scholarship programme, the University also offers the African Research Universities Alliance (ARUA) Scholarship targeted at top academic students from selected African research universities.
Swedish Institute Scholarships
The Swedish Institute offers scholarships to international students applying for studies in Sweden at Master's level.
Scholarship information on the Swedish Institute website
Country-specific scholarships and funding options
Lund University has agreements with scholarship organisations and funding bodies in different countries, which may allow applicants to apply for funding or scholarships in their home countries for their studies at Lund University.