DAT151 Database and Unix System Administration

Contents and structure

In this subject the students will acquire basic knowledge of installation, administration and operation of a UNIX (Linux) system, and operation and maintenance of relational databases.

Content

• Installation and configuration of Linux.
• UNIX / Linux system administration, including backups, printer management, etc.
• Management of operating systems and system components
• Installation and configuration of software and database servers
• Network file systems (NFS)
• Setup and use of systems such as LDAP (Lightweight Directory Access Protocol)
• Security in UNIX and databases: users, rights, roles, authorization, configuration of firewalls
• Resource Sharing Windows / Linux (Samba)
• Physical organization of databases, data storage, files, indexes
• Import and export data to / from databases
• Data management: availability, data quality
• Physical form design: normalization, query optimization, performance
• Concurrent users: Locking tables
• Transactions: different types of transactions and their applications
• Backup and Recovery

Learning Outcome

After completing the subject DAT151 Database and Unix system administration, the students shall be able to:

Knowledge

• Describe the principles of secure operation of UNIX and database systems
• Explain the procedures for installation, configuration and maintenance of individual components of such systems
• Evaluating a number of risk factors associated with the operation of such systems

Skills

• Perform installation and configuration of UNIX systems and databases
• Troubleshooting and repairing existing installations
• Plan and carry out preventive maintenance of UNIX systems
• Plan and carry out maintenance and performance tuning of databases

General competence

• Find and use information from vendor documentation and other relevant sources
• Write user documentation and instructions

Entry requirements

None.

Recommended previous knowledge

DAT101 Modelling and databases and DAT103 Computers and Operating Systems, or equivalent subjects.

Teaching methods

Lectures. Practical exercises in groups on the lab.

Teaching materials in English, lectures in English or in Norwegian. All exercises have to be answered in English.

Compulsory learning activities

8 compulsory exercises must be completed within the given deadlines and approved before the exam can be taken. Deadlines for the exercises will be published at the beginning of the semester.

The exercises are written assignments to be handed in through Canvas.

An exercise that is not approved can be handed in two more times in the same semester.

In order to take the exam, the deadlines must be respected.

Approved exercises also give access to postponed examination the following semester.

Before a new or postponed exam can be taken the next time the subject is taught, new exercises must be delivered. This is because the technologies used in the course is in constant development. The learning outcome from the exercises must be up to date with the standards and technologies used in the course.

Assessment

Oral exam, with examination for 40 minutes.

Time and place for examination will be announced at the subject's pages in Canvas.

Grading scale is A-F where F is fail.

Examination support material

None.

More about examination support material

Course reductions

• TOD121 - Unix drift - Reduction: 5 studypoints
• TOD122 - Database drift - Reduction: 5 studypoints