Oracle Database Administration Course

Course Description

This Oracle Database Administration course explores the fundamentals of basic database administration. The course can be tailored for all versions of Oracle database. The course is based around using the command line, but can provide Enterprise Manager Express to complement and enhance the learning experience, if relevant.
5 days
Contact us for pricing
 

On the course you will

Install and create an Oracle Database
Discover the Oracle database architecture
Create and manage users
Create and manage storage structures
Administer the Oracle Database
Understand backup and recovery
Understand Oracle Flashback technology
Manage space requirements
Monitor and manage performance
Understand the Oracle Scheduler

Oracle Concepts Overview

Oracle Components
The Oracle Instance
The Oracle Database
Oracle Processes
The Listener
Grid Infrastructure Overview
Oracle Restart
Automatic Storage Management

Oracle Database Software Installation

Pre-installation Tasks
Installation Process

Oracle Database Creation

Using the Database Configuration Assistant

Managing an Oracle Database Instance

Connecting as a privileged user
Startup and Shutdown
Initialisation Parameters
Understanding Oracle Processes
Understanding System Global Area Components
Managing the System Global Area size
Understanding Program Global Area Components
Managing the Program Global Area size
The Automatic Diagnostic Repository
The Data Dictionary

Control Files and Tablespaces

Understanding the role of Control Files
Understanding Tablespaces
Understanding Data Files
Oracle Managed Files

Redo Logging

Understanding the role of Redo Logging
Redo Log Groups
Redo Log File Multiplexing

Undo Management

Understanding the role of Undo
Managing the Undo Tablespace

Networking

The role of the Listener
Managing the Listener
Network Configuration Files
Contrasting Dedicated and Shared Server configurations

Security

User Management
Database Privileges
Database Roles
Auditing Methods
Oracle Data Redaction

The Oracle Scheduler

Automating Tasks using:
Jobs
Programs
Schedules
Windows
Chains

Moving Data

Using SQL*Loader
Using External Tables
Using Datapump
Using Datapump Legacy Mode

Performance Management

Understanding Performance components:
The Optimiser
Statisitics Management
Wait Events
Memory Advisors
The Automatic Workload Repository
Performance Advisors

Database Resource Management

Managing Database Resources with:
Consumer Groups
Resource Plans
Directives

Managing Space

Understanding Segments, Extents and Oracle Blocks
Describing Database Objects, such as:
Tables
Indices
Partitioning
Clusters
Using Automatic Segment Space Management
Using Compression
Shrinking Segments
Resumable Space Management
Information Lifecycle Management
In Database Archiving
Temporal

Backup Management

Understanding ARCHIVELOG Mode
Understanding Recovery Manager (RMAN)
Persistent Configuration Parameters
Performing Backups

Performing Recovery

Recovering from the loss of Control Files
Recovering from the loss of Redo Log Files
Recovering from the loss of Data Files

Performing Flashback

Understanding Flashback requirements
Understanding Flashback options
Oracle DatabaseOracle Database 19cDBADatabase AdministrationOracle Database AdministrationOracle DBAOracle 21cOracle