Course Description

Our 5-day Oracle administration training provides students with the skills needed to administer and maintain an Oracle database. Included in the course are detailed instructions on the facilities available for database design, administration, and daily operation including user management and logical backup and recovery.

The issues involved in creating a new instance and database are also presented. The Data Dictionary is examined in detail to create an awareness among participants of the wealth of system information available to the informed user of the system. Dynamic performance tables are also examined to provide access to additional information about a database and instance.

Numerous workshops serve to reinforce and expand upon topics presented during lectures. This course can be taught for any Oracle version, including Oracle 18c.

Audience
Database Administrators responsible for the administration of an Oracle database.
Prerequisites
Introduction to Oracle SQL or equivalent experience.

Course Summary

Next Public Course Dates

UK & Europe:

  • 17 - 21 November 2025
  • 1 - 5 December 2025
  • 15 - 19 December 2025

US & Canada:

  • 8 - 12 December 2025
  • 12 - 16 January 2026
  • 26 - 30 January 2026

More dates

Prerequisites
  • Introduction to Oracle SQL or equivalent experience.
Duration
  • 5 Days
Available Formats
  • Public Virtual Live Instructor-Led
  • Private Virtual Live Instructor-Led
  • Private Onsite
Post Training SupportYes, our certified Oracle trainers will be available for additional questions once you start working on your projects.

Course Modules

  • Overview of Oracle Architecture
  • Manageability Features
  • Tablespaces & Data Files
  • User Administration
  • Tables
  • Indexes
  • Clusters
  • Documenting Objects
  • Synonyms
  • Sequences
  • Views
  • Managing UNDO Data
  • Utilities
  • Resumable Space Allocation
  • Oracle 18c New Features

Testimonials

The trainer was INCREDIBLE. He was extremely passionate, made sure to consistently ask if anybody needed help, logged on early to answer any questions, and was an overall great human being.

★★★★★

- Salvatore, Hilton Grand Vacations

Hands-down the best technical training I have taken! The methods of progressively building reports, adding complexity and features as time goes on, was fantastic.

★★★★★

- Chris, Cirrus Aircraft

The trainers clear and obvious enthusiasm for number crunching, analytics, and teaching others is infectious. He doesn’t waste time, shows exactly what you need to know and is genuinely hilarious.

Every one of my employees had tons of positive stuff to say.

★★★★★

- Benjamin G, MXSG Analysis and Integration Chief, US Air Force

Upcoming Public Virtual Live Instructor-led Course Dates

UK & Europe:

US & Canada:

    To discuss your project requirements, send us a message

      For a free assessment, quick quote or training information, send us a message

        To book this course, please fill in your details and submit the form.

          To book this course, please fill in your details and submit the form.

            To discuss your training requirements or book a class, drop us a line