Units

---

Sample subject outline - Semester 2 2013

Note: Subject outlines often change before the semester begins. Below is a sample outline.

Rationale

Oracle Corporation is the leading supplier of database software. Consequently, there are advantages in being familiar with Oracle software. This unit provides a practical introduction to software tools for database administration and for application development. Although you may not use Oracle technologies in future, the generic database administration and application development skills are transferrable to many commonly encountered relational database systems such SQL Server, MySQL etc.

Aims

This unit aims to develop a sound understanding of database creation, installation, administration, management, security, back up/recovery and application development. The unit aims to develop practical skills in each of these elements, using appropriate Oracle software.

It is expected that students undertaking this unit will have prior knowledge of relational database terminology and concepts, be thoroughly able to develop SQL for querying, updating and creating tables, and have a sound knowledge of database design.

Objectives

On successful completion of this you should be able to:

1. Understand the Oracle architecture and create an Oracle database server(GC1)


2. Understand various database operations such as administration, management, maintenance, backup/recovery etc.(GC1)


3. Use SQL*Plus and other DBA tools to perform these operations(GC1)


4. Develop a database application from given specifications using Oracle software tools(GC2)


5. Develop your ability to self-assess your skills in this area(GC5)

Key: Graduate Capabilities
GC1 Knowledge and Skills
GC2 Critical and Creative Thinking
GC3 Communication
CG4 Lifelong Learning
GC5 Independence and Collaboration
GC6 Social and Ethical Responsibility
GC7 Leadership and Change

Content

This unit will teach you about the SQL*PLUS, Oracle database server architecture, Oracle DBA tools, database creation, management and administration, Oracle database storage mechanisms, managing users, system and object privileges, backup and recovery of the database, application development with Oracle software tools.

Approaches to Teaching and Learning

The content of the unit is delivered via a lectures/laboratory program, case studies, the Blackboard unit site and the prescribed textbooks. Laboratory work will start from week 2. The concepts introduced are presented in business scenarios. You will work on the case studies in the laboratory and do additional case project work each week to apply the concept learned in the laboratory. You are encouraged to work in groups. Group work will foster your ability to perform as part of a development team. You are encouraged to discuss the difficulties you are having with the assignment with your group partner or tutor. To achieve the aims and objectives of the unit, it is essential that you have access to the prescribed textbooks and that you complete the laboratory exercises and case project work on a weekly basis. If you understand your case study work you should achieve good results.

Assessment

You will be expected to undertake a number of assessments related to the learning outcomes of this unit (see below).The laboratory sessions on case study work are self-paced, with instructions provided through the textbook, lecture materials, unit Blackboard site and tutors. Additional problem-solving exercises are provided to help you self-assess your progress.
Tutors will be available in laboratories to answer questions. Unit-coordinator and duty tutors will also be available in person at specified times or via email to answer questions.

Assessment name: Case Study
Description: You will practice developing an information system in the context of specific cases provided using Oracle software tools. The case studies will draw together the material covered in lectures and textbooks. The studies will require you to apply the concept in additional case project work. Your ability to develop the system will be tested in a written examination to be held in the last week of the semester.
Relates to objectives: All
Weight: 40%
Internal or external: Internal
Group or individual: Individual
Due date: Week 13

Assessment name: Examination (Theoretical)
Description: Presented during the semester. All the questions will be drawn from the case studies.
Relates to objectives: All
Weight: 60%
Internal or external: Internal
Group or individual: Individual
Due date: Examination Period

Academic Honesty

QUT is committed to maintaining high academic standards to protect the value of its qualifications. To assist you in assuring the academic integrity of your assessment you are encouraged to make use of the support materials and services available to help you consider and check your assessment items. Important information about the university's approach to academic integrity of assessment is on your unit Blackboard site.

A breach of academic integrity is regarded as Student Misconduct and can lead to the imposition of penalties.

Resource materials

Textbooks:

1. Author:Carol McCullough-Dieter, Gavin Powell
Title: Oracle 1og Database Administrator, Implementation and Administration. (ISBN: 1-4188-3665-6)

No extraordinary charges or costs are associated with the requirements for this unit

Risk assessment statement

There is minimal health and safety risk in this unit. It is your responsibility to familiarise yourself with the Health and Safety policies and procedures applicable within Faculty's campus areas and laboratories.

Disclaimer - Offer of some units is subject to viability, and information in these Unit Outlines is subject to change prior to commencement of semester.

Last modified: 25-May-2012