Oracle
Database 12c

Certification Exam Prep

 

About the Program

With over 305,000 top companies using Oracle Database technology for their critical business functions, systems, and processes, well-trained, highly skilled Oracle Database professionals are truly in high demand. And because the release of Oracle Database 12c re-engineers Oracle Database for Cloud computing, a practice many corporations are turning to for the storing, managing, and processing of their data, becoming Oracle Database 12c certified will definitely set you apart from your non-certified peers.

Oracle Database Certification holders not only gain the competitive advantage of having an in-demand world renowned certification under their belts, but they can also reap other financial and career benefits.

Certifications

This program prepares the student to take the following certification exams:

  • 1Z0-071 Oracle Database 12c R2: SQL Fundamentals

  • 1Z0-062 Oracle Database 12c: Installation and Administration

  • 1Z0-063 Oracle Database 12c: Advanced Administration

  • 1Z0-064 Oracle Database 12c: Performance Management and Tuning

  • 1Z0-068 Oracle Database 12c: RAC and Grid Infrastructure Administration

The certification exams are not a requirement for graduation. Vendor certifications are at the student’s expense. Vouchers may be available depending on the student’s funding and financial aid.

This program is self-paced. Self-paced programs create a unique learning experience that allows students to learn independently and at a pace that best suits them.

Includes e-books, mentoring, virtual practice lab for 1Z0-071 and 1Z0-062, and test review questions.

Prerequisites: HS diploma/GED, basic computer skills and familiarity with the internet

Students will have full access to the program for one year.

To learn more about ETI’s tuition and financial aid options, click here.

Tuition and Program Options

Oracle Database 12c – Administrator Certified Associate

Tuition: $1,007

Duration: 32 hours + 28 Hours of Virtual Practice Lab

Units:

  • 1Z0-071 Oracle Database 12c: SQL Fundamentals

  • 1Z0-062 Oracle Database 12c: Installation and Administration

Oracle Database 12c – Administrator Certified Professional

Tuition: $1,502

Duration: 45 hours + 28 Hours of Virtual Practice Lab for 1Z0-071 and 1Z0-062

Units:

  • 1Z0-071 Oracle Database 12c: SQL Fundamentals

  • 1Z0-062 Oracle Database 12c: Installation and Administration

  • 1Z0-063 Oracle Database 12c: Advanced Administration

Oracle Database 12c - Oracle Certified Expert

Tuition: $2,487

Duration: 66 hours + 28 Hours of Virtual Practice Lab for 1Z0-071 and 1Z0-062

Units:

  • 1Z0-071 Oracle Database 12c R2: SQL Fundamentals

  • 1Z0-062 Oracle Database 12c: Installation and Administration

  • 1Z0-063 Oracle Database 12c: Advanced Administration

  • 1Z0-064 Oracle Database 12c: Performance Management and Tuning

  • 1Z0-068 Oracle Database 12c: RAC and Grid Infrastructure Administration

Course Outline

Oracle Database 12c: Administrator Certified Professional

1Z0-071 Oracle Database 12c R2: SQL Fundamentals

  • Using Structured Query Language (SQL)

  • Data Manipulation Language and Transaction Control Language

  • Using Basic SELECT Statements

  • Conversion Functions and Conditional Expressions

  • Displaying Data from Multiple Tables

  • Using the Set Operators

  • Managing Objects with Data Dictionary Views

  • Managing Schema Objects

  • Data Definition Language (DDL)

  • SQL *Plus

  • Restricting and Sorting Data

  • Using Single-Row Functions to Customize Output

  • Reporting Aggregated Data Using the Group Functions

  • Using Subqueries to Solve Queries

  • Creating Other Schema Objects

  • Controlling User Access

  • Manipulating Data Using Advanced Queries

  • TestPrep 1Z0-071 Oracle Database SQL: used to test your knowledge on the skills and competencies being measured by the vendor certification exam. TestPrep can be taken in either Study or Certification mode.

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

  • Managing an Oracle Database 12c Instance

  • Connectivity and Space Management

  • User Security and Auditing

  • Backing Up, Recovering, Importing, and Exporting Data

  • Database Maintenance and Performance Tuning

  • SQL Tuning, Resource Management, and Job Scheduling

1Z0-063 Oracle Database 12c: Advanced Administration

  • Configuring for recoverability

  • Performing & Managing Backups

  • Failure & Recovery Concepts

  • Perform Recovery & Secure Backup

  • Using Flashback Technologies

  • Transporting Data & Performing PITR

  • Duplicating Databases & Tuning RMAN

Oracle database 12c: Oracle Certified Expert

1Z0-064 Oracle Database 12c: Performance Management and Tuning

  • Introduction

  • Automatic Workload Repository

  • Metrics and Monitoring

  • Application Monitoring and SQL Diagnostics

  • Tuning Problem SQL Statements

1Z0-068 Oracle Database 12c: RAC and Grid Infrastructure Administration

  • Introduction to Oracle RAC

  • Installing, Configuring, and Patching

  • Day-to-Day Administration

  • Backup and Recovery

  • Global Resource Management

  • Monitoring and Tuning

  • Client Connections and QoS

  • Services and Multitenant Architecture