Monday, April 7, 2008

How to self-learn Oracle Database

Oracle is too kind to share knowledge. We can read Oracle documentation (contain unlimited knowledge) online in the web. We also can download Oracle DBMS (Database Management System) software and documentations freely.

Oracle really want to educate its user and everyone who eager to learn Oracle products. Of course, the goal is to make everyone use Oracle products, and then everyone pay Oracle license.

Through this article I share tips & tricks self learning of Oracle Database. I take Oracle Database 10g as example.

I. Read Oracle documentation.

You can read Oracle documentation online in internet. By download the source first, you can also read the documentation off line in your PC.

Here is the list of Oracle Documentation
1. Index of all documentation (8, 8i, 9i, 10g, dan 11g)
2. Documentation source of 10g version, ready to be downloaded.
3. Documentation source of 10g version, ready to be read online.

There are so many-many documentation and knowledge. How to start? I recommend to read following documentation one by one (please read in order manner).

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, and Create Oracle Database in your PC

Get the database source (software) here Follow the instruction to download the source.

Then, create a database in your PC. Practice your knowledge here. It is very easy to self-learn Oracle Database, isn't it?