Study Guide

Objective

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

Content

Installation of database management systems and creating databases.
SQL and SQL extensions.
Server programming:
- Stored procedures,
- Functions,
- Transactions and locking,
- Triggers
- Using server side code in client applications.
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
- Data analysis

Qualifications

Database programming.

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.

Materials

Material on Moodle.