Oracle DB Professional
Certification Prep
This product prepares the learner for the following certification(s):
Certification: Oracle Database 12c Administrator Certified Associate
Certification: Oracle Database 12c Administrator Certified Professional
Certification: Oracle Database 12c Administrator Certified Professional Upgrade Path
Certification: Oracle Database 12c: Oracle Certified Expert
Course Pathways
This product is comprised of the following course pathways:
1Z0-061 Oracle Database 12c: SQL Fundamentals (Duration: 14.7 hrs.)
Pathway Includes the following courses:
- Oracle Database 12c - Introduction to SQL: Relational Database and SQL Developer
- TestPrep 1Z0-061 Oracle Database 12c: SQL Fundamentals
- Oracle Database 12c - Introduction to SQL: SQL*Plus and SELECT Statement
- Oracle Database 12c - Introduction to SQL: Restrict, Sort, and Customize Output
- Oracle Database 12c - Introduction to SQL: Data Conversion and Aggregating Data
- Oracle Database 12c - Introduction to SQL: Working with Joins and Subqueries
- Oracle Database 12c - Introduction to SQL: Data Manipulation Language
- Oracle Database 12c - Introduction to SQL: Working with SET Operators and DDL
1Z0-071 Oracle Database 12c R2: SQL Fundamentals (Duration: 18.3 hrs.)
Pathway Includes the following courses:
- Oracle Database 12c R2 SQL: Using Structured Query Language (SQL)
- Oracle Database 12c R2 SQL: Data Manipulation Language and Transaction Control Language
- Oracle Database 12c R2 SQL: Using Basic SELECT statements
- Oracle Database 12c R2 SQL: Conversion Functions and Conditional Expressions
- Oracle Database 12c R2 SQL: Displaying Data from Multiple Tables
- Oracle Database 12c R2 SQL: Using the Set Operators
- Oracle Database 12c R2 SQL: Managing Objects with Data Dictionary Views
- Oracle Database 12c R2 SQL: Managing Schema Objects
- Oracle Database 12c R2 SQL: Data Definition Language (DDL)
- Oracle Database 12c R2 SQL: SQL*Plus
- Oracle Database 12c R2 SQL: Restricting and Sorting Data
- Oracle Database 12c R2 SQL: Using Single-Row Functions to Customize Output
- Oracle Database 12c R2 SQL: Reporting Aggregated Data Using the Group Functions
- Oracle Database 12c R2 SQL: Using Subqueries to Solve Queries
- Oracle Database 12c R2 SQL: Creating Other Schema Objects
- Oracle Database 12c R2 SQL: Controlling User Access
- Oracle Database 12c R2 SQL: Manipulating Data Using Advanced Queries
- TestPrep 1Z0-071 Oracle Database SQL
1Z0-062 - Oracle Database 12c: Installation and Administration (Duration: 19.3 hrs.)
Pathway Includes the following courses:
- Managing an Oracle Database 12c Instance
- Connectivity and Space Management in Oracle Database 12c
- User Security and Auditing in Oracle Database 12c
- Backing Up, Recovering, Importing, and Exporting Data in Oracle Database 12c
- Database Maintenance and Performance Tuning in Oracle Database 12c
- SQL Tuning, Resource Management, and Job Scheduling in Oracle Database 12c
- Oracle Database 12c – Install and Upgrade: Database Architecture (Update Avail.)
- Oracle Database 12c – Install and Upgrade: Installation (Update Avail.)
- Oracle Database 12c – Install and Upgrade: Upgrading (Update Avail.)
1Z0-060 - Upgrade to Oracle Database 12c (Duration: 15.4 hrs.)
Pathway Includes the following courses:
- Oracle Database 12c: Enterprise Manager Cloud Control (Update Avail.)
- TestPrep 1Z0-060 Upgrade to Oracle Database 12c
- Oracle Database 12c: Managing CDB and PDB, and Data Optimization (Update Avail.)
- Oracle Database 12c: Using Automatic Data Optimization (Update Avail.)
- Oracle Database 12c: Managing Security (Update Avail.)
- Oracle Database 12c: High Availability and Database Management (Update Avail.)
- Oracle Database 12c: Tuning SQL and Using ADDM (Update Avail.)
- Oracle Database 12c: Resource Manager and ADR (Update Avail.)
- Oracle Database 12c: Transporting Databases and Managing Data (Update Avail.)
1Z0-063 Oracle Database 12c: Advanced Administration (Duration: 12.9 hrs.)
Pathway Includes the following courses:
- Oracle Database 12c - Backup and Recovery: Configuring for Recoverability
- Oracle Database 12c - Backup and Recovery: Performing and Managing Backups
- Oracle Database 12c - Backup and Recovery: Failure and Recovery Concepts
- Oracle Database 12c - Backup and Recovery: Perform Recovery and Secure Backup
- Oracle Database 12c - Backup and Recovery: Using Flashback Technologies
- Oracle Database 12c - Backup and Recovery: Transporting Data and Performing PITR
- Oracle Database 12c - Backup and Recovery: Duplicating Databases and Tuning RMAN
1Z0-064 Oracle Database 12c: Performance Management and Tuning (Duration: 6.4 hrs.)
Pathway Includes the following courses:
- Oracle 12c Performance Tuning: Introduction
- Oracle 12c Performance Tuning: Automatic Workload Repository
- Oracle 12c Performance Tuning: Metrics and Monitoring
- Oracle 12c Performance Tuning: Application Monitoring and SQL Diagnostics
- Oracle 12c Performance Tuning: Tuning Problem SQL Statements
1Z0-068 Oracle Database 12c: RAC and Grid Infrastructure Administration (Duration: 13.5 hrs.)
Pathway Includes the following courses:
- Oracle Database 12c RAC Administration: Introduction to Oracle RAC
- Oracle Database 12c RAC Administration: Installing, Configuring, and Patching
- Oracle Database 12c RAC Administration: Day-to-Day Administration
- Oracle Database 12c RAC Administration: Backup and Recovery
- Oracle Database 12c RAC Administration: Global Resource Management
- Oracle Database 12c RAC Administration: Monitoring and Tuning
- Oracle Database 12c RAC Administration: Client Connections and QoS
- Oracle Database 12c RAC Administration: Services and Multitenant Architecture