Maricopa Community Colleges CIS119DP 20016-20042

Maricopa Community Colleges CIS119DP 20016-20042

Official Course Description: MCCCD Approval: 05/22/01
CIS119DP 20016-20042	L+L	3 Credit(s)	4 Period(s)
Oracle: Database Administration
Develops a conceptual understanding of the Oracle database architecture and reinforces learning with structured hands-on practices. Designed to give the Oracle database administrator (DBA) a firm foundation in basic administrative tasks. Prerequisites: CIS119DO, or CIS126AA, or CIS126DA, or permission of instructor.

Go to Competencies Go to Outline

MCCCD Official Course Competencies:

CIS119DP 20016-20042	Oracle: Database Administration

1.	Startup and shutdown an Oracle instance and database. (I, II)
2.	Create a database. (I, II)
3.	Manage file and database storage. (III)
4.	Manage users and their privileges. (II, III)

Go to Description Go to top of Competencies

MCCCD Official Course Outline:

CIS119DP 20016-20042	Oracle: Database Administration

A. Starting up and shutting down a database

B. Creating an operational database

C. Managing Oracle database files

D. Maintaining redo log files

E. Managing tablespaces and data files

F. Managing rollback and temporary segments

G. Managing tables, indexes, and physical storage

H. Examining and managing extents and blocks

A. Maintaining data integrity constraints

B. Using clusters and index-organized tables

C. Loading and reorganizing data

D. Managing security

A. Enrolling, monitoring, and dropping database users

B. Creating and managing default and specific user profiles

C. Granting database privileges

D. Managing roles and resources

E. Examining auditing

F. Specifying National Language Support (NLS)

G. Using NLS features

Go to Description Go to top of Competencies Go to top of Outline