New Oracle Database_12C Administrator

CLS Learning Solutions

  • Ratings
  • 4.0
  •  Last updated 12 months ago
  •  ENGLISH

AED 5,800

Duration: 136 Hours
Location: Egypt
Delivery: Onsite course

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 Recoverability
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

 

The course content will be available shortly

Write your own review

COURSE DOCUMENT

Videos Gallery

No video available for this course

RELATED COURSE

Choose from 5000+ available courses with new additions published every month

View All