OCI Database Services Professional study plan
OCI Database Services Professional · Give each week a clear focus.
8 weeks · About 6 hours per week
Oracle Cloud Infrastructure Database Services
Map every OCI Database Services offering to its use case, comparing Autonomous Database, Base Database Service, Exadata Database Service, and Database Autonomous Recovery Service
Explain the shared-responsibility split between Oracle and the customer for each database deployment model
Identify the identity, compartment, and IAM policy constructs that gate database resource creation
Sketch a reference architecture placing a database in a VCN with private subnets, a service gateway, and a bastion host
Your checkpoint
A one-page comparison matrix of all OCI database service families with at least four decision criteria per row, plus a hand-drawn reference architecture diagram
Oracle Cloud Infrastructure Database Services
Provision an Autonomous Database instance in a private subnet and connect to it from a compute host using a wallet
Configure network access control lists, security lists, and database access control entries to restrict client access
Enable and validate automatic backups, then perform a point-in-time restore into a new instance
Scale an Autonomous Database's compute and storage independently and record the effect on billing units
Your checkpoint
A lab log documenting private-endpoint provisioning, wallet-based connection, a successful restore, and a scaling test with before/after metrics
Oracle Cloud Infrastructure Database Services
Create a Base Database Service DB system with a two-node RAC configuration and verify node-level connectivity
Configure Data Guard between a primary and standby database and measure switchover and failover behavior
Apply a database patch using the OCI console and confirm the patching history reflects the change
Compare cost and operational effort between Base Database Service and Exadata Database Service for a given workload
Your checkpoint
A written decision memo recommending one deployment model for an OLTP workload, supported by measured failover time and cost estimates
Oracle Cloud Infrastructure Database Services
Trace a database connection path through VCN routing, security rules, and the database listener to diagnose a simulated failure
Configure and test Database Autonomous Recovery Service as a backup destination for a Base Database instance
Automate database provisioning with a Terraform configuration and re-run it to prove idempotency
Write IAM policies that grant a group the least privilege needed to manage databases but not delete them
Your checkpoint
A working Terraform module that provisions a database with backups and IAM policies, plus a troubleshooting write-up of one deliberately broken network path
Oracle Cloud Infrastructure Database Services
Tune an Autonomous Database workload using automatic indexing and SQL tuning insights, capturing before/after execution plans
Configure a Data Guard association for Autonomous Database and verify the standby's role during a switchover
Set up performance hub monitoring and export a report covering a 24-hour observation window
Diagnose and resolve a storage-limit or connection-pool exhaustion scenario
Your checkpoint
A performance tuning report with three identified bottlenecks, the remediation applied to each, and measured improvement in response time
Oracle Cloud Infrastructure Database Services
Migrate a sample schema to Autonomous Database using Data Pump and validate row counts and object parity
Migrate an on-premises database to Base Database Service with Zero Downtime Migration concepts and document prerequisites
Evaluate migration tooling choices against downtime tolerance and data volume constraints
Verify migrated objects, privileges, and scheduled jobs after cutover
Your checkpoint
A migration runbook covering pre-checks, execution steps, validation queries, and rollback, applied successfully to one sample schema
Oracle Cloud Infrastructure Database Services
Build a monitoring setup using OCI Monitoring metrics and alarms for database CPU, storage, and availability
Configure audit logging and export audit records to Object Storage for retention
Encrypt a database with customer-managed keys from OCI Vault and rotate the key
Design a disaster-recovery drill and record recovery time and recovery point outcomes
Your checkpoint
An operations runbook with alarm definitions, an audit export configuration, and a completed DR drill record stating achieved RTO and RPO
Oracle Cloud Infrastructure Database Services
Complete a timed practice assessment and score each missed item by sub-topic
Re-review the three weakest sub-topics with hands-on reinforcement rather than reading
Explain aloud the trade-offs among all database deployment models without notes
Consolidate lab notes into a single searchable reference for exam-day review
Your checkpoint
A scored practice exam result with a remediation log showing each weak area retested and passed
Milestones
Week 2: Provision, connect to, back up, and restore an Autonomous Database end to end without consulting documentation
Week 4: Explain and demonstrate the full network, IAM, and backup path for a database deployment, and show a working Terraform module
Week 6: Complete one schema migration with validated object parity and a documented rollback path
Week 8: Score at least 80 percent on a timed practice assessment and close every identified gap with a retest