MCCCD Official Course Competencies:

CIS119DP  2004 Summer I – 2012 Spring

Oracle: Database Administration

1.

Startup and shutdown an Oracle instance and database. (I, II)

2.

Create a database. (I, II)

3.

Manage logical and physical database storage. (III)

4.

Manage users and their privileges. (II, III)

5.

Use Globalization Support Features (II)

MCCCD Official Course Outline:

CIS119DP  2004 Summer I – 2012 Spring

Oracle: Database Administration

I. Managing an Oracle Database

A. Examine Oracle architectural components

B. Define the Optimal Flexible Architecture

C. Managing an Oracle instance

D. Creating an operational database

E. Using the data dictionary

F. Maintaining the control file

G. Maintaining redo log files

H. Managing tablespaces and data files

I. Describing storage hierarchy

J. Establishing the difference between SYSTEM and Non-SYSTEM tablespaces

K. Storage structures and relationships

L. Managing undo data

M. Automatic undo management vs. manual undo management

N. Creating and managing UNDO tablespaces

O. Managing tables

P. Managing indexes

II. Ensuring Data Integrity

A. Maintaining data integrity constraints

B. Using clusters and index-organized tables

C. Loading and reorganizing data

D. Managing security

E. Specifying National Language Support (NLS)

F. Using NLS features

III. Managing Database Users

A. Identifying database administrative users

B. Enrolling, monitoring, and dropping database users

C. Creating and managing default and specific user profiles

D. Granting database privileges

E. Managing roles and resources

F. Examining auditing