Geared for participants experienced with Oracle 19c DBA essentials Oracle 19c Database Administration Workshop II (Oracle DBA II) expands their understanding of Oracle database administration. Throughout the course students will explore coverage of Multitenant (CDB/PDB), database tuning, SQL tuning, and backup and recovery: the skills needed to keep a database running reliably and efficiently. The current release of the database is used for exercises and demonstrations, and the content back-ported as necessary for previous releases.
This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our expert facilitator, students will explore:
Need different skills or topics? If your team requires different topics or tools, additional skills or custom approach, this course may be further adjusted to accommodate. We offer additional Oracle, database, scripting, administration and other related topics that may be blended with this course for a track that best suits your needs.
This hands-on course is geared for experienced DBAs with basic Oracle 19c skills.
Please see the Related Courses tab for specific Pre-Requisite courses, Related Courses or Follow On training options. Our team will be happy to help you with recommendations for next steps in your Learning Journey.
Please note that this list of topics is based on our standard course offering, evolved from typical industry uses and trends. We’ll work with you to tune this course and level of coverage to target the skills you need most.
Creating CDBs and Regular PDBs
Manage CDBs and PDBs
Backup and Duplicate
Upgrading and Transporting CDBs and Regular PDBs
Backup Strategies and Terminology
Restore and Recovery Concepts
Using Flashback Technologies
Duplicating a Database
Install Grid Infrastructure and Oracle Database
Patching Grid Infrastructure and Oracle Database
Upgrading to Oracle Grid Infrastructure
Oracle Database 18c: New Features
Using General Overall Database Enhancements
Monitoring and Tuning Database Performance
Manage Application PDBs
Manage Security in Multitenant databases
Recovery and Flashback
Configuring and Using RMAN
Diagnosing Failures
Performing Recovery
Transporting Data
RMAN Troubleshooting and Tuning
Creating an Oracle Database by using DBCA
Oracle Restart
Upgrade the Oracle Database
Install Grid Infrastructure for a Standalone server
Using Availability Enhancements
Tuning SQL Statements
All course labs and solutions, data sets, Oracle software (limited version, for course use only), detailed courseware, lab guides and resources (as applicable) are provided for attendees in our easy access, no installation required, remote lab environment for the duration of the course. Our tech team will help set up, test and verify lab access for each attendee prior to the course start date, ensuring a smooth start to class and successful hands-on course experience for all participants.
Live scheduled classes are listed below or browse our full course catalog anytime
Check out custom training solutions planned around your unique needs and skills.
Exclusive materials, ongoing support and a free live course refresh with every class.
Please see the current upcoming available open enrollment course dates posted below. Please feel free to Register Online below, or call 844-475-4559 toll free to connect with our Registrar for assistance. If you need additional date options, please contact us for scheduling.
Course Title | Days | Date | Time | Price | |
---|---|---|---|---|---|
Oracle 19c Database Administration Workshop II (Oracle DBA II) | 5 Days | Mar 29 to Apr 2 | 10:00 AM to 06:00 PM EST | $2,795.00 | Register |
Oracle 19c Database Administration Workshop II (Oracle DBA II) | 5 Days | May 24 to May 28 | 10:00 AM to 06:00 PM EST | $2,795.00 | Register |
Oracle 19c Database Administration Workshop II (Oracle DBA II) | 5 Days | Jul 26 to Jul 30 | 10:00 AM to 06:00 PM EST | $2,795.00 | Register |
Oracle 19c Database Administration Workshop II (Oracle DBA II) | 5 Days | Oct 4 to Oct 8 | 10:00 AM to 06:00 PM EST | $2,795.00 | Register |
Oracle 19c Database Administration Workshop II (Oracle DBA II) | 5 Days | Dec 6 to Dec 10 | 10:00 AM to 06:00 PM EST | $2,795.00 | Register |
New Site, BIG Savings!
We're celebrating the launch of our lonnngggg awaited new site with with *50% off all 2021 Public Classes* booked by March 31! Check out our Current Offers for Individuals, Teams and Organizations to Learn for Less!
Special Offers
Limited Offer for most courses.
SAVE 50%