Oracle Database 19c: Administration Workshop
Build the core skills of an Oracle Database 19c administrator.
About this course
Build the core skills of an Oracle Database 19c administrator. Over five days you will explore the instance and storage architecture, install the software and create databases, provision DBCS instances on Oracle Cloud Infrastructure, manage users, privileges and auditing, back up and recover with RMAN, move data with Data Pump and SQL*Loader, and monitor performance through AWR and Enterprise Manager.
What you'll learn
- Understand Oracle Database and DBCS architecture
- Install, configure, and deploy Oracle 19c environments
- Manage users, security settings, and auditing policies
- Perform backup and recovery operations using RMAN
- Monitor performance and move data across systems efficiently
Curriculum
- Explore memory, process structures, logical storage, schema objects, and instance architecture
- Overview of Oracle Cloud Infrastructure (OCI)
- Provision and manage DBCS instances
- Install software using OUI
- Configure initialization parameters
- Create and configure databases
- Manage users, roles, and privileges
- Implement profiles and password policies
- Configure auditing settings and review logs
- Understand backup strategies
- Use RMAN for full and incremental backups
- Perform database recovery
- Use Data Pump for import/export
- Move data with SQL*Loader
- Implement transportable tablespaces
- Monitor with AWR and Enterprise Manager
- Identify performance issues
- Tune SQL and manage memory
- Manage schema objects
- Support application performance needs
- Maintain high availability
Who it's for
New and aspiring Oracle DBAs, and developers fluent in SQL and PL/SQL who will look after 19c databases.
Before you start
- Familiarity with relational database design and concepts
- Familiarity with Oracle SQL and Oracle PL/SQL
Related courses
More in Oracle Database →Oracle Database 19c: Backup and Recovery
Oracle Database
View course →Oracle Database 19c: Data Guard Administration Workshop
Oracle Database
View course →Oracle Database 19c: Multitenant Architecture
Oracle Database
View course →Oracle Access Management 12c: Administration Essentials
Oracle Database
View course →Oracle Database 19c: Advanced PL/SQL
Oracle Database
View course →Oracle Database 19c: New Features for Administrators
Oracle Database
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.