Management and Maintenance of a Database SystemsLaajuus (3 ECTS)

Objective

After completing the course the student understands the implementation of a DBMS, its principal operations, and can participate to DBMS design processes and manage them.
-----
After completing the course the student understands the specific issues concerning DBMS management and maintenance.

Content

• Installation of a Database Management System (DBMS)
• Documentation of a DBMS
• DBMS File Creation and Usage
• Users, Groups, and Role Management
• User Rights Definition
• Data Import and Export Between Different Systems
• Backup and Restore
• Automation: Sequences, Triggers, and Stored Procedures, Their Creation, Usage, and Management
• Optimization of Operations: Queries, Indices, Table, and File Structures

-----
• Principles of Distribution and Scaling in DBMS

Qualifications

Basics of Database Management

Assessment criteria, satisfactory (1)

After completing the course the student can:
- install a database system
- create and manage users
- create simple databases with SQL language

Assessment criteria, good (3)

After completing the course the student can:
- grant different rights to different users
- define and materialize views
- track the load of queries
- understand the meaning of maintenance operations

Assessment criteria, excellent (5)

After completing the course the student can:
- analyze and manage the load of a database system
- create and manage triggers, functions, and sequences
- perform database backups and replications