Oracle Database 18c: Administration Workshop

Suggested Prerequisite

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

Audience

• Data Warehouse Administrator
• Support Engineer
• Database Administrators
• Database Designers
• Technical Administrator

Course Topics

1. Introduction

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

2. Managing DBCS Database Deployments

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

3. Creating PDBs

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

4. Managing Storage Space

• 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

5. Backup and Recovery Configuration

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

6. Monitoring and Tuning Database Performance

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

7. Oracle Database Architecture

• 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

8. Managing Database Instances

• 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

9. Creating Master Encryption Keys for 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

10. Managing Undo Data

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

11. Creating Database Backups

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

12. SQL Tuning

• Oracle Optimizer
• SQL Tuning Advisor
• SQL Performance Analyzer
• Optimizer Statistics
• SQL Access Advisor
• SQL Tuning Process

13. Introdction to Oracle Database Cloud

• Automated Database Provisioning
• Oracle Database Cloud Service Architecture
• Features and Tooling

14. Accessing an Oracle Database

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

15. Oracle Net Services

• 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

16. Administering User Security

• 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

17. Creating and Managing Tablespaces

• 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

18. Moving Data

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

19. Backup and Recovery Concepts

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

20. Performing Database Recovery

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