Back

Oracle Database Administration Training: By Certified, Expert Instructors

Online instructor-led hands-on training and mentoring from one of the world’s most experienced and knowledgeable Oracle Database Administrators, Oracle Certified Master John Watson.   (On-premise training is also available in some areas. )

In addition to John’s Oracle Certified Master DBA credential, John has attained an “Oracle Certified Expert” in the following:

  • Maximum Availability Certified Master
  • RAC and Grid Infrastructure Administrator
  • Maximum (High) Availability (RAC)
  • Data Guard Administrator
  • Performance Management and Tuning
  • Security Certified Implementation Specialist

In 2021, John also attained Oracle’s “Professional Oracle Cloud Infrastructure Architect” certification!

See some demos of our training below.  We also have released some of our previous content in our free oracle DBA training section.

Online or In-Person Instruction for Oracle Database Administration by These Experts

Dave Anderson

John Watson Oracle Certified Master DBA, Oracle Cloud Infrastructure Architect

Geoffrey Wiland

John Watson: A world-renowned Oracle Author

Here is Where to Start with DBA Training

We know it can be hard to make the right decision on what to spend time and money on when it comes to Oracle Education.  At Skillbuilders we want to make it easy to get the information you need.  To start you can call us right now at +1(401)783-6172 with any Oracle DBA Training or Certification class questions.

DBA Training Stats

368000
Students Viewed Our Free Content
500
5 Star Ratings Across Classes
2545
Attended Live DBA Training
115
Dedicated DBA Training Classes

View Our Oracle Database Administration Training ClassesOracle Partner Logo

All classes are online unless otherwise noted with a physical classroom location.
All dates are in Eastern Time (ET).

Search:

Course Title Date
Oracle Grid Infrastructure
  • Please Call
Oracle RAC Administration Training
  • Please Call
Oracle SQL Tuning for Developers and DBAs
  • August 7, 2023 9:00 am
Oracle Database Administration Workshop Level 2
  • August 14, 2023 9:00 am
Oracle Database: Managing Multitenant Architecture
  • June 19, 2023 9:00 am
Oracle APEX Administration
  • June 26, 2023 9:00 am
Oracle Data Guard Administration Workshop
  • June 5, 2023 9:00 am
Oracle ASM / ACFS Administration
  • Please Call
Oracle RAC and Grid Infrastructure Administration Fast Track Training
  • Please Call
Oracle Database Administration Workshop Level 1
  • August 21, 2023 9:00 am
Backup and Recovery with Oracle RMAN
  • August 28, 2023 9:00 am
Oracle Database Security Administration Training
  • July 24, 2023 9:00 am
Oracle Database Performance Tuning Workshop
  • June 12, 2023 9:00 am
How to Read Oracle Execution Plans
  • June 28, 2023 9:00 am
Oracle Cloud Infrastructure (OCI) Foundations: Getting Started
  • July 10, 2023 9:00 am
Oracle Database: Accelerated Multitenant Architecture
  • July 12, 2023 9:00 am
Oracle SQL Tuning - Core Skills for Developers
  • September 7, 2023 9:00 am

Our Oracle DBA Training Path

Oracle DBA FAQs

  • Backup and recovery: Is a Data Pump export a backup?

    No. An export cannot be used to restore and recover a damaged or missing data file.

  • Backup and recovery: Can you backup on one platform and restore to another?
    Yes, but there are some limitations and it can be awkward.
  • Backup and recovery: Can you backup in one release and restore to a higher release?
    Yes, but have to run the upgrade routine against the restored database.
  • DB tuning: What is a wait event?
    Something that causes a session or the instance to hang. They happen - not necessarily a problem.
  • DB tuning: Are AWR reports available in Standard Edition?
    No, the AWR requires EE plus the Diagnostics Pack. Use Statspack if these are not available.
  • DB tuning: Is Automatic Memory Management a feature one should use?
    It makes DB Admin easier, but does have limitations. Probably best to use it only on lower end systems.
  • Multitenant: How is Multitenant licensed?
    Free, and very useful, in all editions for up to three PDBs. More than three? You need EE plus the option.
  • Multitenant: Can you unplug from, eg, a release 12.x DB and plug in to a 19.x DB?
    Sure, then run the upgrade routine against it. Probabaly the easiest and quickest way to upgrade.
  • Security: Can an old 10g client connect to an 19c database?
    Yes, if you configure the database to generate and accept 10g password verifiers.
  • Security: Why don't roles work in PL/SQL definer's rights procedures?
    Because roles are dynamically enabled and disabled, but PL/SQL is statically compiled.

DBA Training Reviews

 5/5

The way that John explains how Oracle generates the explain plan and why Oracle would do that is really helpful!


 5/5

I'm a big fan of Watson. His book got me through my OCA and every class with him is highly informative and I enjoy learning from him how to use the command line tools vs the GUIs, which is all they teach in the Oracle University classes.

If I had to be picky, maybe larger test data to see how dramatic the differences in performance can be. When comparing a plan with a cost of 7 vs 3 you get the idea but it might really drive it home to see 1,000,000 vs 1,000.

None, I loved the environment and wouldn't change a thing. I've taken previous skillbuilders classes and I'll be back in the future!
 5/5

good course material, good teacher!

I think all was great! A lot of material was covered, so definitely some work after class is needed!

Doing homework together in the morning reinforces the knowledge passed on us during prev day class. And this is what Joh did with us. Going again via those excersizes really help to understand things better.
 5/5

I really enjoyed this class. John really knows what he is doing and he can talk through it from many angles. I have had official Oracle training and this is way better. Way more presenter interaction.

I really can't think of anything to improve on. Really a great class, well done Skillbuilders.

Nope none.

Companies we Have Partnered With

images

Hudson Advisors

SkillBuilders developed a custom single sign-on solution allowing seamless navigation and integration between the customer’s Oracle E-Business applications and custom APEX applications.

industry-news-bae-systems-launches-corporate-security-analysis-imageFile-8-a-7766

BAE Systems | Manchester, New Hampshire

As the lead Oracle Application Express (APEX) resource, Dan leveraged his knowledge of APEX, Oracle, and related web based technologies to help design and build a custom user interface on BAE’s existing Oracle EBS back end. Dan was an integral part of a team effort that took the project from behind to ahead of schedule while total staff was decreased. The project was completed on time and above expectations – a finished product which included additional deliverables.

nccc

North Carolina Community College NCCC

SkillBuilders was brought in to salvage and complete the project. SkillBuilders successfully completed the project on time and under budget.  The Apprentice Program application was migrated to SkillBuilders’ AWS hosting platform in the Spring of 2016.  This included a migration from BI Publisher to FOP and Apex Office Print.

pva

Paralyzed Veterans of America

SkillBuilders developed an Online Registration system for the Paralyzed Veterans of America (PVA) with Oracle APEX. The application allows participants and coaches to enroll in the annual National Wheelchair Games via the web. Mobile tablet support was essential to satisfy the needs of the participants. A back office component of the application allows staff to process the applications.

ge_capital

GE Capital

“I thought the instructor was excellent. Mick Hosegood did a very good job. The course content and materials were also well done!”

waters

Waters

“When Waters Corp software customers needed a tool to manage ASM disks, non-ASM disk, RMAN backups, imports/exports, monitor and send alerts, manage database users (e.g. password management), SkillBuilders developed an integrated Oracle APEX solution.”

Boehringer Ingelheim_logo

Boehringer Ingelheim

“In addition to training BI developers Oracle database, SQL and APEX development, SkillBuilders provides on-going application design reviews, planning and development assistance.”