OCI Database Specialist

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).