Formation Oracle Database 19c Administration

Module 1: Introduction to Oracle Database

Exploring Oracle Database Fundamentals

Understanding Oracle Cloud Integration

Core Concepts of Relational Databases

Essential Database Administration Responsibilities

Module 2: Oracle Database Architecture

Delving into Oracle Database Structure

Differentiating Database from Instance

Insight into Memory Structures

Understanding Process Architecture

Managing Server and Client Processes

Navigating Oracle Database Storage Architecture

Establishing Connections to Database Instances

Module 3: Database Instance Administration

Leveraging Administrative Tools

Management via SQL*Plus

Using SQL Developer for Administration

Introduction to Enterprise Manager Framework

Accessing Enterprise Manager Database Express

Overview of Enterprise Manager Cloud Control

Understanding Initialization Parameter Files

Module 4: Oracle Network Environment Configuration

Configuring Oracle Network Settings

Oracle Net Listener Setup

Exploring Oracle Net Naming Methods

Network Configuration Tools

Client Connectivity Management

Viewing Listener Configuration

Starting and Stopping the Listener

Testing Connectivity with TNSPING

Configuring Net Services with Enterprise Manager

Module 5: Storage Structures

Understanding Data Storage

Overview of Database Blocks

Exploring Tablespaces and Data Files

Viewing Storage Structure with Enterprise Manager

Tablespace and Datafile Management

Managing Temporary Tablespaces

Oracle Managed Files (OMF) Implementation

Module 6: User Management

Introduction to Database Administration Accounts

Managing User Accounts

Password Management

User Monitoring

Terminating User Sessions

Creating Schema-Only Accounts

Module 7: Privilege Management

Database Access Control Overview

Oracle Supplied Roles

System and Object Privileges

Granting and Revoking Privileges

Managing User Roles

Module 8: Database Auditing

Overview of Database Security

Introduction to Database Auditing

Standard and Unified Audit Trails

Configuring Auditing

Setting Audit Options

Module 9: Data Concurrency and Locking

Understanding Data Concurrency

Levels of Locking

Lock Acquisition Methods

Detecting and Resolving Lock Conflicts

Module 10: Undo Management

Overview of Undo Data

Monitoring and Administering Undo

Configuring Undo Retention

Utilizing Flashback Query

Undo Space Management

Undo Advisor Usage

Module 11: Backup and Recovery Configuration

Oracle Backup Solutions Overview

Backup and Recovery Fundamentals

Understanding Flashback Technology

Instance Recovery

Database Recoverability Configuration

Module 12: Proactive Database Maintenance

Database Maintenance Overview

Performance Monitoring

Automatic Workload Repository

Performance Advisors

Notification Rule Setup

Module 13: Performance Management

Performance Monitoring and Planning

Instance Tuning Techniques

Memory Management

Performance Tuning Methodologies

Module 14: SQL Tuning

SQL Optimization Techniques

Oracle Optimizer Functionality

Adaptive Execution Plans

SQL Advisors

Automatic Tuning Recommendations

Module 15: Data Movement

Data Transfer Techniques

Introduction to Data Pump and SQL Loader

Exporting and Importing Data

Managing External Tables

Module 16: Resource Management with Resource Manager

Database Resource Manager Overview

Resource Management Configuration

Resource Plan Creation and Allocation

Module 17: Task Automation with Scheduler

Scheduler Introduction

Job Creation and Management

Time-Based and Event-Based Scheduling

Module 18: Space Management

Space Management Overview

Block and Segment Management

Row Chaining and Migration

Module 19: Oracle Support

Enterprise Manager Support Workbench

Oracle Support Interaction

Patch and Update Management