Database ManagementLaajuus (5 cr)

Objective

The students understand the significance of database management, are able to support application development and database use, testing and training. They know how to manage a database, save structures; specify users, user groups and access rights; secure data, monitor and optimise databases.

Content

The structure and operation of database management systems, the duties of a database administrator (DBA); installing, administration and management of a database.
The technologies of query database systems (data banks). The most common database management systems. Object-oriented and XML databases and other trends in data management.

Qualifications

Basics of databases or equivalent studies

Assessment criteria, satisfactory (1)

Excellent 5: The student has a versatile and comprehensive knowledge of database management: he (she) can manage the database, save structures, define users, user groups and user rights; he (she) can back up data, and monitor and optimize the database.
Very good 4: The student has a good knowledge of database management: he (she) can manage the database, save structures, define users, user groups and user rights; he (she) can back up data, and monitor and optimize the database.
Good 3: The student knows the essential operations of database management: he (she) can manage the database, save structures, define users, user groups and user rights; he (she) can back up data, and monitor and optimize the database.
Satisfactory 2: The student knows the essential operations of database management.
Sufficient 1: The student knows the basics of database management.
Not accepted (0)