Oracle Database 18c: Administration Workshop | IT Training & Certification | Info Trek
Respect Your Dreams
Follow through on your goals with courses

Oracle Database 18c: Administration Workshop

  • On Demand Class Icon
    On Demand
    • HRDF SBL Claimable
    • Certificate of Attendance available
    • 90 days of access from date of activation
    Starting From
    RM 5025.00
    40 Hours
  • Private Class Icon
    Private Class
    • All of our private classes are customized to your organization's needs.

      Click on the button below to send us your details and you will be contacted shortly.
    0 Days

Course Details

Expand All
This course provides 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.

• Data Warehouse Administrator

• Support Engineer

• Database Administrators

• Database Designers

• Technical Administrator


Suggested Prerequisite

• A working knowledge of SQL and PL/SQL pack

• Basic knowledge of Linux operating system


This program will be conducted with interactive lectures, PowerPoint presentations, discussions and practical exercises

After completing this course, students will be able to:

• 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


Modules

Expand All

• Sample HR Schema

• Oracle Cloud Overview
• Oracle Database Editions, Options, and Management Packs

• Automatic Storage Management (ASM) Overview

• Oracle Database Instance Configurations

• Oracle Database Memory and Process Structures

• Connecting to the Database Instance

• Logical and Physical Database Structures

• Multitenant Architecture

• Oracle Database Server Architecture


• Automated Database Provisioning

• Oracle Database Cloud Service Architecture

• Features and Tooling

• Creating Oracle Database Cloud Service (DBCS) Deployments

• SSH Key Pairs

• Database File Storage

• Input to the Creation Wizard


• Oracle Database Cloud Service Tools

• Database Configuration Assistant (DBCA)

• Oracle Enterprise Manager Cloud Control

• Oracle enterprise Manager Database Express

• SQL Developer

• SQL*Plus


• Managing Network Access to DBCS

• Managing the Compute Node

• Scaling a Database Deployment

• Patching a Database Deployment


• Starting Up Oracle Database Instances

• Data Dictionary Views

• Shutting Down Oracle Database Instances

• Dynamic Performance Views

• Automatic Diagnostic Repository (ADR)

• Alert Log and Trace Files

• Initialization Parameter Files


• Oracle Net Services Administration Tools

• Configuring Communication Between Database Instances

• Oracle Net Listener Overview

• Connecting to an Oracle Database Instance

• Comparing Dedicated and Shared Server Configurations

• Naming Methods


• Assigning Quotas to Users

• Applying the Principal of Least Privilege

• Managing Oracle Cloud Users, Privileges, and Roles

• Creating and Assigning Profiles

• User Authentication

• Managing Oracle Database Users, Privileges, and Roles


• Dropping PDBs

• Cloning PDBs

• Methods and Tools to Create PDBs

• Creating PDBs from Seed

• Unplugging and Plugging in PDBs


• Overview of Transparent Data Encryption (TDE)

• Creating and Activating an Encryption Key

• CDB and PDB Master Encryption Keys

• Encryption in Oracle Database Cloud Service


• Viewing Tablespace Information

• Creating, Altering and Dropping Tablespaces

• Table Data Storage

• Tablespace Encryption by Default in DBCS

• Implementing Oracle Managed Files

• Moving and Renaming Online Data Files


• Resumable Space Allocation

• Shrinkable Segments

• Deferred Segment Creation

• Space-Saving Features

• Oracle Database Space Management Features

• Types of Segments

• Table and Row Compression

• Block Space Management


• Comparing Local Undo Mode and Shared Undo Mode

• Transactions and Undo Data

• Storing Undo Information

• Configuring Undo Retention

• Comparing Undo Data and Redo Data

• Temporary Undo


• External Tables

• Oracle Data Pump

• Migrating to Oracle Database Cloud Service

• SQL*Loader


• Point-in-time Recovery

• Complete Recovery

• Categories of Failure

• Flashback Technology

• Instance Recovery


• Configuring ARCHIVELOG Mode

• Configuring and Monitoring the Fast Recovery Area

• Multiplexing Control Files

• Multiplexing Redo Log Files

• Archive Redo Log Files


• RMAN Backup Types

• On-Demand Backups on DBCS

• Using Recovery Manager (RMAN)

• Backup Terminology

• Automatic Backups on Database Cloud Service (DBCS)


• Database Recovery Advisor

• Recovering Data Files in ARCHIVELOG Mode

• Recovering Data Files in NOARCHELOG Mode

• Recovery Options in Database Cloud Service (DBCS)


• Managing Memory Components

• Automatic Workload Repository (AWR)

• Advisory Framework

• Monitoring Wait Events, Sessions, and Services

• Managing Metric Thresholds and Alerts

• Performance Tuning Methodology

• Performance Planning Considerations

• Automatic Database Diagnostic Monitor (ADDM)


• Oracle Optimizer

• SQL Tuning Advisor

• SQL Performance Analyzer

• Optimizer Statistics

• SQL Access Advisor

• SQL Tuning Process


Trainers

See All
Reset

Reviews

0
based on 0 ratings reviews