Oracle DB Professional

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