Overview
This course is targeted at Database Administrators and begins with explaining the architecture of an Oracle Database instance and the tools used to access it. The course includes creating and managing a database, configuring and managing Oracle Net Services along with creating and administering pluggable databases (PDBs). You learn how to create and manage database storage, users, backup, and implement database security.
Additionally, the course covers protection of database against failures, loading, and transporting data.
Skills Covered
Learn to:
- Describe Oracle Database architecture
- 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
Who Should Attend
Everyone who are interested to attend this training.
Course Curriculum
Prerequisites
There are no prerequisites required to attend this course.
Download Course Syllabus
Course Modules
- Course Overview – Oracle Database 23ai: Administration Workshop
- Oracle Database 23ai Enhancements
- Oracle Database Server Architecture: Overview
- Oracle Database Memory Structures
- Process Architecture
- Database Sharding: Introduction
- Connecting to an Oracle Database Instance
- SQL*Plus
- Enterprise Manager Cloud Control 13c Features
- Planning the Database
- Using the Database Configuration Assistant
- Practice 3-1: Creating a New CDB
- Creating an Oracle Database by Using a SQL Command
- Practice 4-1: Creating a New CDB
- Starting Up and Shutting Down a Database Instance
- Practice 5-1: Shutting Down and Starting Up the Oracle Database.
- Working with Initialization Parameters
- Working with the Automatic Diagnostic Repository
- Querying Dynamic Performance Views
- Practice 6-1: Investigating Initialization Parameter Files
- Practice 6-2: Viewing Initialization Parameters by Using SQL*Plus
- Practice 6-3: Modifying Initialization Parameters by Using SQL*Plus
- Practice 6-4: Viewing Diagnostic Information
- Oracle Net Services: Overview
- Configuring Naming Methods
- Practice 8-1: Configuring the Oracle Network to Access a Database
- Practice 8-2: Creating a Net Service Name for a PDB
- Configuring and Administering the Listener
- Practice 9-1: Exploring the Default Listener
- Practice 9-2: Creating a Second Listener
- Configuring a Shared Server Architecture
- Practice 10-1: Configuring Shared Server Mode
- Practice 10-2: Configuring Clients to Use a Shared Server
- Creating PDBs from Seed
- Practice 11-1: Creating a New PDB from the PDB Seed
- Cloning Regular PDBs
- Plugging an Unplugged Regular PDB into CDB
- Managing PDBs
- Practice 13-1: Renaming a PDB
- Practice 13-2: Setting Parameter Values for PDBs
- Database Storage Overview
- Creating and Managing Tablespaces
- Practice 15-1: Viewing Tablespace Information
- Practice 15-2: Creating a Tablespace
- Practice 15-3: Managing Temporary and Permanent Tablespaces
- Space Management Features
- Using Temporary Tables
- Resolving Space Usage Issues
- Practice 16-1: Managing Space in Tablespaces
- Practice 16-2: Using Compression
- Practice 16-3: Enabling the Resumable Space Allocation Feature
- Managing Undo Data
- Practice 17-1: Viewing Undo Tablespaces in a CDB .
- Database User Accounts
- Using Password Authentication
- Practice 18-1: Creating Common and Local Users
- Practice 18-2: Creating a Local User for an Application
- Practice 18-3: Exploring OS and Password File Authentication
- Privileges
- Object Privileges
- Practice 19-1: Granting a Local Role (DBA) to PDBADMIN
- Practice 19-2: Using SQL*Developer to Create Local Roles.
- Configuring User Resource Limits
- Practice 20-1: Using SQL*Developer to Create a Local Profile.
- Practice 20-2: Configuring a Default Role for a User .
- Database Security
- Database Auditing: Overview
- Modifying a Unified Audit Policy
- Practice 21-1: Enabling Unified Auditing
- Practice 21-2: Creating Audit Users
- Practice 21-3: Creating an Audit Policy .
- Introduction to Loading and Transporting Data
- Loading Data
- Practice 23-1: Loading Data into a PDB from an External File
- Data Pump Export and Import Clients
- Using RMAN to Transport Data Across Platforms
- Practice 24-1: Moving Data from One PDB to Another PDB
- Practice 24-2: Transporting a Tablespace
- Using External Tables to Load and Transport Data
- Practice 25-1: Querying External Tables .
- Practice 25-2: Unloading External Tables
- Automated Maintenance Tasks: Overview
- Automated Maintenance Tasks: Managing Tasks and Windows
- Practice 27-1: Enabling and Disabling Automated Maintenance Tasks
- Practice 27-2: Modifying the Duration of a Maintenance Window
- Database Monitoring and Tuning Performance Overview
- Monitoring Database Performance
- SQL Tuning Process
- Adaptive Execution Plans
Request More Information
Training Options
- ILT: Instructor-Led Training
- VILT: Virtual Instructor-Led Training
Intake: 26-30 May 2025
Duration: 5 Days
Guaranteed: TBC
Modality: ILT
Exam:
Intake: 26-30 May 2025
Duration: 5 Days
Guaranteed: TBC
Modality: VILT
Exam:
Intake: 28 Jul - 1 Aug 2025
Duration: 5 Days
Guaranteed: TBC
Modality: ILT
Exam:
Intake: 28 Jul - 1 Aug 2025
Duration: 5 Days
Guaranteed: TBC
Modality: VILT
Exam:
Intake: 6-10 Oct 2025
Duration: 5 Days
Guaranteed: TBC
Modality: ILT
Exam:
Intake: 6-10 Oct 2025
Duration: 5 Days
Guaranteed: TBC
Modality: VILT
Exam:
Exam & Certification
Oracle Database 23ai Administration Associate (1Z0-182).
