Oracle Database Administration 19c
Instructor-led Oracle-aligned training in Oracle Database Administration 19c. Delivered live online by senior practitioners, with hands-on labs and a final assessment. Includes an Skilvi course-completion certificate.
Overview
This Oracle Database Administration 19c course equips you with the essential skills to manage and maintain Oracle databases effectively. You will learn about the latest features and best practices that are crucial for ensuring optimal database performance and security in today's enterprise environments.
What you'll learn
- You will be able to install and configure Oracle Database 19c.
- You will be able to manage database storage structures and datafiles.
- You will be able to implement backup and recovery strategies using RMAN.
- You will be able to perform database monitoring and tuning for optimal performance.
- You will be able to manage user accounts and security policies.
- You will be able to utilize Oracle Data Guard for disaster recovery.
- You will be able to automate routine tasks using Oracle Scheduler.
- You will be able to apply patching and upgrading techniques for Oracle Database.
Curriculum
8 modules · outline is indicative and can be tailored to your team.
1Introduction to Oracle Database 19c
- Overview of Oracle Database Architecture
- Installation and Configuration
- Database Initialization Parameters
2Database Storage Management
- Managing Datafiles and Tablespaces
- Understanding Logical and Physical Storage
- Using Oracle Automatic Storage Management (ASM)
3Backup and Recovery
- Creating Backup Strategies
- Using RMAN for Backup and Recovery
- Point-in-Time Recovery Techniques
4Performance Monitoring and Tuning
- Using Oracle Enterprise Manager
- Identifying Performance Bottlenecks
- SQL Tuning and Optimization
5User Management and Security
- Creating and Managing User Accounts
- Implementing Roles and Privileges
- Database Auditing and Compliance
6Disaster Recovery Solutions
- Implementing Oracle Data Guard
- Configuring Standby Databases
- Failover and Switchover Procedures
7Automation and Scripting
- Using Oracle Scheduler
- Creating and Managing Job Schedules
- Automating Routine Maintenance Tasks
8Patching and Upgrading
- Understanding Oracle Patch Management
- Upgrading to Oracle Database 19c
- Post-Upgrade Considerations
Prerequisites
No prior experience required.
Who should attend
This course is designed for database administrators and IT professionals seeking to enhance their skills in Oracle Database management.
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 format of the course?
The course is delivered live online with interactive sessions.
How long is the course?
The course typically spans over 5 days with daily sessions.
Will I receive a certificate after completing the course?
Yes, you will receive an Skilvi course-completion certificate.
Are exam vouchers included with the course?
Exam vouchers are available through authorized channels on request.
Is there any prerequisite knowledge required?
No prior experience 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.