HomeHomeCareerLoginContact UsITnium Computers, Sangli
Skip Navigation Links
SoftwaresExpand Softwares
CertificationExpand Certification
Testing ServicesExpand Testing Services
JobExpand Job
V-Class RoomExpand V-Class Room

Oracle DBA : OCA Certification

The Oracle Certified Associate (OCA) certification is the first level of certification for Oracle Developer. Individuals who hold this credential have demonstrated that they have mastered introductory Oracle skills and can perform foundation level tasks. It is necessary to hold this certification before moving on to the Oracle Certified Professional (OCP) level and ultimately the Oracle Certified Master (OCM) level.


Candidates must complete two exams in order to complete the requirements for the OCA DBA credential. They have a choice of three exams for their first exam:


Core Exam Two Exams Required
Exam 1Z0-051 Oracle database 11g:SQL Fundamentals I
Exam 1Z0-052 Administration-I

Course Contents:


Exam 1Z0-051: Oracle database 11g:SQL Fundamentals I


  • Retrieving Data Using the SQL SELECT Statement
  • Restricting and Sorting Data
  • Using Single-Row Functions to Customize Output
  • Using Conversion Functions and Conditional Expressions
  • Reporting Aggregated Data Using the Group Functions
  • Displaying Data from Multiple Tables
  • Using Subqueries to Solve Queries
  • Using the Set Operators
  • Manipulating Data
  • Using DDL Statements to Create and Manage Tables


Exam 1Z0-052: Administration-I


  • Overview of PL/SQL Programs
  • Creating Procedures
  • Creating Functions
  • Managing Subprograms
  • Creating Packages
  • Oracle Supplied Packages
  • Manipulating Large Objects
  • Creating Database Triggers
  • More Trigger Concepts


Study Material




ITnium Computer