|
|
|
 |
O8ADMOracle8 database administration
The main purpose of course - to acquaint students with the architecture of server Oracle8, to give knowledge and the skills necessary for creation, support of databases Oracle, diagnostics and elimination of problems. The got theoretical knowledge are fixed by intensive practical occupations under the direction of the teacher. Practical occupations and examples are real for all operating systems. Features of server Oracle8 for UNIX operating systems and MS Windows NT are informed. For problem solving the manager of databases appropriate software with a graphic interface are considered both SQL commands, and. For preparation of students for diagnostics of problems meeting in practice the questions, frequently set to the service of technical support of corporation Oracle are discussed. One of the purposes of course - to help with preparation for professional certified examinations Oracle. By the end of course you can start and stop a copy of database Oracle, create a database, control files of a database, tabulared spaces, segments, extents and blocks, to register new users, to control users, privileges and resources, and also to use resources of support of national languages of corporation Oracle.
Circle of students:
Managers of databases
Experts on technical support
System administrators
Developers of applications.
Necessary preliminary preparation:
Course " Introduction in server Oracle: SQL and PL/SQL ".
the Program of course:
- the Architecture of server Oracle
- Usage of tools of administration
- Handle of a copy of database Oracle
- Creation of a database
- Creation of representations of the data dictionary and standard packages PL/SQL
- Handle of tabulared spaces and datafiles
- Structures of the RAM
- Handle of segments of rollback
- Handle of temporary segments
- Handle of tables, indexes, clusters
- Protection of a database
- Loading and reorganization of the data
- Handle of users, profiles, and roles
- Audit of a database
For familiarity are recommended the privilege courses:
Introduction in Oracle8: SQL and PL/SQL
Oracle8: Development of program units on PL/SQL
For the further training courses are recommended:
Oracle8: Administration in network Oracle8 environment:
Practical work on saving and restoring of databases
Oracle8: the Seminar on customization of productivity.
Education coast on cource - USD 1250
Cource duration (days) - 5
|
|
