Database Administration (Quản trị cơ sở dữ liệu)

DATABASE ADMINISTRATION

INF30010     |       12.5 Credit Points       |       Location: Hanoi, Ho Chi Minh City

Duration                                             Contact hours

One Semester                                       36 hours

Prerequisites

150 Credit Points
Concurrent Pre-requisites:
A unit can be either completed prior to commencing study or taken at the same time.
INF20010 Database Systems

Corequisites

Nil

Aims and Objectives

Modern databases typically have very large data holdings and are faced with completing huge numbers of transactions. Effective administration is needed to ensure databases function at their optimum against organisational requirements. This unit aims to deliver a set of concepts and tools that can both enable and improve database administration. Students will use these approaches to both setup and assess design and implementation options that improve databases performance. Typical performance problems will be investigated and remedied using appropriate tuning options. The potential of distributed databases, replicated databases, and data warehouses will be explored.

Students who complete this unit will be able to
1. Apply concepts and techniques for completing key database administration tasks
2. Analyse an organisation’s database performance requirements and recommend strategies for improvement
3. Individually and collaboratively use database performance tuning tools to optimise database performance
4. Evaluate the distribution of databases over multiple servers within an organisation with particular reference to performance improvement

General Skills Outcome

– Teamwork skills
– Problem solving skills
– Analysis skills
– Communication skills
– Ability to tackle unfamiliar problems, and
– Ability to work independently