Oracle Database 12c : Administration Workshop

QUESTIONS ?

Oracle Database 12c R2: Administration Workshop

Prix: 3 385 €Durée: 5 JoursCode de Réference: D78846 Catalogue ,
The Oracle Database 12c R2: Administration Workshop Ed 3 course is designed to provide you with a firm foundation in administration of an Oracle Database. In this course you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle Database in an effective and efficient manner. This course covers both Database as a Cloud Service and the on-premises Oracle Database.
  • Learn To:
    • Manage an Oracle Database instance.
    • Configure the Oracle Network environment.
    • Create and manage storage structures.
    • Manage and move data.
    • Create and manage users.
    • Monitor the database and manage performance.
    • Create and manage Database as a Cloud Service database deployments.

     

  • Benefits To You

    You will benefit from this course as you learn detailed information on the architecture of an Oracle Database instance and database, enabling you to effectively manage your database resources. You learn how to create database storage structures appropriate for the business applications supported by your database. In addition you learn how to create users and administer database security to meet your business requirements. Basic information on backup and recovery techniques is presented in this course.

    To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.

  • Audience

Administrateurs de base de données

Administrateurs de data warehouse

Ingénieurs support

Concepteurs de base de données

 

  • Thèmes abordés

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

 

  • Objectifs:

 

    • Describe the DBaaS and on-premises Oracle Database architectures
    • Back up, restore, and patch DBCS database deployments
    • Manage database instances
    • Manage UNDO data
    • Move data between databases
    • Implement basic backup and recovery procedures
    • Monitor and tune database performance
    • Tune SQL to improve performance
    • Manage resources with Oracle Database Resource Manager
    • Create pluggable databases (PDBs)
    • Configure the Oracle network environment
    • Administer user security and implement auditing
    • Create and manage tablespaces
    • Manage storage space
    • Register databases and manage performance with Enterprise Manager Cloud Control
    • Create and manage Database as a Cloud Service (DBCS) database deployments

 

  • Cours Pré-requis

 

 

Le cours "Oracle Database 12c: Install and Upgrade Workshop" fournit les informations essentielles concernant l'installation d'Oracle Database 12c. Il explique comment créer une base de données Conteneur et comment provisionner des bases pluggables.

 

 

This Oracle Database 12c: Install and Upgrade Workshop will provide you with key information to install Oracle Database 12c software. You’ll also learn how to create a container database and provision pluggable databases. In this course, you will be introduced to Oracle Database Cloud Service.

 

 

This Oracle Database 12c: Managing Multitenant Architecture training will help you understand the multitenant architecture. Learn how to manage an Oracle multitenant container database and any associated pluggable databases in an effective and efficient manner.In this course, you will be introduced to Oracle Database Cloud Service.

 

 

Le cours "Oracle Database 12c: Managing Multitenant Architecture" permet de comprendre l'architecture colocative. Il explique comment gérer efficacement une base de données Conteneur colocative et les bases pluggables associées.

 

 

In this Oracle Database 12c R2: Backup and Recovery Workshop, students learn how to perform backup and recovery based on the related Oracle Database architecture components. Various backup, failure, restore, and recovery scenarios are provided so that students learn to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures.

 

 

This Oracle Database 12c: Backup and Recovery Workshop teaches you about backup, restore and recovery scenarios. This course will help you evaluate your own recovery requirements and develop appropriate strategies for these procedures. In this course, you will be introduced to Oracle Database Cloud Service.

 

 

Le cours "Oracle Database 12c: Backup and Recovery Workshop" présente différents scénarios de sauvegarde, de restauration et de récupération. Il vous apprend à évaluer les besoins de votre organisation en matière de récupération et à développer les stratégies appropriées pour y répondre.

 

Print Friendly, PDF & Email
retour vers le catalogue des formations