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