|
|
|
 |
O9iDBAOracle 9i DBA Fundamentals I
This course opens a series of courses on bases of handle of server Oracle. The main purpose of course - to give the database administrator of knowledge and the skills necessary for creation and support of database Oracle, and also permissions of typical problems. The course is oriented to learning of Oracle architecture and the primary goals of the database administrator. Students study planning and creation of a database, handle of copy Oracle, a memory management, physical and logical database structures, support of users and privileges. The course is carried out under the direction of the instructor as lectures and practical occupations.
the Circle of students:
Managers of databases
Analytics of a support service
System administrators
Developers of applications.
Necessary preliminary preparation:
knowledge in size of courses " Introduction in Oracle9i: SQL " and " Introduction in Oracle9i: PL/SQL "
understanding of concepts of a relational database
knowledge of bases SQL, SQL*Plus, PL/SQL
knowledge of bases of operating systems
an operational experience in Oracle environment.
The program of course:
Components of Oracle architecture
Beginning of operation with Oracle Server
Handle of copy Oracle
Creation of a database
the Data dictionary - a contents and application
Support of the control file
Support of journal files
Handle of tabulared spaces and datafiles
Structure of data storage, logical links
Data management of rollback
Handle of tables
Handle of indexes
Support of data integrity
Handle of passwords, resources, users, privileges and roles
Globalization resources usage.
Education coast on cource - USD 1250
Cource duration (days) - 5
|
|
