Oracle 19c Database Administration II
* Looking for a flexible schedule (after hours or weekends)? Please call 858-208-4141 or email us: sales@ccslearningacademy.com.
Student financing options are available.
Transitioning military and Veterans, please contact us to sign up for a free consultation on training and hiring options.
Looking for group training? Contact Us
Course schedule:
About This Course
Course Description
Geared for participants experienced with Oracle 19c DBA essentials Oracle 19c Database Administration Workshop 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.
Learning Objectives
Inclusions
- Certified Instructor-led training
- Official Training Seminar Student Handbook
- Collaboration with classmates (not currently available for self-paced course)
- Real-world learning activities and scenarios
- Exam scheduling support*
- Enjoy job placement assistance for the first 12 months after course completion.
- This course is eligible for CCS Learning Academy’s Learn and Earn Program: get a tuition fee refund of up to 50% if you are placed in a job through CCS Global Tech’s Placement Division*
- Government and Private pricing available.*
Pre-requisites
- Attendees should have skills equivalent to or should have attended this course as a pre-requisite: Oracle 19c Database Administration I (Oracle DBA I)
Curriculum
1. Creating CDBs and Regular PDBs
Configure and create a CDB
Create a new PDB from the CDB seed
Explore the structure of PDBs
2. Manage CDBs and PDBs
3. Backup and Duplicate
4. Upgrading and Transporting CDBs and Regular PDBs
5. Backup Strategies and Terminology
6. Restore and Recovery Concepts
7. Using Flashback Technologies
8. Duplicating a Database
9. Install Grid Infrastructure and Oracle Database
10. Patching Grid Infrastructure and Oracle Database
11. Upgrading to Oracle Grid Infrastructure
12. Oracle Database 18c: New Features
13. Using General Overall Database Enhancements
14. Monitoring and Tuning Database Performance
15. Manage Application PDBs
16. Manage Security in Multitenant databases
17. Recovery and Flashback
18. Configuring and Using RMAN
19. Diagnosing Failures
20. Performing Recovery
21. Transporting Data
22. RMAN Troubleshooting and Tuning
23. Creating an Oracle Database by using DBCA
24. Oracle Restart
25. Upgrade the Oracle Database
26. Install Grid Infrastructure for a Standalone server
27. Using Availability Enhancements
28. Tuning SQL Statements
Your Instructors
Write a review
$2,795.00
Inclusions
- Certified Instructor-led training
- Official Training Seminar Student Handbook
- Collaboration with classmates (not currently available for self-paced course)
- Real-world learning activities and scenarios
- Exam scheduling support*
- Enjoy job placement assistance for the first 12 months after course completion.
- This course is eligible for CCS Learning Academy’s Learn and Earn Program: get a tuition fee refund of up to 50% if you are placed in a job through CCS Global Tech’s Placement Division*
- Government and Private pricing available.*
AZ-204T00-A: Developing solutions for Microsoft Azure
$2,195.00$2,695.00
DP-900T00: Microsoft Azure Data Fundamentals
$495.00$795.00
