Audience
This course is well suited to database administrators, system administrators and support staff.
This course is suitable for all recent versions of Oracle including 12c, 18c, and 19c.
Prerequisites
Delegates should have some knowledge of their operating system, together with Oracle SQL*Plus or SQL Developer skills. Our Oracle SQL course is the ideal way to gain this experience.
Duration
5 days. Hands on.
Course Objectives
This Oracle Database Administration course explores the fundamentals of basic database administration. The course is based around using the command line, but will provide Enterprise Manager Express and Cloud Control to complement and enhance the learning experience.
During this course, delegates 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
Course Content
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