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.
|
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 |