Search
Duration : 5 Days
1696 Partipants
Looking for Corporate TrainingCustomized expert training resources tailored to your specific needs
Oracle 19C Database Administration II Certification Training
Oracle 19C Database Administration II Certification TrainingOracle DBA II
Seek no more, explore the next level of DBA skills, and become an expert in Oracle Database Administration.
TTOR20619 Oracle 19c Database Administration II (Oracle 19c DBA II) is a 05-days course focusing on concepts of backup & recovery, working with grid infrastructu
Access to comprehensive course material
Continuous assistance and periodic course updates
24/7 support is available throughout the entire course
Oracle 19C Database Administration II
Oracle 19c Database Administration II (Oracle 19c DBA II) is designed for learners with experience with Oracle 19c DBA and who are willing to expand their knowledge about Oracle database administration. The five-day course has fifty percent expert-led lectures and fifty percent hands-on lab sessions. The course module is designed to let the learners explore multitenants, backup and recovery, SQL tuning, and database tuning. The learning gained from this course will ensure professionals are running the database efficiently and reliably.
The database presented in the coursework is useful for you to demonstrate and exercise its utilization. Group discussions and real-world demonstrations in the course will let you get a wider understanding of the course concept, increasing the efficiency of leading. This independent course aligns with the skills, topics, and tools you need to have a strong hold on to excel in the Oracle 19c database. In the course, professionals will learn to create and manage CDBs and PDBs, backup and duplicate, and other related functionalities. The experts will add their experiences in the class discussion in order to give you a more transparent idea about the market and the use of the Oracle 19c database in different settings.
Loading...
Oracle 19C Database Administration II Objectives
The 50% hands-on, along with the expert-led lectures, the course is a real-world demonstration of the concepts. Through the course, learners will be able to:
• Create CDB and regular PDB
• Manage both CDB and PDB
• Backup and duplicate
• Upgrade and transport CDB along with regular PDB
• Backup terminology and strategy
• Duplicate database
• Restore and recover concepts
• Use flashback technology
• Understand and use new features of Oracle database 18c
• Install grid infrastructure and Oracle database
• Patch grid infrastructure and Oracle database
• Upgrade the Oracle grid infrastructure
• Monitor and tune the performance of the database
• Use the general database enhancement
• Manage the PDB application
• Manage the multitenant database security
• Recover and flashback
• Diagnose failure
• Configure and use RMAN
• Transport data
• Perform recovery
• Oracle restart
• Create a database using DBCA
• RMAN tuning and troubleshooting
• Upgrade the Oracle database
• Use the availability enhancement
• Tune SQL statement
• Install grid infrastructure in the standalone server
Target Audience For Oracle 19C Database Administration II
The course is designed for professionals who have a basic understanding of the Oracle 19c database. IT professionals, managers, analysts, and database administrators wanting to explore new heights in their careers can opt for this course.
Course Outline
Module 1: Creating CDBs and Regular PDBs
• Configure and create a CDB
• Create a new PDB from the CDB seed
• Explore the structure of PDBs
Module 2: Manage CDBs and PDBs
• Manage PDB service names and connections
• Manage startup, shutdown, and availability of CDBs and PDBs
• Change the different modes and settings of PDBs
• Evaluate the impact of parameter value changes
• Performance management in CDBs and PDBs
• Control CDB and PDB resource usage with the Oracle Resource Manager
Module 3: Backup and Duplicate
• Perform Backup and Recover CDBs and PDBs
• Duplicate an active PDB
• Duplicate a Database
Module 4: Upgrading and Transporting CDBs and Regular PDBs
• Upgrade an Oracle Database
• Transport Data
Module 5: Backup Strategies and Terminology
• Perform Full and Incremental Backups and Recoveries
• Compress and Encrypt RMAN Backups
• Use a media manager
• Create multi-section backups of exceptionally large files
• Create duplexed backup sets
• Create archival backups
• Backup of recovery files
• Backup nondatabase files
• Back up ASM metadata
Module 6: Restore and Recovery Concepts
• Employ the best Oracle Database recovery technology for your failure situation
• Describe and use Recovery technology for Crash, Complete, and Point-in-time recovery
Module 7: Using Flashback Technologies
• Configure your database to support flashback
• Perform flashback operations
Module 8: Duplicating a Database
Duplicating a Database
Module 9: Install Grid Infrastructure and Oracle Database
Install Grid Infrastructure for a Standalone server
Install Oracle Database software
Module 10: Patching Grid Infrastructure and Oracle Database
Patching Grid Infrastructure and Oracle Database
Module 11: Upgrading to Oracle Grid Infrastructure
Upgrading to Oracle Grid Infrastructure
Module 12: Oracle Database 18c: New Features
Image and RPM-based Database Installation
Module 13: Using General Overall Database Enhancements
• Install Oracle Database software
• Create, Delete, and Configure Databases using DBCA
• Creating CDBs and Regular PDBs
• Use Miscellaneous 19c New Features
Module 14: Monitoring and Tuning Database Performance
• Managing Memory Components
• Understanding the Automatic Workload Repository (AWR)
• Understanding the Advisory Framework
• Monitoring Wait Events, Sessions, and Services
• Managing Metric Thresholds and Alerts
• Understanding and Using the Performance Tuning Methodology
• Performing Performance Planning
• Understanding the Automatic Database Diagnostic Monitor (ADDM)
Module 15: Manage Application PDBs
• Explain the purpose of application root and application seed
• Define and create application PDBs
• Install, upgrade, and Patch applications
• Create and administer the Application PDBS
• Clone PDBs and Application containers
• Plug and unplug operations with PDBs and application containers
• Comparing Local Undo Mode and Shared Undo Mode
Module 16: Manage Security in Multitenant databases
• Manage Security in Multitenant databases
• Manage PDB lockdown profiles
• Audit Users in CDBs and PDBs
• Manage other types of policies in application containers
Module 17: Recovery and Flashback
• Restore and Recovering Databases with RMAN
• Perform CDB and PDB flashback
Module 18: Configuring and Using RMAN
• Configure RMAN and the Database for Recoverability
• Configure and Use an RMAN recovery catalog
Module 19: Diagnosing Failures
• Detect and repair database and database block corruption
• Diagnosing Database Issues
Module 20: Performing Recovery
• Restore and Recovering Databases with RMAN
• Perform Non-RMAN database recovery
Module 21: Transporting Data
Transporting Data
Module 22: RMAN Troubleshooting and Tuning
• Interpret the RMAN message output
• Diagnose RMAN performance issues
Module 23: Creating an Oracle Database by using DBCA
Create, Delete, and Configure Databases using DBCA
Module 24: Oracle Restart
Configure and use Oracle Restart to manage components
Module 25: Upgrade the Oracle Database
• Plan for Upgrading an Oracle Database
• Upgrade an Oracle Database
• Perform Post-Upgrade tasks
Module 26: Install Grid Infrastructure for a Standalone server
Rapid Home Provisioning
Module 27: Using Availability Enhancements
Use an RMAN recovery catalog
Use Flashback Database
Module 28: Tuning SQL Statements
• Understanding the Oracle Optimizer
• Using the SQL Tuning Advisor
• Managing Optimizer Statistics
• Using the SQL Access Advisor
• Understanding the SQL Tuning Process
Choose Your Preferred Mode
Online Training
- Instructor led Online Training
- Experienced Subject Matter Experts
- Approved and Quality Ensured training Material
- 24*7 learner assistance and support
Corporate Training
- Customized Training Across Various Domains
- Instructor Led Skill Development Program
- Ensure Maximum ROI for Corporates
- 24*7 Learner Assistance and Support
FAQ’s
What is the course duration?
Oracle 19c database administration II (Oracle DBA II) (TTOR20619) is a five-day course.
Why should I enroll in this course by Vinsys?
The course content is designed to make sure that you get both a theoretical and practical understanding of the extended Oracle database administration functionality. With Vinsys, you will get the support of an experienced expert from the field who will enhance your learning efficiency in this course. Our courses are delivered through instructor-led training (ILT), private group training, and virtual instructor-led training (vLIT).
Can a beginner enroll in this course:
Out instructors led an instructor-peer session where discussions on the key concepts, e-learning platform, case studies, and Q&A sessions were held as the primary training delivery services for the client. In order to learn efficiently in this course, you must take the course below: TTORDBAADM19 Oracle 19c Database Administration I (Oracle DBA I).
Who should do this course?
This is an intermediate-level course that can be taken by IT professionals who have prior experience in Oracle 19c database concepts and skills.
How is the course program carried out at Vinsys?
Effective course material accessed throughout the program makes it easier to learn about concepts beyond the class. You can choose your learning path to upskill with Vinsys' subject matter experts upon customizing training needs to ensure 100% results. We believe everyone can succeed if given the right tools and knowledge to move toward their goal.
Is Oracle 19c Database Administration II difficult?
The course content is kept simple to ensure that it will be easy for learners to understand. At places where learners find difficulties, the experts will provide the required assistance.
What are the career opportunities after completing this course?
Learners can get recognized for their ability to use and manage databases using Oracle 19c database administration. The course will help you get better opportunities while dealing with complex databases, and you can get hired as an Oracle DBA.
What is the course code?
TTOR20619 is the code of the Oracle 19c database administration II (Oracle DBA II).
What are the related courses?
The related courses include-
• Oracle 19C Database Multitenant Architecture (TTOR20719)
• Oracle 19c Database Tuning (TTOR21519)
• Oracle Database 19c Backup and Recovery (TTOR21619)
• Oracle 19c Database Security
Why Vinsys
Seasoned Instructors
Official Vendor Partnerships
Authorized Courseware
3,000+ Courses & 2,000+ Modules
In Synch with Tech-advancements
Customizable Blended Learning Options
Reviews
Oracle 19c database administration II (Oracle DBA II) (TTOR20619) has helped me to understand the functionality of the Oracle 19c database. I have already taken the Oracle 19c Database Administration I course, and because of this, I had a smooth learning experience in this course. After gaining hands-on experience with Oracle, I was able to manage the database better at my workplace.
Aranjan PhuseDatabase Architect
My team enrolled for the Oracle 19c Database Administration II course after the completion of the Administration I course. The expert-led course provided attention to each team member and helped them overcome the difficulties that they faced while learning the course concepts. The practical session was an added advantage since it helped the team members understand how the theoretical concepts can be applied in different situations. Thanks, Vinsys!
Pratik NarayanData Scientist
X
Select Language
X
Select Country
X
ENQUIRE NOW