Study Guide

Objective

The student:
- can plan and realize a database system
- knows and can perform the tasks of a database administrator
- can implement program code (procedures, functions, triggers) stored inside a database
- knows the basic techniques of "business intelligence".

Content

Installation of database management systems and creating databases.
Advanced SQL.
Code inside databases.
Database administration:
- Users and user rights
- Backup and recovery
- Automation of administrative tasks
- Import and export of data (ETL)
- Performance optimization and the basics of monitoring.
Business Intelligence:
- Reports
- Simple data analysis

Materials

Material on Moodle.

Evaluation scale

H-5

Assessment criteria, satisfactory (1)

The student knows the database administrator's duties.
The student can realize databases containing simple stored procedures, functions and triggers.
The student knows the principles of reporting and data analysis.

Assessment criteria, good (3)

The student can perform the routine tasks of the database administrator.
The student can realize databases with more advanced stored procedures, functions and triggers.
The student can program client applications using server-side code.
The student can realize and use databases for reporting and data analysis.

Assessment criteria, excellent (5)

The student can plan and configure the database administration for a database server and its databases.
The student can create software for database applications in multi-user environments where transaction management and locking are needed.
The student can plan, implement and use databases for data analysis.

Qualifications

Database programming.