ORACLE: Certificate of Attendance
(Oracle9i Database Administration Fundamentals I)
(Oracle9i Database Administration Fundamentals I)
COURSE TOPICS: Oracle Architectural Components
* Defining an Oracle Database, the Oracle server, and the Oracle Instance
* Establishing a connection and creating a session
* Understanding the physical structure
* Understanding the memory structure
* Understanding the process structure
* Understanding the logical structure
* Outlining the stages of an SQL statement
Getting Started with the Oracle Server
* Identifying database administrative tools
Identifying the features of the Universal Installer
Defining the Optimal Flexible Architecture
Creating a database during installation
Creating a new database
Identifying database administrative users
* Understanding operating system and password file authentication
* SQL*Plus
* Enterprise Manager
Managing an Oracle Instance
* Creating, managing, and using initialization files: PFILE and SPFILE
* Identifying the various states of starting an instance
* Identifying the various options available to shutdown an instance
* Monitoring Alert and Trace files
Creating a Database
* Using the Database Configuration Assistant to create a database
* Creating a database manually
Using the Data Dictionary
* Identifying the uses and contents of the data dictionary
* Using the data dictionary to retrieve information about the database
Maintaining the Control File
* Explaining the uses of the control file
* Listing the contents of the control file
* Multiplexing the control file
* Managing control file with Oracle Managed Files (OMF)
* Obtaining control file information
Maintaining Redo Log Files
* Explaining the purpose of and how online redo log files work
* Control log switches and checkpoints
* Maintaining online redo log files
* Managing online redo log files using OMF
* Multiplexing and maintaining online redo log files
* Archiving online redo log files
* Obtaining online and archived redo log file information
Managing Tablespaces and Datafiles
Describing storage hierarchy
Establishing the difference between SYSTEM and Non-SYSTEM tablespaces
* Creating and managing tablespaces
* Creating a tablespace when using OMF
* Obtaining tablespace and datafile information
Storage Structures and Relationships
* Describing the logical structure of the database (segments, extents, blocks)
* Listing the segment types and their uses
* Understanding the use of extents and their allocation and deallocation
* Understanding the structure of a database block
* Maintaining storage structures with automatic segment - space management
* Maintaining storage structures manually
* Obtaining storage structure information
Managing Undo Data
* Understanding the difference between automatic undo management and manual undo management
Creating and maintaining UNDO tablespaces
* Obtaining undo information
Managing Tables
* Creating and maintaining tables using appropriate storage settings
* Obtaining table information
Managing Indexes
* Listing the different types of indexes and their uses
* Creating b-tree and bitmap indexes
* Maintaining Indexes
Identifying unused indexes
* Obtaining index Information
COURSE OBJECTIVES:
* Manage tablespaces, segments, extents, and blocks
* Manage users, privileges, and resources
* Create an operational database
* Start up and shut down an Oracle instance and database
* Manage Oracle database files
* Use Globalization Support features
