database_development_courses

Oracle Database: 12c Administrator Certified Associate

  • Validate your expertise as a Database Administrator with this Oracle Database 12c Administrator Certified Associate training
  • Access weekday email support from expert mentors
  • Prepare for certification with practice exam questions

This Skillsoft course will train you in everything you need to know to pass the exams for the Oracle Database 12c Administrator Certified Associate certification. You'll need to sit these exams separately.


Ready to start?

Price: $1,495 AUD

At a glance

Study mode

laptop
Online

Provider

Skillsoft
Career Opportunities
  • Cloud Administrator
  • Database Administrator
  • System Administrator
Recognition

Globally recognised

Prerequisites

None

Location

Online

Course length
13 weeks
Study mode

Online


Online

Study from anywhere, when it suits you best and graduate with the identical qualification as an on-campus student.

Blended

Study part of the course online. Combine your online learning with classes or practical sessions on-campus at a college or university.

In-class

Attend classes on-campus at a university, TAFE or college and interact face-to-face with teachers and fellow students.

Assessment
OCA 12c exams 1Z0-060, 1Z0-061 and 1Z0-062 (by external provider)
Start date

Enrol anytime.

Provider
Skillsoft

Skillsoft is the premier global provider of online IT and project management certification training courses.

If you want to be an expert of a particular software package or project management practice, a Skillsoft course will prepare you completely for the certification exam.

The certifications include Microsoft, Cisco, Oracle, Six Sigma, PRINCE2 and more.

Skillsoft's award-winning training method combines affordable computer-based training with the personal attention of instructor-led training.

Read more about
Skillsoft

What you'll learn

You'll learn how to:

  • Identify the different type of tools Oracle provides for database management
  • Use the new Oracle Database 12c security features
  • Describe the features of Oracle Database 12c
  • Recognise Oracle Database 12c Architecture structures
  • Manage threshold levels on a database tablespace

Course structure

26 units

1Z0-060: Upgrade to Oracle Database 12c

  • Enterprise manager cloud control & creating CDB & PDB
  • Managing CDB & PDB, and data optimization
  • Using automatic data optimization, storage & archiving
  • Managing security
  • High availability & database management
  • Tuning SQL & using ADDM
  • Resource manager, online operations & ADR
  • Transporting databases & managing data

1Z0-061: Oracle Database 12c: SQL Fundamentals

  • Relational database & SQL developer
  • SQL*Plus & SELECT statement
  • Restrict, sort & customize output
  • Data conversion & aggregating data
  • Working with joins & subqueries
  • Data manipulation language
  • Working with SET operators & DDL

1Z0-062: Oracle Database 12c: Installation & Administration

  • Database architecture
  • Installation
  • Upgrading
  • Database architecture & management tools
  • Manage the database instance
  • The network environment & user security
  • Storage structures & undo data
  • Data concurrency & auditing
  • Backup, recover & move data
  • Maintenance & performance tuning
  • Resource manager, scheduler & support

Skillsoft's Oracle certification training will fully prepare you for the OCA 12c exams.

Please note that the OCA 12c exams are held by an external provider.

Recognition

Certification is awarded by Oracle and is globally recognised. 

Ready to start?

  • Enrol in a few steps
  • Receive access to the course by email
  • Support is available as you study

Price: $1,495 AUD