Standard

Posted: 09/06/07

R State Standard

£ Institutionally Developed

College: n/a

CIS 2129 – Oracle Database Administration

Course Description:

This course enables the database student to be able to fine tune Oracle databases. Topics include: Oracle architectural components, Oracle administration tools, Oracle instances, creation of an Oracle database, construct Data Dictionary views, Maintain the control file, Maintain the Redo Log File, Manage table spaces and data files, Understand relationships and impacts on storage structures, Manage tables, indexes and segments, maintain data integrity, manage users, profiles, privileges, roles, understand and use database auditing options, using National Language Support (NLS). Topics include: understand Oracle architectural components, understand and use Oracle administration tools, manage Oracle instances, be able to create an Oracle database, construct Data Dictionary views, maintain the control file, maintain the Redo Log File, manage table spaces and data files, understand relationships and impacts on storage structures, manage tables, indexes and segments, maintain data integrity, manage users, profiles, privileges, roles, understand and use database auditing options, using National Language Support (NLS), and establish competencies for Oracle Database Administration Exam.

Competency Areas:	Hours:
Understand Oracle architectural components	Class	4
Understand and use Oracle administration tools	D. Lab	6
Manage Oracle instances	P. Lab/O.B.I.	0
Be able to create an Oracle database	Credit	7
Construct Data Dictionary views
Maintain the control file
Maintain the Redo Log File
Manage table spaces and data files
Understand relationships and impacts on storage structures
Manage tables, indexes and segments
Maintain data integrity
Manage users, profiles, privileges, roles
Understand and use database auditing options
Using National Language Support (NLS)
Establish competencies for Oracle Database Administration Exam

Prerequisite:   CIS 105, CSI 106, CIS 214, and SCT 100

Corequisite: 

Course Guide

Competency	After completing this section, the student will:	Hours
		Class	D. Lab	P. Lab/ O.B.I.
UNDERSTAND ORACLE ARCHITECTURAL COMPONENTS		4	6	0
	Be able to describe the Oracle server architecture and its main components and list the structures involved in connecting a user to an Oracle instances and also list the stages in processing: queries, DML statements, COMMITS.
UNDERSTAND AND USE ORACLE ADMINISTRATION TOOLS		2	3	0
	Be able to identify the features of the Universal Installer. Set up operating system and password file authentication. List the main components of Oracle Enterprise Manager and their uses.
MANAGE ORACLE INSTANCES		2	3	0
	Be able to create the parameter file, start up and instance and open the database, close a database and shut down the instance, get and set parameter values, manage sessions, monitor the ALERT file and the trace files.
BE ABLE TO CREATE AN ORACLE DATABASE		4	6	0
	Be able to prepare the operating system, prepare the parameter file, and  create the database
CONSTRUCT DATA DICTIONARY VIEWS		2	3	0
	Construct the data dictionary views, Query the data dictionary, Prepare the PL/SQL environment using the administrative scripts, and administer stored procedures and packages.
MAINTAIN THE CONTROL FILE		2	3	0
	Explain the uses of the control file, list the contents of the control file, multiplex the control file, and obtain control file information.
MAINTAIN THE REDO LOG FILE		2	3	0
	Explain the use of online redo log files, obtain log and switches and checkpoints, multiplex and maintain online redo log files, plan online redo log files, troubleshoot common redo log file problems, and analyze online and archived redo logs.
MANAGE TABLE SPACES AND DATA FILES		2	3	0
	Distinguish the different types of temporary segments, create tablespaces, change the size of tablespaces, allocate space for temporary segments, change the status of tablespaces, change the storage setting of tablespaces, and relocate tablespaces.
UNDERSTAND RELATIONSHIPS AND IMPACTS ON STORAGE STRUCTURES		4	6	0
	Describe the logical structure of the database, list the segment types and their uses, list the keywords that control block space usage, obtain information about storage structures form the data dictionary, and list the criteria for separating segments.
MANAGE TABLES, INDEXES AND SEGMENTS		4	6	0
	Create and maintain rollback segments using appropriate storage settings, Create and maintain tables using appropriate storage settings, and list the different types of indexes and their uses and create B-tree and bitmap indexes, drop indexes.
MAINTAIN DATA INTEGRITY		2	3	0
	Implement data integrity constraints, maintain integrity constraints, and obtain constraint information form the data dictionary.
MANAGE USERS, PROFILES, PRIVILEGES, ROLES		4	6	0
	Create, alter, and drop database users, identify system and object privileges, grant and revoke privileges, create and modify roles, control and remove roles
UNDERSTAND AND USE DATABASE AUDITING OPTIONS		2	3	0
	Be able to identify auditing capabilities.
USING NATIONAL LANGUAGE SUPPORT (NLS)		2	4	0
	Be able to choose a character set and national character set for a database, specify the language-dependent behavior using initialization parameters, environment variables, and the ALTER SESSION command, and use the different types of NLS parameters.
ESTABLISH COMPETENCIES FOR ORACLE DATABASE ADMINISTRATION EXAM		2	2	0
	Upon completion of this course, the student should be prepared to take the ORACLE Database Administration Exam.

Suggested Resources

Books:

Enhanced Guide to Oracle by Joline Morrison and Mike Morrison, Course Technology, ISBN: 0619035498

Oracle SQL Interactive Workbook by Alex Morrison and Alice Rischart, Prentice Hall, ISBN: 0130157457

Oracle SQL Plus: The Definitive Guide by Jonathan Gennick Deborah Russel, O'Reilly & Associates, Incorporated ISBN: 1565925785