D78846 | Oracle Database 12c: R2 Administration Workshop Ed 3 | Training Course | Oracle. Skip to main Content

Oracle Database 12c: R2 Administration Workshop Ed 3

  • Course Code D78846
  • Duration 5 days

Course Delivery

Additional Payment Options

  • GTC 49 inc. VAT

    GTC, Global Knowledge Training Credit, please contact Global Knowledge for more details

Public Classroom Price

eur3.395,00

excl. VAT

Request Group Training Add to Cart

Course Delivery

This course is available in the following formats:

  • Public Classroom

    Traditional Classroom Learning

Request this course in a different delivery format.

Course Overview

Top

The Oracle Database 12c: Administration Workshop will teach you about the Oracle Database architecture. You will discover how to effectively manage an Oracle Database instance, configure the Oracle Network Environment and perform database maintenance. In this course, you will be introduced to Oracle Database Cloud Service.

Benefits to You

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

Participate in Hands-On Practices and Demonstrations

Expert instruction and hands-on demonstrations will provide you with real world experience. By engaging in hands-on exercises to reinforce your learning, you'll develop in demand skills to effectively manage an Oracle Database.

 

Course Schedule

Top

Target Audience

Top
  • Technical Administrator
  • Database Designers
  • Data Warehouse Administrator
  • Database Administrators

 

Course Objectives

Top
  • Configure Oracle Net Services
  • Configure your Database For Backup and Recovery Operations
  • Describe Oracle Database Architecture
  • Manage the Oracle Database Instance
  • Manage Oracle Database Storage structures
  • Create and Administer User Accounts
  • Monitor the Database
  • Manage Database Performance
  • Implement Database Auditing
  • Configure the Database Instance Such That Resources Are Appropriately Allocated Among Sessions and Tasks
  • Gain an understanding of the Oracle Database Cloud Service
  • Schedule Jobs to Run Inside or Outside of the Database

 

Course Content

Top
  • 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

 

Course Prerequisites

Top

Working knowledge of SQL and use of PL/SQL packages

 

Cookie Control toggle icon