Administrators and developers with SQL basics learn how to run an Oracle database in this seminar. You work with the instance, tablespaces and user privileges, set up backup and recovery with RMAN and monitor the database through the alert log and the performance views.
What you’ll take away.
- Distinguish the instance from the database and place memory areas and background processes
- Explain the multitenant architecture with a container database and pluggable databases, and create a pluggable database
- Manage tablespaces and data files and describe what undo and redo are for
- Set up users, roles, privileges and profiles
- Take backups with RMAN, practise a restore and export and import data with Data Pump
Your training in detail
- Who is it for?
- New database administrators, system administrators and developers who take over or support the operation of an Oracle database.
- Prerequisites
- Basic SQL. Confident use of the Linux command line is helpful.
- Format & planning
- Indicative range: 2 to 4 learning days, depending on prior experience, desired depth and practical scope. Duration is set only after discussing requirements.
Agenda: from understanding to application
Our independently developed agenda proposal. Focus areas, lab environment and scope are agreed before booking.
Instance and database: the SGA and PGA memory areas, background processes such as DBW, LGWR, CKPT, SMON and PMON, and data files, control files and online redo logs.
Multitenant architecture: container database (CDB), root container and pluggable databases (PDBs). You create a PDB from the seed and get to know cloning and unplugging and plugging in as further options.
Storage: creating and extending tablespaces and data files, the SYSTEM and SYSAUX tablespaces, temporary tablespaces, automatic undo management and the purpose of the redo logs.
Users and privileges: creating users with a default tablespace and quota, granting system and object privileges, building roles and using profiles for resource and password limits.
Backup, transfer and monitoring: backup and recovery with RMAN in ARCHIVELOG mode, export and import with Data Pump, the alert log and the dynamic performance views (V$).
Suggested exercise: In a practice environment you create a pluggable database and a tablespace, set up a user with a role, back up the database with RMAN and then restore a data file or a table.
Exams, licences & credentials
This is not an exam course and not official Oracle training. Attending alone does not award an Oracle vendor certification.
Vendor references & review date
Sources checked on 2026-11-18. These sources describe the technology or external exam requirements. They do not imply a partnership with NextNowa.
- Oracle Database Concepts: Introduction to Oracle Database ↗
- Oracle Database Concepts: Process Architecture ↗
- Oracle Database Concepts: Data Dictionary and Dynamic Performance Views ↗
- Oracle Multitenant Administrator's Guide: Overview of PDB Creation ↗
- Oracle Database Administrator's Guide: Managing Tablespaces ↗
- Oracle Database Administrator's Guide: Managing Undo ↗
- Oracle Database Administrator's Guide: Managing Users and Securing the Database ↗
- Oracle Database SQL Language Reference: CREATE PROFILE ↗
- Oracle Database Backup and Recovery User's Guide: Getting Started with RMAN ↗
- Oracle Database Backup and Recovery User's Guide: Recovering Tables and Table Partitions ↗
- Oracle Database Utilities: Overview of Oracle Data Pump ↗
- Oracle Database Administrator's Guide: Diagnosing and Resolving Problems ↗
Your learning content
These objectives describe the training topic. The specific syllabus, duration, dates, trainer and price are agreed before booking.
As training for your team
You can request "Administering Oracle databases" as training for your team only, live online. Content, examples and scope are agreed around your tasks. Date and total price are stated in the offer.
Frequently asked questions
Which Oracle version do we work with?
We agree that when you enquire. Tell us which version you run or plan to introduce so that the practice environment and examples match. Details, for instance of the multitenant architecture, depend on the version.
Does the course lead to an Oracle certification?
No. Attending does not award a vendor certificate, and the course is not designed as exam preparation. It covers everyday administration tasks. Oracle itself tells you which exams it offers and what they require.
What prior knowledge do I need?
You should be able to write simple SQL queries. Routine on the Linux command line also helps, because you start tools such as RMAN and Data Pump from the operating system's command line.
Does Administering Oracle databases include a certificate?
This is not an exam course and not official Oracle training. Attending alone does not award an Oracle vendor certification.
