New Oracle Database 12C Administrator Diploma

CLS Learn

Price: AED 1,333

Locations: Dokki Nasr City - Cairo
Duration: 136 Hours
Call: +971 4 5490356

Course details

With the 12c release, Oracle Database is re-engineered for Cloud computing. Multitenant architecture brings enterprises unprecedented hardware and software efficiencies, performance and manageability benefits, and fast and efficient Cloud provisioning.

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

Diploma New Courses:

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)

Oracle 12c Introduction to SQL:

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

Oracle 12c Administration:

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

Oracle Database 12c Managing Multitenant Architecture:

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

Oracle Database 12c Advanced Administration Backup and Recovery Workshop:

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

Updated on 09 August, 2020

Eligibility / Requirements

Administrator
Analyst
Developer
Systems Administrator

Job roles this course is suitable for:

Database Administrator , Oracle Database Administrator , Oracle Database Admin

Course Location

Show map Locations Dokki Nasr City - Cairo

About CLS Learn

Since 1995, CLS Learning solutions is leading the technology learning market in Egypt, the Middle East, and Africa. With our wide network of international partners, trainers, instructors, and technology leaders; we are able to deliver top notch training programs to our students and technology professionals.

25 Years in the market.

We delivered over 4,200 courses to 63,500 professionals in our centers.

We delivered 1,200 courses to 18,240 corporate employees on Site.

See all CLS Learn courses

View more Virtual classroom training for Oracle online courses See all Oracle Courses

See all current Oracle jobs in UAE