OCA: 11g Administrator Certified Associate training course

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.

Free course demo
Free course demo
Hide
To get started on this course please call one of our learning consultants now on:
0800 0141 311 or 01273 907 919
To get started on this course please call one of our learning consultants now on:
0800 0141 311 or
01273 907 919
Or enter your details below and one of our learning consultants will get back to you within the next 24 hours
Sign up to our newsletter
Qualification
OCA: 11g Certified Associate
Study time
Full time: 21 days | Part time: 2 to 4 months
Enrolment dates
Anytime, start now!
Delivered by
Student support
24x7 Support by expert mentors
Prerequisites
Familiarity with data processing techniques. Ability to use a GUI
Assessment - via external provider
1Z0-047 or 1Z0-051 and 1Z0-052
Resources required
Internet access and email

This course is ideal 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)

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

24x7 access to high quality elearning
Hands-on interactive LABS
Practise exams
24x7 support by expert mentors
12 months unlimited access
Study Guides
Class notes
Certification guarantee

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

Average salary trend for an OCA certified professional

Average Salary

Source: ITjobswatch.co.uk

Which course is right for me?
Request a free course demo
Get your career moving
join The Learning People
Experience the worlds most popular cloud based learning platform
Unbiased career advice
Expert insight from industry leaders
You are joining one of the UK's fastest growing learning communities
The Certified - news and views, directly to your mailbox
All UK students recieve an NUS card
Free course demo
Free course demo
Hide
Damian Watson
"Very happy with the cost of the course!"
Damian Watson, Project Manager
Call us now on 0800 0141 311 or 01273 907 919
Social