|
|
|
 |
O8i-DBAOracle8i architecture and administration fundamentals
This course gives Oracle database administrator a hard fundsmentals for solution of administrative tasks, and also knowledge and skills for creation, supports and diagnostics of databases Oracle7, Oracle8 or Oracle8i. Practical exercises help to fix the received knowledge. Students receive possibility to diagnose real situations, answering the questions most frequently set to world support service Oracle. The course includes all themes of certified examination for database administrators.
Upon termination of course students will learn:
- to understand components of the architecture of database server Oracle;
- to start and close a copy and database Oracle;
- to create a working database;
- to control tabulared spaces, segments, extents and blocks;
- to use representations of the data dictionary and standard packages;
- to accompany with the control file and journal files;
- To control segments of rollback;
- to control tables and indexes;
- to understand support of data integrity;
- to carry out loading the data, to use method Direct Path;
- to carry out reorganization of the data, export and import;
- to move the data with the help of moved tabulared spaces;
- to control passwords, resources, users, privileges and roles;
- to use resources of support of national languages (NLS). Necessary preparation Starting to learning course, students should:
- to understand concepts of a relational database;
- to know main operating systems;
- to understand concepts of stored procedures, functions and packages. It is recommended to hear course: O8i-SPL or to possess equivalent knowledge.
Education coast on cource - USD 825
Cource duration (days) - 5
|
|
