HomeCareerLoginContact UsITnium Computers, Sangli
Skip Navigation Links
Our CoursesExpand Our Courses
CADExpand CAD
CertificationExpand Certification
Testing ServicesExpand Testing Services
Internship
JobExpand Job
IntranetExpand Intranet
    

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