Copenhagen School of Design and Technology

da

Databases for Developers (EN)

2018/2019
Danish title
Databaser for udviklere (EN)
Study programme
Software Development
Type of education
Full time education
Level of education
Bachelor (top-up)
Semester
5. semester
Duration of the subject/module
16 weeks
Ects
10
Programme elements
Compulsory
Language
English
Start time
Autumn
Spring
Location
Lygten 37, København NV
Subject number
9942152
Responsible for the subject(s)/modul(es)
Jarl Tuxen
Christian Ole Kirschberg
Constantin Alexandru Gheorghiasa
  • Content and learning outcomes

    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:
    •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)

    Skills

    The student can:
    •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

    Competences

    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.
  • Exam

    The learning outcomes of the exam are identical with the learning outcomes of the subject(s)/modul(es)

    Exam in one or more subjects
    Subject/module is tested standalone
    Type of exam
    Combined written and oral examination
    Individual exam or group exam
    Group, 2-4 max participants
    Exam languages
    English
    Duration
    30 min
    Permitted exam aids
    None
    Available exam aids
    None
    Type of evaluation
    7-point grading scale
    Examiners
    External censure
68
hours of teaching
206
hours of preparation
The figure shows the extent of workload related to the subject divided into different study activities.

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