Oracle Database Administration

Waktu : 5 hari @ 6 jam efektif
Kode : O-DBA

TUJUAN RINGKASAN MATERI
Tujuan pelatihan ini adalah untuk memberikan landasan kemampuan dalam pengelolaan basis data, khususnya pada RDBMS Oracle7.
PESERTA

Individu yang bekerja di bidang Teknologi Informasi / Pengolahan Data Elektronis, khususnya yang bekerja sebagai Database Administrator, System Administrator, Network Manager, Technical Manager, dan Technical Support Personnel.
Peserta diharapkan telah mengikuti pelatihan Introduction to Oracle.


Oracle7 System Architecture
* Oracle7 Server Architecture: Components, Functions and Processes
Start up and Shut Down a Database
* SVRMGRL and Server Manager
* Startup and Startdown
Create a Database
* Designing a Phisycal Database
* Creating a Database
* Mirroring Files
* Creating a Password File
Access and Update Data
* SELECT and UPDATE Operation
* Defered Writes
* Redo Generation
Manage Database Structure
* Manage Tablespace
* Manage Rollback Segments
Manage Database Segments
* Extent Allocation
* Row Chaining and Migration
Manage Database Objects
* Manage Tables
* Manage Indexes
* Manage Bitmap Indexes
* Manage Index Clusters
* Manage Hash Clusters
* Manage Constraints
Manage Database Users
* Enroll, Monitor and Drop Users
* Restrict Resource Usage
* Manage System Priveleges
* Manage Object Priveleges
* Manage Roles

[Daftar Isi] [Y P T E] [Home]

© 1997 ELEKTRO Online and INDOSATnet.
All Rights Reserved.

1