Course Title: Monitor and administer a database

Part A: Course Overview

Program: C5194

Course Title: Monitor and administer a database

Portfolio: BUS

Nominal Hours: 30.0

Regardless of the mode of delivery, represent a guide to the relative teaching time and student effort required to successfully achieve a particular competency/module. This may include not only scheduled classes or workplace visits but also the amount of effort required to undertake, evaluate and complete all assessment requirements, including any non-classroom activities.

Course Code




Learning Mode

Teaching Period(s)


City Campus


650T TAFE Business

Face-to-Face or Internet or Workplace

Term2 2012

Course Contact: Paul Lewis

Course Contact Phone: +61 3 9925 1615

Course Contact Email:

Course Description

In this unit you will develop the basic knowledge and skills required to implement a range of database monitoring and administration tasks on an SQL server.

Major tasks include implementing security and back-ups in accordance with organisational requirements.

This unit is delivered using classroom-based and activities. Self-directed work can be carried out by installing a virtual machine on your home computer. Please ask for assistance if required.

If you are undertaking this course in Melbourne from semester 2, 2012 onward your class will be held in a specialist computing lab. Students are not required to have their own mobile computing device during class time. It is however recommended that you have access to a mobile computing device to allow greater flexibility in terms of where you can work on campus outside class times.

Pre-requisite Courses and Assumed Knowledge and Capabilities


National Competency Codes and Titles

National Element Code & Title:

ICAS4125B Monitor and administer a database


1.  Start up a database

2.  Manage database

3.  Manage database access

Learning Outcomes

Overview of Assessment

Students must demonstrate an understanding of all elements of competency to be deemed competent.

A range of assessment methods are used to assess practical skills and knowledge, for example:
• Direct questioning combined with review of portfolios of evidence and third party workplace reports of on-the-job performance by the candidate
• Review of authenticated documents from the workplace or training environment
• Demonstration of techniques