I.

II.

Prerequisite:

See recommendation in Course (Catalog) Description

III.

Course (Catalog) Description:

Course provides conceptual understanding of Oracle database architecture and how its components work and interact with one another to perform administrative tasks used by the database administrator. Content includes how to design, create, maintain, manage, and troubleshoot an Oracle database; how to startup and shutdown a database; create a database, manage file and database storage; manage users and their privileges, organize the database and move data into and between databases under different environments. Course prepares student for the corresponding Oracle Database Administrator certification exam. Recommended: CIS143 or comparable knowledge.

IV.

Learning Objectives:

V.

Academic Integrity:

Students and employees at Oakton Community College are required to demonstrate academic integrity and follow Oakton's Code of Academic Conduct. This code prohibits:

There are serious consequences to violations of the academic integrity policy. Oakton's policies and procedures provide students a fair hearing if a complaint is made against you. If you are found to have violated the policy, the minimum penalty is failure on the assignment and, a disciplinary record will be established and kept on file in the office of the Vice President for Student Affairs for a period of 3 years.

Details of the Code of Conduct can be found in the Student Handbook.

VI.

Outline of Topics:

1. Oracle Architectural Components
   1. Defining an Oracle database, the Oracle server, and the Oracle instance
   2. Establishing a connection
   3. Understanding the physical structure
   4. Understanding the memory structure
   5. Understanding the process structure
   6. Understanding the logical structure
2. Identifying Database Administrative Tools
3. Universal Installer Features
4. Optimal Flexible Architecture
5. Creating a Database During Installation
6. Creating a New Database
7. Identifying Database Administrative Users
   1. Understanding operating system and password file authentication
   2. Using SQL Plus
   3. Enterprise manager
8. Managing an Oracle Instance
   1. Creating, managing, and using initialization files: PFILE and SPFILE
   2. Identifying the various states of starting an instance
   3. Identifying the various options available to shutdown an instance
   4. Monitoring alert and trace files
9. Creating a Database
   1. Using the database configuration assistance to create a database
   2. Creating a database manually
10. Using the Database Dictionary
    1. Identifying the uses and contents of the data dictionary
    2. Using the data dictionary to retrieve information about the database
11. Maintaining the Control File
    1. Uses of the control file
    2. Listing the contents of the control file
    3. Multiplexing the control file
    4. Managing control file with Oracle Managed Files (OMF)
    5. Obtaining control file information
12. Maintaining Redo Log Files
    1. Explaining the purpose of and how online redo log files work
    2. Control log switches and checkpoints
    3. Maintaining online redo log files
    4. Managing online redo log files using OMF
    5. Multiplexing and maintaining online redo log files
    6. Archiving online redo log files
    7. Obtaining online and archived redo log file information
13. Managing Tablespaces and Datafiles
14. Describe Storage Hierarchy
15. SYSTEM and Non-SYSTEM tablespaces differences
    1. Creating and managing tablespaces
    2. Obtaining tablespace and datafile information
16. Storage Structures and Relationships
    1. Describe the logical structure of the database (segments, extents, blocks)
    2. List the segment types and their uses
    3. Understand the use of extents and their allocation and deallocation
    4. Understand the structure of a database block
    5. Maintain storage structures with automatic segment
    6. Maintain storage structures manually
    7. Obtain storage structure information
17. Managing Undo Data
    1. Understand the difference between automatic undo management and manual undo management
    2. Creating and maintain undo tablespaces
    3. Obtaining undo information
18. Managing Tables
    1. Creating and maintaining tables using appropriate storage settings
    2. Obtaining table information
19. Managing Indexes
    1. List the different types of indexes and their uses 2. Create b-tree and bitmap indexes 3. Maintaining indexes
    4. Identifying unused indexes
    5. Obtaining index information

VII.

Methods of Instruction:

Reading, lecture, discussion, group work, demonstrations , hands-on exercises and projects, assignments, quizzes, and/or tests

VIII.

Course Practices Required:

IX.

Instructional Materials:

X.

Methods of Evaluating Student Progress:

XI.

Other Course Information:

If you have a documented learning, psychological, or physical disability you may be entitled to reasonable academic accommodations or services.  To request accommodations or services, contact the ASSIST office in the Learning Center.  All students are expected to fulfill essential course requirements.  The College will not waive any essential skill or requirement of a course or degree program.