About This Course

Course Overview This training is offered in two different formats, instructor-led classroom or online training over the Internet. Oracle Developer/Administrator Certified Associate program is a unique program combining the required courses to become an Oracle Certified Associate both as a Developer and as an Administrator. This program helps to certify professionals who want to demonstrate they possess 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 an entry-level database administrator or application developer. To become an OCA one must pass all required exams. As an Oracle Certified Associate, you will cultivate industry-supported skills and credentials that you will be able to transfer to future employment opportunities. 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 Corporation the leader in Database Management Systems. Who Should Attend This Oracle OCA DBA exam review training is designed for the practicing Oracle professional but it is useful to anyone interested in learning Oracle database administration. This includes Oracle developers, Oracle DBAs, Oracle web developers and any computer professional who needs to understand the architecture of an Oracle database. The course assumes a basic knowledge of computer programming techniques, relational database concepts, SQL, and basic Oracle architecture. Course Objectives The primary objective of this Oracle OCA training is to provide each student with the knowledge and testing secrets for passing the Oracle OCA exam. The student will gain confidence in their Oracle DBA knowledge and learn the tricks and traps of the Oracle OCA DBA exam. At the end of the course, participants will be able to: Retrieve row and column data from tables with the SELECT statement, Create reports of sorted and restricted data, Employ SQL functions to generate and retrieve customized data, Display data from multiple tables using the ANSI SQL 99 JOIN syntax, Create reports of aggregated data, Use the SET operators to create subsets of data, Run data manipulation statements (DML) to update data in the Oracle Database, Run data definition language (DDL) statements to create and manage schema objects, Identify the major structural components of the Oracle Database 11g

• Follow us