OCI Database Specialist
Deploy and manage Autonomous Database, Oracle Base Database, and MySQL HeatWave on Oracle Cloud
Become an expert in Oracle Cloud database services with this advanced course. You'll master Autonomous Database, Oracle Base Database Service, and MySQL HeatWave, learning to deploy, manage, optimize, and migrate database workloads on OCI.
Course Overview
This 40-hour course provides deep expertise in OCI's database offerings. From fully managed Autonomous Database to self-managed Oracle databases and MySQL HeatWave, you'll learn to select, deploy, and manage the right database solution for any workload.
What You'll Learn
- Deploy and manage Autonomous Database (ATP, ADW, AJD)
- Configure Oracle Base Database Service on VMs and bare metal
- Implement high availability with Data Guard and RAC
- Deploy MySQL HeatWave for analytics workloads
- Plan and execute database migrations to OCI
- Optimize database performance and costs
- Implement backup, recovery, and disaster recovery strategies
Who Should Attend
- Database administrators managing OCI databases
- Cloud architects designing database solutions
- DBAs migrating databases to Oracle Cloud
- Data engineers working with OCI data services
- Professionals preparing for OCI Database Specialist certification
Prerequisites
This is an advanced course. Strong database administration experience is essential.
- OCI Architect Associate certification or equivalent
- 2+ years Oracle database administration experience
- Understanding of database concepts (SQL, backup/recovery, HA)
- Familiarity with Linux command line
- Basic networking knowledge
Curriculum
Module 1: OCI Database Services Overview
Understand OCI's database portfolio and selection criteria.
Topics covered:
- OCI database services comparison
- Use case mapping and decision frameworks
- Licensing options (BYOL vs. License Included)
- Cost modeling for database workloads
- Database cloud migration considerations
Duration: 3 hours
Module 2: Autonomous Database Fundamentals
Master Autonomous Database deployment and core features.
Topics covered:
- Autonomous Database architecture
- ATP vs. ADW vs. AJD selection
- Provisioning and configuration
- Workload types and optimization
- Auto-scaling and performance
- Autonomous Database on Dedicated Exadata
Duration: 5 hours
Module 3: Autonomous Database Administration
Perform day-to-day administration of Autonomous Database.
Topics covered:
- User and role management
- Connection methods and wallet management
- Monitoring and diagnostics
- APEX integration
- Database Actions and tools
- REST APIs for automation
- Oracle Machine Learning
Duration: 5 hours
Module 4: Autonomous Database Security and Compliance
Implement security controls for Autonomous Database.
Topics covered:
- Private endpoints and network security
- Data encryption and key management
- Database Vault and privileged user controls
- Data Safe integration
- Audit logging and compliance
- Data masking and redaction
Duration: 4 hours
Module 5: Oracle Base Database Service
Deploy and manage Oracle databases on OCI infrastructure.
Topics covered:
- DB system deployment options
- VM vs. bare metal selection
- Database software and version management
- Storage configuration and performance
- Patching and maintenance
- Custom images and templates
Duration: 5 hours
Module 6: High Availability and Data Guard
Implement high availability for Oracle databases on OCI.
Topics covered:
- RAC on OCI deployment
- Data Guard configuration and management
- Active Data Guard features
- Automatic failover configuration
- Switchover and failover operations
- Cross-region Data Guard
Duration: 5 hours
Module 7: MySQL HeatWave
Deploy MySQL HeatWave for transactional and analytics workloads.
Topics covered:
- MySQL HeatWave architecture
- HeatWave cluster deployment
- Query acceleration with HeatWave
- HeatWave AutoML
- High availability configuration
- MySQL replication on OCI
- Performance tuning
Duration: 4 hours
Module 8: Database Migration to OCI
Plan and execute database migrations to OCI.
Topics covered:
- Migration assessment and planning
- Oracle Zero Downtime Migration (ZDM)
- Data Pump and RMAN migration
- GoldenGate for continuous replication
- Cross-platform migration
- Application migration considerations
- Testing and validation
Duration: 4 hours
Module 9: Backup, Recovery, and DR
Implement backup and disaster recovery for OCI databases.
Topics covered:
- Automatic backup configuration
- RMAN backup strategies
- Point-in-time recovery
- Cross-region backup replication
- Full Stack DR for databases
- Disaster recovery testing
- Compliance and retention policies
Duration: 3 hours
Module 10: Performance Tuning and Exam Prep
Optimize database performance and prepare for certification.
Topics covered:
- Performance monitoring and diagnostics
- AWR and performance reports
- Query optimization
- Resource management
- Exam format and objectives
- Practice scenarios
Duration: 2 hours
Hands-On Labs
Labs provide hands-on experience with all OCI database services. You'll work with real database instances and data sets.
Lab 1: Autonomous Database Deployment
Provision and configure Autonomous Database instances.
Objectives:
- Create ATP and ADW instances
- Configure auto-scaling settings
- Set up database tools and connections
- Load sample data and run queries
- Monitor performance metrics
Lab 2: Autonomous Database Security
Implement comprehensive security for Autonomous Database.
Objectives:
- Configure private endpoint access
- Set up customer-managed encryption keys
- Implement Database Vault
- Configure Data Safe assessments
- Set up audit logging
Lab 3: Oracle Base Database Deployment
Deploy Oracle database on VM infrastructure.
Objectives:
- Create DB system with appropriate shape
- Configure storage and networking
- Connect using SQL Developer
- Perform basic administration tasks
- Apply database patches
Lab 4: Data Guard Implementation
Configure high availability with Data Guard.
Objectives:
- Create primary database system
- Provision standby database
- Configure Data Guard association
- Perform switchover operation
- Test failover scenarios
Lab 5: MySQL HeatWave Deployment
Deploy and query MySQL HeatWave.
Objectives:
- Create MySQL HeatWave cluster
- Load data into HeatWave
- Run analytics queries
- Compare query performance
- Configure high availability
Lab 6: Database Migration
Migrate a database to OCI using Zero Downtime Migration.
Objectives:
- Assess source database
- Configure ZDM environment
- Perform migration with minimal downtime
- Validate migrated database
- Complete cutover process
Lab 7: Backup and Recovery
Implement backup and recovery strategies.
Objectives:
- Configure automatic backups
- Perform manual backups
- Execute point-in-time recovery
- Set up cross-region backup
- Create disaster recovery plan
Certification Preparation
This course prepares you for the Oracle Cloud Infrastructure Database Specialist certification.
Exam Details
| Attribute | Details |
|---|---|
| Exam Code | 1Z0-1093 |
| Format | Multiple choice and multiple select |
| Number of Questions | 55 |
| Passing Score | 65% |
| Duration | 105 minutes |
| Cost | Free |
Oracle offers this certification exam for free. Demonstrate your database expertise without exam costs.
Exam Topics
The exam covers the following domains:
- Autonomous Database (25-30%)
- Oracle Base Database Service (20-25%)
- High Availability and DR (15-20%)
- Database Migration (15-20%)
- MySQL HeatWave (10-15%)
- Security and Compliance (10-15%)
Training Options
| Format | Duration | Features | Price |
|---|---|---|---|
| Self-Paced Online | 40 hours | On-demand videos, lifetime access | $899 |
| Live Virtual | 5 days | Interactive sessions, DBA experts | $1,799 |
| Corporate On-Site | 5 days | Customized content, team training | Contact us |
| Bootcamp Intensive | 5 days | Immersive, lab-focused | $1,999 |
What's Included
- Comprehensive video lessons with demos
- 7 hands-on labs with real databases
- SQL scripts and configuration examples
- Architecture reference diagrams
- Practice exam questions (200+ questions)
- Certificate of completion
- 60-day instructor support
- Access to database community forums
Next Steps
Ready to master OCI database services? [Contact us](/contact-sales) to discuss enrollment options.
Complement your database expertise with:
- [OCI Architect Professional](/docs/trainings/oracle-cloud/architect-professional) - Enterprise architecture
- [OCI Security Specialist](/docs/trainings/oracle-cloud/security-specialist) - Database security deep dive
- [OCI DevOps Professional](/docs/trainings/oracle-cloud/devops-professional) - Automate database deployments
Browse all [Oracle Cloud training programs](/docs/trainings/oracle-cloud) or explore our complete [training catalog](/docs/trainings).
Prerequisites
- OCI Architect Associate certification or equivalent
- 1+ years database administration experience
- Familiarity with Oracle Database or MySQL
Ready to get started?
Request a training quote for your team — in-person, live-online, or hybrid.