Databases for Developers2023/2024
- Purpose and learning objectives
The aim of the subject element is to train the student to be able to select and apply various database types appropriately in relation to various fields of application. The student must also be able to analyse and develop in relation to large databases, including redesign and optimisation.Knowledge
The student must have knowledge of:Skills
•Various database types and the underlying models
•A specific database system’s storage organisation and query execution
•A specific database system’s optimisation possibilities – including advantages and disadvantages
•Database-specific security problems and their solutions
•Concepts and issues in relation to data warehousing, including big data
•The particular issues raised by having many simultaneous transactions, including in connection with distributed databases
•Relational algebra (including its relationship to execution plans)
The student can:Competences
•Transform logical data models into physical models in various database types
•Implement database optimisation
•Use parts of the administration tool to assist in the optimisation and tuning of existing databases, including the incorporation of a specific DBMS’ execution plans
•Use a specific database system’s tools for handling simultaneous transactions
•Use the programming and other facilities provided by a modern DBMS
•Use an object-relational mapping tool
The student can:
•Analyse the application domain in order to select a database type
•Divide responsibility for tasks between the application and DBMS during system development, to ensure the best possible implementation.
- Type of instruction
The teaching is organised as a variation between class teaching, guest lecturing, company visits, group project work and individual work. The learning is most often problem-based and cross-disciplinary and always practise-oriented. In addition to learning the subject, the student will gain the competences to work individually and in collaboration with others.
The common aim of the activities is always to set clear intended learning objectives.
- Subject/module requirement for
Equipment needed to participate
Windows PC, Mac or Linux
- min 8 GB RAM (16 GB RAM preferably)
- 200 GB available disk space
- CPU with virtualisation hardware (usually available in most modern CPUs)
- 15,6” screen or bigger is recommended
The learning outcomes of the exam are identical with the learning outcomes of the subject(s)/modul(es)Prerequisites for access to the examinationDuring the Database module, the student will be given two mandatory assignments and an exam report.
To attend the exam, the student will have to write a report reflecting upon different topics related to the course and hand it in Wiseflow.
The report is not graded. If fulfilled, the student will be allowed to enter the exam. If not, the student will get a 00 at the exam.
During the exam the student may be asked to show the mandatory assignments. Failure to do so will mean that the student gets a 00.Exam in one or more subjectsSubject/module is tested standaloneType of examOral examinationFormal requirementsNumber of stud Number of pages
2 Max 25
3 Max 30
4 Max 35Individual exam or group examIndividualExam languagesEnglishDurationPresentation - max 10 min.
Examination- max. 15 min.
Grading - 5 min.
Total - 30 min.Permitted exam aidsComputerAvailable exam aidsProjectorType of evaluation7-point grading scaleExaminersExternal censure
- Preliminary literature list
This is a preliminary literature list. A final literature list will be provided in connection with study start.Course materials available to the students via Internet.
- Additional information
Some classes may take place online.
In the subject Databases for Developers you will receive 90 hours of instruction, which corresponds to 120 lessons (1 lesson = 45 min.) and 33% of your total workload for the subject.
The teaching primarily consists of the following activities: classroom teaching, external lectures, group work, Online teaching.
The preparation primarily consists of the following activities: reading your own notes, reading the curriculum, group work, project work.
Read about KEAs Study Activity Model
*KEA can deviate from the number of hours if this is justified by special circumstances