Artesis Plantijn Hogeschool Antwerpen
Wetenschap en Techniek
campus Spoor Noord Ellermanstraat
Ellermanstraat 33 - 2060 Antwerpen
wt@ap.be
Database programming33966/2199/2122/1/67
Study guide

Database programming

33966/2199/2122/1/67
Academic year 2021-22
Is found in:
  • Bachelor of Applied Computer Science, programme stage 1
    Programme option:
    • IT & Business
    • IT & Software
In other study programme:
  • Bachelor of Electronics - ICT as Database programming
This is a single course unit.
Study load: 3 credits
It is not possible to enrol in this course unit under
  • exam contract (to obtain a credit).
  • exam contract (to obtain a degree).
Co-ordinator: De Pooter Marijn
Teaching staff are not (all) known yet.
Languages: Dutch
Scheduled for: Semester 2
This course unit is marked out of 20 (rounded to an integer).
Possible deadlines for learning account: 15.03.2022 ()
Re-sit exam: is possible.
Possibility of tolerance: This course unit is eligible for tolerance according to the criteria as determined by the degree programme you are enrolled in.
Total study time: 78,00 hours

Prerequisites

There are no prerequisites for this course.

Learning outcomes (list)

B.1. Design and Development
Makes connections with a database of relevant technologies.
Determins when to use views and how to make them.
Uses cursors to execute complex processing of data.
Implements transactions.
Implements programmable objects (stored procedures, functions, triggers) in a database.
B.4. Solution Deployment
Determines the usage of indices to query a database in a performant way and implements the recommended solution.
C.1. User Support
Manages login data of users, their rights and authorizations.
Monitors the backups of data in a database.
Controls the structure of a database and organizes the data.
Grants and denies permissions on databases and database objects (tables, among others).
C.3. Service Delivery
Can install and configure a database server.
Task analysis
Determines the usage of indices to query a database in a performant way and implements the recommended solution.
Controls the structure of a database and organizes the data.

Educational organisation (list)

Learning Activities
Lectures and / or tutorials24,00 hours
Practicum24,00 hours
Work time outside of contact hours30,00 hours

Evaluation (list)

Evaluation(s) for first exam chance
MomentForm%Remark
Academic yearKnowledge test20,00Digitale evaluatie. Gesloten boek examen.
Academic yearSkills assessment hands on80,00Digitale evaluatie. Open boek examen.
Evaluation(s) for re-sit exam
MomentForm%Remark
2nd examination periodKnowledge test20,00Digitale evaluatie. Gesloten boek examen.
2nd examination periodSkills assessment hands on80,00Digitale evaluatie. Open boek examen.