Oracle Database 18c : Administration Workshop

QUESTIONS ?

Oracle Database 18c : Administration Workshop

Prix: 3 555 €Durée: 5 joursCode de Réference: D103126 Catalogue
Oracle Database 18c
Print Friendly, PDF & Email



Cette formation Oracle Database 18c fournit des informations détaillées sur l'architecture d'une instance et d'une base de données Oracle Database, ce qui vous permet de gérer efficacement les ressources de votre base de données. Vous apprendrez à créer des structures de stockage de base de données appropriées pour les applications métier prises en charge par votre base de données. En outre, vous apprendrez à créer des utilisateurs et à administrer la sécurité de la base de données pour répondre aux besoins de votre entreprise. Cette formation fournit des informations de base sur les techniques de sauvegarde et de récupération. Pour fournir un temps de réponse acceptable aux utilisateurs et gérer efficacement les ressources, vous apprendrez à surveiller votre base de données et à gérer les performances.

Objectifs de la formation :

  • Describe Oracle Database architecture
  • Explain Oracle Database Cloud Service (DBCS) architecture and features
  • Create and manage DBCS database deployments
  • Configure the database to support your applications
  • Manage database security and implement auditing
  • Implement basic backup and recovery procedures
  • Move data between databases and files
  • Employ basic monitoring procedures and manage performance

Public :

Cette formation Oracle Database 18c: Administration Workshop s’adresse aux administrateurs de base de données, administrateurs de data warehouse, ingénieurs support et concepteurs de base de données.

Pré-requis :

A working knowledge of SQL and PL/SQL packages is very helpful in the course. Basic knowledge of Linux operating system.

Programme de la formation :

Introduction

Oracle Database Editions, Options, and Management Packs Oracle Cloud Overview Sample HR Schema  

Oracle Database Architecture

Oracle Database Server Architecture Oracle Database Instance Configurations Connecting to the Database Instance Oracle Database Memory and Process Structures Logical and Physical Database Structures Multitenant Architecture Automatic Storage Management (ASM) Overview  

Introduction to Oracle Database Cloud

Oracle Database Cloud Service Architecture Features and Tooling Automated Database Provisioning  

Creating Oracle Database Cloud Service (DBCS) Deployments

Input to the Creation Wizard SSH Key Pairs Database File Storage  

Accessing an Oracle Database

SQL*Plus SQL Developer Database Configuration Assistant (DBCA) Oracle enterprise Manager Database Express Oracle Enterprise Manager Cloud Control Oracle Database Cloud Service Tools  

Managing DBCS Database Deployments

Managing the Compute Node Managing Network Access to DBCS Scaling a Database Deployment Patching a Database Deployment  

Managing Database Instances

Initialization Parameter Files Starting Up Oracle Database Instances Shutting Down Oracle Database Instances Automatic Diagnostic Repository (ADR) Alert Log and Trace Files Dynamic Performance Views Data Dictionary Views  

Oracle Net Services

Oracle Net Listener Overview Connecting to an Oracle Database Instance Naming Methods Oracle Net Services Administration Tools Configuring Communication Between Database Instances Comparing Dedicated and Shared Server Configurations  

Administering User Security

Managing Oracle Cloud Users, Privileges, and Roles Managing Oracle Database Users, Privileges, and Roles User Authentication Creating and Assigning Profiles Assigning Quotas to Users Applying the Principal of Least Privilege  

Creating PDBs

Methods and Tools to Create PDBs Creating PDBs from Seed Cloning PDBs Unplugging and Plugging in PDBs Dropping PDBs  

Creating Master Encryption Keys for PDBs

Encryption in Oracle Database Cloud Service Overview of Transparent Data Encryption (TDE) CDB and PDB Master Encryption Keys Creating and Activating an Encryption Key  

Creating and Managing Tablespaces

Table Data Storage Creating, Altering and Dropping Tablespaces Viewing Tablespace Information Implementing Oracle Managed Files Moving and Renaming Online Data Files Tablespace Encryption by Default in DBCS  

Managing Storage Space

Oracle Database Space Management Features Block Space Management Types of Segments Deferred Segment Creation Space-Saving Features Table and Row Compression Shrinkable Segments Resumable Space Allocation  

Managing Undo Data

Transactions and Undo Data Storing Undo Information Comparing Undo Data and Redo Data Comparing Local Undo Mode and Shared Undo Mode Configuring Undo Rentention Temporary Undo  

Moving Data

Oracle Data Pump SQL*Loader External Tables Migrating to Oracle Database Cloud Service  

Backup and Recovery Concepts

Categories of Failure Instance Recovery Complete Recovery Point-in-time Recovery Flashback Technology  

Backup and Recovery Configuration

Configuring and Monitoring the Fast Recovery Area Multiplexing Control Files Multiplexing Redo Log Files Archive Redo Log Files Configuring ARCHIVELOG Mode  

Creating Database Backups

Backup Terminology Using Recovery Manager (RMAN) RMAN Backup Types Automatic Backups on Database Cloud Service (DBCS) On-Demand Backups on DBCS  

Performing Database Recovery

Database Recovery Advisor Recovering Data Files in NOARCHELOG Mode Recovering Data Files in ARCHIVELOG Mode Recovery Options in Database Cloud Service (DBCS)  

Monitoring and Tuning Database Performance

Performance Planning Considerations Automatic Workload Repository (AWR) Automatic Database Diagnostic Monitor (ADDM) Advisory Framework Managing Metric Thresholds and Alerts Monitoring Wait Events, Sessions, and Services Performance Tuning Methodology Managing Memory Components  

SQL Tuning

SQL Tuning Process Oracle Optimizer Optimizer Statistics SQL Tuning Advisor SQL Access Advisor SQL Performance Analyze  

Les plus de cette formation :

You will benefit from this course as you learn detailed information on the architecture of an Oracle Database instance and database, enabling you to manage your database resources effectively. 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. This course provides basic information on backup and recovery techniques. To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.
Print Friendly, PDF & Email
retour vers le catalogue des formations