Course 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.
What are the 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 this course
Everyone who are interested to attend this training.
Course Curriculum
What are the 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
Exam & Certification
Oracle Database 23ai Administration Associate (1Z0-182).
Training & Certification Guide
With Oracle Cloud Infrastructure (OCI) emerging as a leader in the 2024 Gartner® Magic Quadrant™ for Strategic Cloud Platform Services, the platform presents an unparalleled opportunity for professionals to advance their careers. Beyond the technology, OCI represents a gateway to being part of a future where cloud computing defines how organizations operate, innovate, and succeed.
But why is upskilling in OCI so crucial now? Let’s explore the unique advantages of Oracle’s cloud solutions, the opportunities they unlock, and how they align with Malaysia’s booming cloud ecosystem.
Empower Your Career: How Oracle Helps You Thrive in Cloud and AI
According to Malaysia’s Ministry of Human Resources, nearly 4.5 million jobs in Malaysia could be affected by automation by 2030, emphasizing the need for urgent workforce reskilling (Ministry of Human Resources Malaysia, 2022). The rapid rise of cloud computing and AI is transforming the IT landscape, making upskilling more crucial than ever.
At Trainocate Malaysia, we understand the challenges IT professionals face—keeping up with innovations, staying competitive, and navigating the ever-changing demands of the industry. That’s why we offer Oracle-authorized training, giving you the skills and certifications needed to thrive in the digital era.
In this blog, we’ll explore how Trainocate Malaysia can help you stay ahead, enhance your expertise, and take your career to the next level.
