Personal training advice

Live online training for international teams.For businesses
EnquireFind my course
Databases

Administering Oracle databases

Run Oracle databases: storage structures, user privileges, backup and monitoring for administrators who already know basic SQL queries.

Price on request · Dates by arrangement

Enquire about trainingAsk on WhatsApp

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.

IntermediateDE / ENBusiness training · Live online

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
Oracle

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.

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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$).

PRACTICE & TRANSFER

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.

Your learning content

These objectives describe the training topic. The specific syllabus, duration, dates, trainer and price are agreed before booking.

Individual offer: Availability and delivery are confirmed on enquiry.

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.

How team training works

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.

KEEP LEARNING

Related topics in this field

View all topics

Also relevant

Guides

NextNowa Guide

Your training guide

What would you like to learn next?

Ask about courses, learning paths or advice. I will help you find your next step.

Automated guidance using reviewed information. No booking or funding confirmation. Please avoid sensitive data.