Databases for Developers (EN)2019/2020
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 and
practical application of learning objectives
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.
The learning outcomes of the exam are identical with the learning outcomes of the subject(s)/modul(es)Exam in one or more subjectsSubject/module is tested standaloneType of examCombined written and oral examinationIndividual exam or group examGroup, 2-4 max participantsExam languagesEnglishDuration30 minPermitted exam aidsNoneAvailable exam aidsNoneType of evaluation7-point grading scaleExaminersExternal censure
In the subject Databases for Developers (EN) you will receive 68 hours of instruction, which corresponds to 90 lessons (1 lesson = 45 min.) and 25% of your total workload for the subject.
The teaching primarily consists of the following activities: classroom teaching, external lectures, group work.
The preparation primarily consists of the following activities: reading your own notes, reading the curriculum, group work.
Read about KEAs Study Activity Model
*KEA can deviate from the number of hours if this is justified by special circumstances