Facebook

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:
psinghal
Last Update December 15, 2023
0 already enrolled

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

Creating CDBs and Regular PDBs
Managing 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
Installing 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
Managing Application PDBs
Managing 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
Upgrading the Oracle Database
Installing Grid Infrastructure for a Standalone server
Using Availability Enhancements
Tuning SQL Statements

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

76 Lessons40h

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

psinghal

0/5
472 Courses
0 Reviews
0 Students
See more

Write a review

IMG1696506801.jpg

$2,795.00

Level
Intermediate
Duration 40 hours
Lectures
76 lectures
Print Friendly, PDF & Email

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.*
🚀 Boost Your Career with Premium Training at Unbeatable Prices! Limited-time Special Offer on Top Certifications.
This is default text for notification bar
#edumall-wp-widget-courses-1 { display: none; } #single-course-ratings { display: none; } .tutor-single-course-lead-meta { display: none; } .lead-meta-item meta-course-total-enrolled { display: none; }