Archive for IT

Belajar Oracle secara otodidak

April 29, 2008 at 6:50 am · Filed under IT

Oracle itu sangat royal, terlalu gampang membagi knowledge. Kita bisa nge-download software Oracle RDBMS dan dokumentasinya (yang berisi bejibun e-book) secara gratis. Tentunya itu bukan semata-mata untuk meng-educate user (dan calon user), yang pasti intinya adalah bagaimana Oracle bisa dikenal banyak orang. Setelah itu orang memakai Oracle. Dan kemudian orang membayar lisence Oracle )

Berikut ini kiat-kiat belajar Database Oracle secara Otodidak. Saya mengambil contoh untuk yang versi 10g,versi-versi yang lainnya intinya sih sama saja.

I. Membaca dokumentasi Oracle.

Anda bisa membaca secara online di website Oracle. Anda pun bisa nge-download-nya dulu, kemudian membacanya secara offline di PC anda.

Berikut ini daftar dokumentasi database Oracle:
1. Untuk semua versi (8, 8i, 9i, 10g, dan 11g)
http://www.oracle.com/technology/documentation/index.html
2. Source dokumentasi 10g yang bisa di download
http://download.oracle.com/docs/cds/B19306_01.zip
3. Dokumentasi yang 10g yang bisa dibaca online
http://www.oracle.com/pls/db102/homepage

.

Dari mana mulai membacanya? Saya merekomendasikan untuk membaca tema-tema berikut, sebaiknya dibaca secara berurutan:

1. Oracle® Database Concepts
2. Oracle® Database 2 Day DBA
3. Oracle® Database Administrator’s Guide
4. Oracle® Database 2 Day + Performance Tuning Guide
5. Oracle® Database Performance Tuning Guide
6. Oracle® Database Backup and Recovery Basics
7. Oracle® Database Backup and Recovery Quick Start Guide
8. Oracle® Database Backup and Recovery Advanced User’s Guide

II. Install Software, dan Create Database Oracle di PC anda

Dapatkan source database Oracle di sini http://www.oracle.com/technology/software/products/database/index.html

Selanjutnya, buat database dan langsung praktekkan apa yang sedang (dan telah) anda pelajari. Gimana, mudah sekali, bukan?

di sunting dari: http://rohmad.net/2008/04/01/cara-belajar-database-oracle-secara-otodidak/

Leave a Comment

DBA Job Desc

April 22, 2008 at 9:09 am · Filed under IT

here is, if you want be DBA in IT environment… :

in the world so many database, this is depend on what you needed :) from embedded till enterprise scalable, here we go some database :

Oracale, MSSQL, firebird MSDE,MYSQL,INFORMIX and so many again, you can ask to uncle google :P

and the most commonly task of DBA is… :) i would you like to be aDBA database master, cause a lot of benefit you will get it… :)

  1. Installation and Configuration
    • Software Installation
    • Hardware and Software Configuration
  2. Security
    • Network Security
    • System Auditing
  3. Operations
    • Backup and Restore
    • User Management
    • Other Routine Maintenance
  4. Service Levels
      1. System Monitor
      2. SQL Server Enterprise Manager
      3. Third-party RDBMS monitors
      4. Network monitors
      5. User surveys
      6. Tools for monitoring disk space usage
    • Performance Tuning and Monitoring
    • example
    • Sizing and Capacity Planning
  5. System Uptime
    • Planning and Scheduling of System Downtime
    • Disaster Recovery
  6. Documentation
    • Configuration Documentation
      • Hardware configuration
      • Software components
      • Database configuration
      • Software tuning
    • System Log
      • Observations
      • System changes
      • System failures
      • Backup and restore operations
      • Scheduled maintenance
    • Design Documentation
    • Operational Maintenance Plans
      • Disaster Recovery Plans
  7. Design and Development
    • Data Modeling and Analysis
    • Database Design
    • Stored Procedure Development
    • Application Development
    • Information Sharing
  8. Miscellaneous
    • Cluster Administration
    • Replication Administration
    • Help Desk
    • Purchasing Input
    • Capacity Monitoring
    • Capacity Monitoring

Comments (1)