Oracle Database 11g Administrator Certified Associate (OCA 11g)
Certification Training
Validate your skills in keeping an Oracle database environment running at maximum efficiency with the Oracle Database 11g Administrator Certified Associate (OCA 11g) certification.
SEEK Learning will provide you with all the training you need to pass the OCA 11g exams (1Z0-047 or 1Z0-051 and 1Z0-052) and get certified.
Who is this course for?
- Database administrators (DBAs)
- Database analysts
- Database developers
- Technical consultants
View all Oracle courses
Quick Course Guide
- Qualification
- OCA 11g
- Student support
- 24x7 access to a comprehensive reference library
- Study time
- 7 weeks
- Pre-requisites
- None
- Enrolment dates
- Enrol anytime - start now!
- Assessment
- OCA 11g exams 1Z0-047 or 1Z0-051 and 1Z0-052 (by external provider)
- Delivered by
- SkillSoft
- Resources required
- Internet, email
Build a Strong Foundation in Database Administration
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.
Back to top
Skills You'll Gain
Among other things, you'll learn how to:
- 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
OCA 11g Course Details
Course Outline
1Z0-047
- 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
- Oracle Database 11g: Controlling User Access and Managing Schema Objects
- Oracle Database 11g: Data Dictionary Views and Large Data Sets
- Oracle Database 11g: Managing Data in Different Time Zones
- Oracle Database 11g: Using Subqueries and Regular Expressions
Or
1Z0-051
- 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
And
1Z0-052
- Oracle Database 11g: Database Architecture and Installation
- Oracle Database 11g: Database Creation, Instance Management and Connectivity
- Oracle Database 11g: Storage Structures and User Security
- Oracle Database 11g: Managing the Schema, Data and Concurrency
- Oracle Database 11g: Managing Undo Data, Database Security and Maintenance
- Oracle Database 11g: Performance Monitoring, Recovery Concepts and Backup
- Oracle Database 11g: Recovering, Moving, and Enhancing the Oracle Database
- 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
SEEK Learning's Oracle certification training will fully prepare you for the OCA 11g exams.
Please note that the OCA 11g exams are held by an external provider. For your convenience, SEEK Learning will help you find your nearest exam centre. Contact a SEEK Learning consultant for further information or assistance.
Back to top
Training Exclusively Through SEEK Learning
SEEK Learning provides training from SkillSoft, the premier global provider of IT e-learning courseware.
SkillSoft does not generally offer courses directly to individuals, but our partnership enables us to exclusively offer Oracle training directly to you.
SkillSoft courses are developed according to the certification specifications of leading vendors.
Why Get Certified?
Certifications show potential employers that you're serious about building skills and staying up-to-date in your chosen field of expertise.