|
|
|
 |
O8iADMOracle8i database administration
This course gives database administrator Oracle of knowledge and skills for creation, supports and diagnostics of faults of databases of server Oracle7, Oracle8 or Oracle8i. Practical occupations fix a theoretical material. For an illustration of methods of diagnostics of failures in course the real situations meeting in practical operation of the world service of technical support Oracle are resulted. The course includes all themes of certified examination OCP for database administrators.
Essentials of course:
Start and a stop of a copy of database Oracle
Creation of an educational database
the File management of database Oracle
Handle of tabulared spaces, segments, extents and blocks
Handle of users, privileges and resources
Usage of resources of support of national languages (NLS)
the Circle of students:
Managers of databases
Advisers of the service of technical support
System administrators
Developers of applications.
Necessary preliminary preparation:
Common view about concepts of a relational database
the Operational experience with UNIX operating systems or MS Windows
the Program of course:
Components of the architecture of server Oracle
Tools of handle
Handle of copy Oracle
Creation of a database
Representations of the data dictionary and standard packages PL/SQL
Support of the control file and journal files
Handle of tabulared spaces and datafiles
Structures of storage of the information in a database
Handle of segments of rollback
Handle of tables and indexes
Support of data integrity
Loading of the data, a method of direct loading
Reorganization of the data, export and import of the data
Moving of the data with the help of moved tabulared spaces
For familiarity are recommended by server Oracle courses:
Introduction in Oracle8i: SQL
Introduction in Oracle8i: Bases PL/SQL
For the further training are recommended courses:
Administration of databases Oracle8i, a part 1: Backup and restoring
Administration of databases Oracle8i, a part 3: Administration in network environment
Administration of databases Oracle8i. a part 2: Optimization of productivity.
This course will help you to prepare for the next tests:
1Z0-023 Oracle8i: Architecture and Administration
Education coast on cource - USD 1250
Cource duration (days) - 5
|
|
