Oracle Database Administration (DBA) Training by Expert Instructor John Watson

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

View Our Oracle Database Administration Training Classes

Search:

Course Title	Date

Backup and Recovery with Oracle RMAN	November 14, 2022 9:00 am
Oracle Database Security Administration Training	October 3, 2022 9:00 am
Oracle Database: Accelerated Multitenant Architecture	October 10, 2022 9:00 am
Oracle RAC and Grid Infrastructure Administration Fast Track Training	October 10, 2022 9:00 am
Execution Plans: The Essentials	October 17, 2022 9:00 am
Oracle Database Administration Workshop Level 1	October 18, 2022 9:00 am
Oracle SQL Tuning for Developers and DBAs	October 31, 2022 9:00 am
Oracle Cloud Infrastructure (OCI) Foundations: Getting Started	November 7, 2022 9:00 am
Oracle Database Administration Workshop Level 2	November 7, 2022 9:00 am
Oracle APEX Administration	November 21, 2022 8:00 am
Oracle Database Performance Tuning Workshop	November 28, 2022 9:00 am
Oracle Data Guard Administration Workshop	December 5, 2022 9:00 am
Oracle Database: Managing Multitenant Architecture	December 12, 2022 9:00 am

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

Our Oracle DBA Training Path

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.

Shaojing Guo August 25, 2022	5/5 What did you particularly like about the course? The way that John explains how Oracle generates the explain plan and why Oracle would do that is really helpful! Please describe your suggestions for improvement of the course. If this was an online course, do you have suggestions for improving the online software or delivery techniques?
Jeremy Alexander June 11, 2021	5/5 What did you particularly like about the course? 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. Please describe your suggestions for improvement of the course. 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. If this was an online course, do you have suggestions for improving the online software or delivery techniques? 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!
tomasz.michalak@chrr.osu.edu June 11, 2021	5/5 What did you particularly like about the course? good course material, good teacher! Please describe your suggestions for improvement of the course. I think all was great! A lot of material was covered, so definitely some work after class is needed! If this was an online course, do you have suggestions for improving the online software or delivery techniques? 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.
Hunter Standridge January 14, 2021	5/5 What did you particularly like about the course? 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. Please describe your suggestions for improvement of the course. I really can't think of anything to improve on. Really a great class, well done Skillbuilders. If this was an online course, do you have suggestions for improving the online software or delivery techniques? Nope none.

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.

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.

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

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

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

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

Oracle Database Administration (DBA) Training by Expert Instructor John Watson

Oracle Database Administration Training: By Certified, Expert Instructors