Oracle Database : Administration Workshop Course Overview

The Oracle Database 18c: Administration Workshop training course will give you a detailed overview of the architecture of an Oracle Database instance and database which will help you in the effective management of the database resources. During the training you will cover in details the topics like database storage structures, create users and administer database security, basic information on backup and recovery techniques, monitor database and manage performance etc.

Who should do Oracle Database 18c: Administration Workshop training?

  • Data Warehouse Administrator
  • Database Administrators
  • Database Designers
  • Support Engineer
  • Technical Administrator
  • 1. Do you have limited Window for training?
  • 2. Can you only spend 4-hours per day?
  • 3. Do you want to start training immediately?
  • If your answer is yes to any one of the above, you need 1-on-1- Training
The 1-on-1 Advantage
Methodology
Flexible Dates
4-Hour Sessions
  • View video
  • The course will be free if we are not able to start within 7 days of booking.
  • Only applicable for courses on which this logo appears.

Your will learn:

Module 1: Introduction
  • Oracle Database Editions, Options, and Management Packs
  • Oracle Cloud Overview
  • Sample HR Schema
  • 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
  • Oracle Database Cloud Service Architecture
  • Features and Tooling
  • Automated Database Provisioning
  • Input to the Creation Wizard
  • SSH Key Pairs
  • Database File Storage
  • SQL*Plus
  • SQL Developer
  • Database Configuration Assistant (DBCA)
  • Oracle enterprise Manager Database Express
  • Oracle Enterprise Manager Cloud Control
  • Oracle Database Cloud Service Tools
  • Managing the Compute Node
  • Managing Network Access to DBCS
  • Scaling a Database Deployment
  • Patching a Database Deployment
  • 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 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
  • 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
  • Methods and Tools to Create PDBs
  • Creating PDBs from Seed
  • Cloning PDBs
  • Unplugging and Plugging in PDBs
  • Dropping 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
  • 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
  • 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
  • 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
  • Oracle Data Pump
  • SQL*Loader
  • External Tables
  • Migrating to Oracle Database Cloud Service
  • Categories of Failure
  • Instance Recovery
  • Complete Recovery
  • Point-in-time Recovery
  • Flashback Technology
  • Configuring and Monitoring the Fast Recovery Area
  • Multiplexing Control Files
  • Multiplexing Redo Log Files
  • Archive Redo Log Files
  • Configuring ARCHIVELOG Mode
  • Backup Terminology
  • Using Recovery Manager (RMAN)
  • RMAN Backup Types
  • Automatic Backups on Database Cloud Service (DBCS)
  • On-Demand Backups on DBCS
  • Database Recovery Advisor
  • Recovering Data Files in NOARCHELOG Mode
  • Recovering Data Files in ARCHIVELOG Mode
  • Recovery Options in Database Cloud Service (DBCS)
  • 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 Process
  • Oracle Optimizer
  • Optimizer Statistics
  • SQL Tuning Advisor
  • SQL Access Advisor
  • SQL Performance Analyzer
Live Online Training (Duration : 40 Hours)
Group Training 3100 Per Participant Incl. Official Courseware
30 May - 03 Jun 09:00 AM - 05:00 PM CST
(8 Hours/Day)
06 - 10 Jun 09:00 AM - 05:00 PM CST
(8 Hours/Day)
04 - 08 Jul 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training 6200 3600 + If you accept merging of other students. Incl. Official Courseware
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Classroom Training is available. Enquire for the fee Click
Ultra-Fast Track

If you can't spare 40 hours. We can offer you an Ultra-Fast Track for 20 hours for only USD 2,880

Course Prerequisites
  • Practical knowledge of SQL & PL/SQL packages
  • Fundamental understanding of Linux OS will be helpful though not mandatory

On completion of this training, you will know:

  • Understand Oracle Database architecture
  • Understand and know Oracle Database Cloud Service (DBCS) architecture and features
  • Creating & managing DBCS database deployments
  • Configuring the database to support the applications
  • Managing database security & implement auditing
  • Implementing basic backup and recovery procedures
  • Moving data between databases and files
  • Employing basic monitoring procedures and managing performance

Request More Information

Add Name and Email Address of participant (If different from you)