Sunday, January 11, 2009

Best Way to learn Oracle DB

Its imperative for one to understand the importance of Database in this information age.
The best approach would be as follow

1) What is a Database ?
2) Available RDBMS (Relational Database Management Systems) Tools / Technologies.

There are multiple database products available in the market, some of the popular ones are as foll

Oracle by Oracle Corp
SQL Server by Microsoft Corp
Db 2 by IBM Corp

3) Languages to communicate with Databases
* Procedural Language
* SQL - Structured Query Language

Each database vendor has their own tool under different name to communicate with their Database. Each such tool slightly differ from other but does similar function,
Add, Delete, Edit & Update of data.

Now comes the reporting part.

The data stored in the database have to be extracted for reporting purposes and there are multiple reporting tools available from various vendors.

Oracle has their own reporting tool called "Discoverer", which is commonly used by Oracle database users.

The popular tools are Crystal Reports, Cognos Etc.
Selection of any particular database or reporting tools largely depends upon the customers based on their business needs, budgets and preferences.

I feel if you learn the concept / structure of RDBMS (Relational Database Management System) and reporting tools, it will help you embark on a successful career journey.

0 komentar: