#!/usr/bin/php4 SJSC Smara-Dialog. Network Academy
 Registration Exit      
Main | About us | Network Academy | System integration | Science
Computers | Web-studio | Advertising agency | Tourists agency

News
About Academy
Education
Complex programs
Sertification
Cources schedule
Tests center
Contacts
Microsoft Gold Certified Partner
Wonderware Certified Training Provider

O8i-DBA

Oracle8i 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
 © SJSC Samara-Dialog, 1998-2003. All rights reserved.
Rambler's Top100