New Oracle Database 12C Administrator Diploma

Course details

• Oracle Database 12c certifications emphasize the full set of skills that DBAs need in today's competitive marketplace.

• Oracle 12c Introduction to SQL (40 Hours)
• Oracle 12c Administration (40 Hours)
• Oracle Database 12c Managing Multitenant Architecture (16 Hours)
• Oracle Database 12c Advanced Administration Backup and Recovery Workshop (40 Hours)

• Introduction
• Retrieving Data using the SQL SELECT Statement
• Restricting and Sorting Data
• Using Single-Row Functions to Customize Output
• Using Conversion Functions and Conditional Expressions
• Reporting Aggregated Data Using the Group Functions
• Displaying Data from Multiple Tables Using Joins
• Using Subqueries to Solve Queries
• Using the SET Operators
• Managing Tables using DML statements
• Introduction to Data Definition Language
• Introduction to Data Dictionary Views
• Creating Sequences, Synonyms, Indexes
• Creating Views
• Managing Schema Objects
• Retrieving Data by Using Subqueries
• Manipulating Data by Using Subqueries
• Controlling User Access
• Manipulating Data
• Managing Data in Different Time Zones

• Getting Started
• Exploring Oracle Database Architecture
• Managing Database Instances
• Creating PDBs
• Configuring the Oracle Network Environment
• Administering User Security
• Creating and Managing Tablespaces
• Managing Storage Space
• Managing UNDO Data
• Moving Data
• Backup and Recovery Concepts
• Monitoring and Tuning Database Performance
• SQL Tuning
• Oracle Database Resource Manager
• Enterprise Manager Cloud Control
• Introduction to Oracle Database Cloud Service
• Creating DBCS Database Deployments
• Managing DBCS Database Deployments
• Backing Up and Restoring DBCS Database Deployments
• Patching DBCS Database Deployments
• Creating Master Encryption Keys for PDBs
• Tablespace Encryption by Default

• Introduction
• Container and Pluggable Database Architecture
• CDB and PDB Creation
• Managing a CDB and PDBs
• Managing Storage in a CDB and PDBs
• Managing Security in a CDB and PDBs
• Managing Availability
• Managing Performance
• Miscellaneous
• Oracle Database Cloud Service: Overview

• Introduction
• Getting Started
• Configuring for Recoverablility
• Using the RMAN Recovery Catalog
• Backup Strategies and Terminology
• Performing Backups
• Improving Your Backups
• Using RMAN-Encrypted Backups
• Diagnosing Database Failures
• Restore and Recovery Concepts
• Performing Recovery, Part 1
• Performing Recovery, Part 2
• RMAN and Oracle Secure Backup
• Performing Tape Backups and Restores
• Using Flashback Technologies
• Using Flashback Database
• Managing Backup Space or Transporting Data
• Duplicating a Database
• RMAN Performance and Tuning
• Backup and Recovery Workshop
• Oracle Database Cloud Service: Overview