DCO20403 Database Administration

Credit Units: 3
Level: A2
Medium of Instruction: English

Course Aims
The aims of this course are to introduce students to advanced Data Definition Language, Data Manipulation Language and various database objects; the physical architecture and its main components of a database; the structures involved in the client-server connection in a DBMS; and the techniques in database administration. On completion of this course, students should be able to write advanced DDL and DML; design and setup an enterprise database with physical considerations, like storage structures; design and define index, constraint, manage exception handling; manage security issues of a database system; and implement a client-server database connection.

Course Intended Learning Outcomes (CILOs)
Upon successful completion of this course, students should be able to:

1.        Identify and explain the key components of database architecture;

2.        Use DBA tools to create database, tune database background processes and manage different database files such as data files, redo log files, control files;

3.         Identify the physical and logical structures of database.

4.         Use different data dictionary views to monitor database structures and activities;

5.         Create user account and manage system privileges, as well as object privileges, profiles and roles.

6.         Use SQL commands to create, modify, or drop many different types of tables and indexes.

7.         Use additional SQL clauses that control storage settings, large object storage and partitioning.

Keyword Syllabus

1. Overall DBMS system architecture.
2. Advanced Data Manipulation Technique.
3. Advanced Data Definition Technique.
4. Database Object Handling.
5. Basic Database Administration.

Prerequisite(s): Nil
Precursors(s): DCO20401 (may be taken concurrently)
Equivalent Course(s): DCO20822, DCO21310
Exclusive Course(s): Nil
Course Duration: 1 Semester

Teaching and Learning Activities (TLAs)
(Indicative of likely activities and tasks designed to facilitate students' achievement of the CILOs. Final details will be provided to students in their first week of attendance in this course)

Assessment Tasks/Activities
(Indicative of likely activities and tasks designed to assess how well the students achieve the CILOs. Final details will be provided to students in their first week of attendance in this course)

Assessment Schedule