With your OCA certification, you will be able to demonstrate and promote the fact that you have the necessary skills to do your job effectively and you are certified by Oracle Coprporation the leader in Database Management Systems.

The following tables show the exams and the corresponding courses for OCA.

Students learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques.

The lesson topics are reinforced with structured hands-on practices.

includes a ton of features that not only make jobs simpler—but in some cases, some common time-consuming operations have also been reduced to virtually one line.

In this installment you will learn about some of those features.

In this class, students learn how to install and maintain Oracle Database 11g.

Students gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another.

Of course, Jill can just keep on typing the same command over and over again until she gets an exclusive lock—or goes nuts, whichever comes first.

Jill the DBA at Acme Retailers is trying to alter the table called SALES to add a column, TAX_CODE.

It's pretty routine stuff; she issues the following SQL statement: The error message says it all: the table is being used right now, probably by a transaction, so getting an exclusive lock on the table may be next to impossible.

This program helps to certify professionals who want to demonstrate they posses the knowledge and hands-on skills required to support Oracle's products.

At this skill level, OCA has the foundation of knowledge that will allow him/her to act as a entry-level database administrator or application developer. As a Oracle Certified Associate, you will cultivate industry-supported skills and credentials that you will be able to transfer to future employment opportunities.