Oracle Database 19c Administration 2
Instructor-led Oracle-aligned training in Oracle Database 19c Administration 2. Delivered live online by senior practitioners, with hands-on labs and a final assessment. Includes an Skilvi course-completion certificate.
Overview
Oracle Database 19c Administration 2 is designed to deepen your understanding of database administration with a focus on advanced features and functionalities. This course is essential for database administrators looking to enhance their skills and manage Oracle databases more effectively in complex environments.
What you'll learn
- You will be able to implement Oracle Database security features to protect sensitive data.
- You will be able to configure and manage Oracle database backup and recovery processes.
- You will be able to use Oracle Data Pump for efficient data transfer.
- You will be able to optimize database performance using various tuning techniques.
- You will be able to manage and monitor Oracle database instances effectively.
- You will be able to apply Oracle multitenant architecture principles for cloud deployments.
- You will be able to automate routine database tasks using Oracle Scheduler.
- You will be able to implement and manage Oracle Flashback technology for data recovery.
Curriculum
8 modules · outline is indicative and can be tailored to your team.
1Database Security
- Understanding Oracle Database security architecture
- Implementing user authentication and authorization
- Managing roles and privileges
2Backup and Recovery
- Configuring RMAN for backup and recovery
- Performing full and incremental backups
- Restoring and recovering the database
3Data Pump
- Using Data Pump for data export and import
- Managing metadata and data transfer
- Handling job monitoring and troubleshooting
4Performance Tuning
- Identifying performance bottlenecks
- Using Oracle Automatic Workload Repository (AWR)
- Implementing SQL tuning techniques
5Instance Management
- Starting and stopping Oracle instances
- Monitoring instance performance
- Managing instance parameters
6Multitenant Architecture
- Understanding pluggable databases (PDBs)
- Creating and managing PDBs
- Migrating databases to multitenant architecture
7Automation with Oracle Scheduler
- Creating and managing jobs
- Scheduling tasks and monitoring execution
- Using job chains for complex workflows
8Flashback Technology
- Implementing Flashback Query
- Using Flashback Table and Flashback Database
- Understanding the benefits of using Flashback
Prerequisites
Basic knowledge of Oracle Database concepts is recommended.
Who should attend
This course is suitable for database administrators and IT professionals seeking to advance their Oracle Database management skills.
Certification
Prepares you for the official Oracle certification exam.
Skilvi is an independent training provider and is not affiliated with, or endorsed by, Oracle. Trademarks are the property of their respective owners.
Frequently asked questions
What is the delivery format of this course?
The course is delivered live online, allowing for interactive participation.
How long is the course?
The course typically spans over 40 hours, divided into several sessions.
Will I receive a certificate upon completion?
Yes, participants will receive an Skilvi course-completion certificate.
Are exam vouchers included with the course?
Exam vouchers are available through authorized channels on request.
Is prior experience required for this course?
Basic knowledge of Oracle Database concepts is recommended, but no prior experience is required.
Pricing on request
- Live online (VILT)
- 24–32 hours
- Hands-on labs & assignments
- Skilvi completion certificate
- Exam voucher on request
Related courses
OracleOracle Autonomous Database Cloud 2024 Professional
Instructor-led Oracle-aligned training in Oracle Autonomous Database Cloud 2024 Professional. Delivered live online by senior practitioners, with hands-on labs and a final assessment. Includes an Skilvi course-completion certificate.
OracleOracle Cloud Data Management
Instructor-led Oracle-aligned training in Oracle Cloud Data Management. Delivered live online by senior practitioners, with hands-on labs and a final assessment. Includes an Skilvi course-completion certificate.
OracleOracle Cloud Infrastructure Foundations
Instructor-led Oracle-aligned training in Oracle Cloud Infrastructure Foundations. Delivered live online by senior practitioners, with hands-on labs and a final assessment. Includes an Skilvi course-completion certificate.
OracleOracle Cloud Infrastructure OCI 2024 Architect Professional
Instructor-led Oracle-aligned training in Oracle Cloud Infrastructure OCI 2024 Architect Professional. Delivered live online by senior practitioners, with hands-on labs and a final assessment. Includes an Skilvi course-completion certificate.