Pre-Requisite Modules	Co-Requisite Modules	ECTS Credits	Module Code
SENG2201 PROG2301	NONE	5	SENG4205

This module enables the user to install and configure the database, create and administer user accounts in the database, backup and recover the database, monitor, troubleshoot, and maintain the database and configure network services for the database.

The aim of this module is to enable the student to gain a conceptual understanding of the Database architecture and how its components work and interact with one another. Students will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques.

On completion of this module, the learner will be able to:

• Install and configure the Database
• Create and administer user accounts in the Database
• Backup and Recovery of the Database
• Monitor, troubleshoot, and maintain the Database
• Configure Network services for the Database

The learning methods will be three-fold:  Lectures (One hour per week) will impart the theory behind the techniques being used; Tutorials (one hour per week) will develop practical applications that will be implemented in practical classes (2 hours per week). Practicals will be done individually installing a database server.

Core database administrator tasks, Learn to identify system requirements using optimal flexible architecture

Install database software.

Describe Database Architecture, Understand the instance architecture, Use the management framework and the Database Creation Assistant

Look at database interfaces such in non-procedural, procedural and OO languages.

Control the database by starting and stopping the agent, the enterprise manager database console, the listener and by starting up and shutting down the database.

Learn about storage structures; tablespaces and data files.

Create and manage database user accounts, roles, privileges and control resource usage by users.

Revise the use of tables, constraints, indexes and views, DML , Import and export.

Revise the use of embedded objects, triggers and triggering events and identify configuration options that affect performance

Apply privileges and set up default accounts, implement password security and audit activity.

Create and configure listeners, using listener control utility, configure client and middle-tier connection, test network connectivity

Learn about Shared Servers and check performance. Maintain, undo, manage locking.

Database backup, restore and recovery

Continuous Assessment will include both lab tests and programming assignments (50%).  End of module examination will test theoretical knowledge and design. (50%)

"Portable DBA Oracle Essential Techniques for the Day-to-Day DBA", Robert G.Freeman, Oracle Press 2005

"Oracle Database 10g DBA Handbook, 1st Edition, Loney, K., Bryla, B. McGraw Hill 2005.

"High-Performance Oracle: Proven Methods for Achieving Optimum Performance and Availability", Ingram,G., Wiley 2002

"Mastering SQL Server 2000 Security", Young, M., Curtis W. Young Wiley 2002

"DataBase Systems: A Practical Approach to Design, Implementation and Management", Fourth Edition, Connolly,T., Begg,C. Addison-Wesley 2005

http://www.oracledba.co.uk/, course web page.

Class to be split into groups of no more than 25.

4 hours contact per week.

To be delivered in one semester module.

On completion of this course, the student should be eligible to submit for examination to become an Oracle Database Administrator Certified Associate

June 2005