Сhat now
Training Center MUKКурсыOracleDatabaseOracle Database 18c: Administration Workshop

Oracle Database 18c: Administration Workshop

Course code
Orcl_Db18
Duration
5 Days, 40 Acad. Hours
Course Overview
Objectives
Prerequisites
Course Outline
Course Overview

Course overview

This course provides detailed information on the architecture of an Oracle Database instance and database, enabling you to manage your database resources effectively.

Objectives

Course objectives

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

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 Outline

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)
Request the training
Oracle Database 18c: Administration Workshop
Course code:
Orcl_Db18
Duration:
5 Days, 40 Acad. Hours
Apply
Сhat now
Свяжитесь со мной
Сhat now
Отправить заявку
Registration for the webinar
Отправить заявку
Your application has been received! We will contact you soon.