New Oracle Database 12C Administrator Diploma CLS Learn
Price: EGP 5,800

    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

    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
    Courses you can instantly connect with... Do an online course on MySQL starting now. See all courses

    Is this the right course for you?

    Rate this page

    Didn't find what you were looking for ?

    or