Maricopa Community Colleges CIS117DP 19992-20015

Maricopa Community Colleges CIS117DP 19992-20015

Official Course Description: MCCCD Approval: 11/24/98
CIS117DP 19992-20015	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: [(CIS117DO and CIS122AC) or previous UNIX operating system experience], or permission of instructor.

Go to Competencies Go to Outline

MCCCD Official Course Competencies:

CIS117DP 19992-20015	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:

CIS117DP 19992-20015	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