Oracle Certified Associate Certification

Oracle Certified Associate Certification

oca-logo

Oracle Certified Associate Certification Exam :

  • Step 1 – Pass One Exam
    Oracle Database 11g: SQL Fundamentals I Exam Number : (1Z0-051)
    OR
    Oracle Database SQL Expert Exam Number : 1Z0-047
  • Step 2 – Pass Exam
    Oracle Database 11g: Administration I Exam Number : (1Z0-052)Complete the above 2 exams to become “Oracle Database 11g Administrator Certified Associate Certification-OCA”

Syllabus for Oracle Certified Associate Certification Exam

Oracle Database 11g: SQL Fundamentals I Exam Number : (1Z0-051)
  • 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 Sub queries to Solve Queries
  • Using the Set Operators
  • Manipulating Data
  • Using DDL Statements to Create and Manage Tables
  • Creating Other Schema Objects
Oracle Database 11g: Administration I Exam Number : (1Z0-052)
  • Exploring the Oracle Database Architecture
  • Preparing the Database Environment
  • Creating an Oracle Database
  • Managing the Oracle Instance
  • Configuring the Oracle Network Environment
  • Managing Database Storage Structures
  • Administering User Security
  • Managing Data and Concurrency
  • Managing Undo Data
  • Implementing Oracle Database Security
  • Database Maintenance
  • Performance Management
  • Intelligent Infrastructure Enhancements
  • Backup and Recovery Concepts
  • Performing Database Backups
  • Performing Database Recovery
  • Moving Data

Drop us a query

Course Features

Get Practical and Well focused training from Top IT Industry experts.

Get Routine assignments based on learning from previous classes.

Live project, during or after the completion of the syllabus.

Lifetime access to the learning management system including Class recordings, presentations, sample code and projects

Lifetime access to the support team (available 24/7) in resolving queries during and after the course completion

Get certification after the course completion.

Scholarship Exam +91-9711526942 whatsapp

Testimonials