This course is designed to give the
Oracle database administrator (DBA) a firm foundation in
basic administrative tasks and provide the necessary knowledge
and skills to set up, maintain, and troubleshoot an Oracle7,
Oracle8, or Oracle8i database. The student learns to use
an administration tool to startup and shutdown a database,
create a database, manage file and database storage, and
manage users and their privileges. In addition, the student
learns to organize the database and to move data into and
between databases, under different environments. Hands-on
practices help to reinforce key concepts, and students have
an opportunity to troubleshoot real life issues when they
are given examples of questions frequently asked of Oracle
Worldwide Support.
This course is designed to prepare
you for the corresponding Oracle Certified Professional
exam: Exam #1Z0-001.
Introduction to Oracle:
SQL & PL/SQL
Basic operating system knowledge
Relational database concepts
Stored procedures, functions and packages - Concepts
Create an operational database
Manage Oracle database files
Manage tablespaces, segments, extents and blocks
Start up and shut down an Oracle instance and database
Manage users, privileges and resources
Use National Language Support Features
Describing the Oracle Architecture
and Its Main Components
Listing the Structures Involved in Connecting a User to
an Oracle Instance
Listing the Stages in Processing: Queries, Data Manipulation
Language (DML) Statements, and COMMITs
Identifying the Features of the Universal
Installer
Setting Up Operating System and Password File Authentication
Listing the main components of Oracle Enterprise Manager
and their uses
Creating the Parameter File
Starting Up an Instance and Opening the Database
Closing a Database and Shutting Down the Instance
Getting and Setting Parameter Values
Managing Sessions
Monitoring the ALERT File and Trace Files
