Student Login
Request A Free Damo
Call us now on 0800 0141 311
or 01273 907 919

Privacy and cookies

You are here: Home > Courses by occupation > Database Admin > OCA: 11g Administrator Certified Associate

OCA: 11g Administrator Certified Associate

Oracle certifications are industry-recognised, sought-after credentials that can help you succeed in your IT career.

The entry-level OCA 11g certification demonstrates your ability to install, maintain, troubleshoot and fine-tune all aspects of an Oracle database and is your first step towards more advanced Oracle certifications.

Quick course guide

Qualification: OCA: 11g Certified Associate Student support: 24x7 support by expert mentors
Study time: Full time: 21 days
Part time: 2 to 4 months		 Prerequisites: Familiarity with data processing concepts and techniques. Ability to use a graphical user interface (GUI)
Enrolment dates: Anytime, start now! Assessment:

Via external provider		 1Z0-047 or 1Z0-051 and 1Z0-052
Delivered by: Skillsoft Resources required:
    enquire now

Find out if OCA: 11g Administrator Certified Associate is right for you.
Contact a Learning Consultant for free expert advice.

Skills you'll gain

  • Retrieve data using the SQL SELECT statement
  • Display data from multiple tables
  • Use conversion functions and conditional expressions
  • Create an Oracle database
  • Manage database storage structures
  • Manage schema objects
  • Perform database backup and recovery
  • Move data

What's included

  • 24x7 access to high quality E-learning
  • Hands-on interactive LABS
  • Practice exams
  • 24x7 support by expert mentors
  • 12 months unlimited access
  • Study Guides
  • Class notes
  • Certification guarantee*

Who is this course for?

  • Database Administrators
  • Database Designers
  • Developer Support Engineers
  • Technical Administrators

Prerequisites for this course

Familiarity with data processing concepts and techniques. Ability to use a graphical user interface (GUI)

1Z0-047: Oracle Database SQL Expert

  • Oracle Database 11g: Using SQL to Query Your Database
  • Oracle Database 11g: Conversion Functions, Group Functions, and Joins
  • Oracle Database 11 g: Sub queries, Set Operators, and Data Manipulation
  • Oracle Database 11g: Using Ddl, Views, Sequences, Indexes, and Synonyms
  • Oracle Database 11g: Controlling User Access and Managing Schema Objects
  • Oracle Database 11g: Managing Data in Different Time Zones
  • Oracle Database 11 g: Using Sub queries and Regular Expressions

1Z0-051 Oracle Database 11g: SQL Fundamentals I

  • Oracle Database 11g: Using Sql to Query Your Database
  • Oracle Database 11g: Conversion Functions, Group Functions, and Joins
  • Oracle Database 11g: Subqueries, Set Operators, and Data Manipulation
  • Oracle Database 11g: Using Ddl, Views, Sequences, Indexes, and Synonyms

1Z0-052 Oracle Database 11g: Administration Workshop I

  • Oracle Database 11g Release 2: Database Architecture and Installation
  • Oracle Database 11g Release 2: Database Creation and Instance Management +
  • Oracle Database 11g Release 2: The Asm Instance and Network Connectivity
  • Oracle Database 11g Release 2: Storage Structures and User Security
  • Oracle Database 11g Release 2: Managing Concurrency, Undo, and Auditing
  • Oracle Database 11g Release 2: Managing Database Maintenance and Performance
  • Oracle Database 11g Release 2: Backup and Recovery
  • Oracle Database 11g Release 2: Moving Data and Oracle Support

Find out if OCA: 11g Administrator Certified Associate is right for you.
Contact a Learning Consultant for free expert advice.

Cisco

  • Companies that trust Skillsoft

  • Request a FREE course demo