Thalasar Ventures

Nowadays most of the companies are heading towards computerized processing as every organization has a huge database of its own to manage, also the size of database further increases if computers are linked with a network which is a quite common scenario everywhere. To deal with management and troubleshooting of these huge databases, companies look for qualified professionals and with Oracle certification in your hands you are a suitable candidate for the job. That’s why; this certificate has its unique value everywhere and in almost every sector.

To get certificated in the oracle you have to follow this procedure.

For the first level of certification (Oracle Certified Associate) as a DBA you are required to pass two exams – one exam to ensure you understand the fundamentals of SQL:-

Introduction To Oracle9i: SQL (#1Z0-007) or

Oracle Database 11g: SQL Fundamentals I (#1Z0-051)

When preparing for the Oracle Certified Professional (OCP) qualification the resources to use depend to a certain extent on the certification path and the level of certification you want to obtain. The first thing we need to do therefore is to explain the different certification paths and the levels and then we can discuss the best learning resources.

And a second exam to ensure you understands the fundamentals of database administration: Oracle Database 11g:

Obviously therefore to pass the first exam we need to know SQL. Good resources for learning this include O’Reilly’s book “SQL in a Nutshell” their always good. SQL tutorials are available from many web sites. The second exam on database administration fundamentals requires knowledge of the following topics:

* Installing and Configuring Oracle
* Creating and Managing an Oracle Database
* Administering an Oracle Database
* Configuring the Oracle Network Environment
* Creating and Managing Database Storage Structures
* Managing Redo Log Files and Control Files
* Managing Schema Objects
* Managing Users, Profiles, Privileges and Roles
* Managing Undo Data and Temporary Segments
* Monitoring and Resolving Lock Conflicts
* Maintaining Database Security
* Monitoring the Performance of the Database
* Loading and Unloading Data
* Backing Up and Recovering the Database
For more information on Oracle Training you can visit http://www.sapware.net