Oracle Data Platform Foundations Associate study plan
Oracle Data Platform Foundations Associate · Give each week a clear focus.
8 weeks · About 6 hours per week
Oracle Data Platform Foundations
Map the full Oracle data platform landscape by drawing a one-page diagram that places Autonomous Database, Exadata, Base Database Service, MySQL HeatWave, and Object Storage relative to each other
Define the terms OLTP, OLAP, data warehouse, data lake, and lakehouse in your own words and give one Oracle product example for each
List the Oracle Cloud Infrastructure regions, availability domains, and fault domains concepts and explain how they affect database deployment choices
Explain the shared responsibility model for Oracle Cloud database services and identify which tasks stay with the customer
Your checkpoint
A one-page platform map plus a 15-term glossary written from memory, with any gaps re-studied until the glossary is complete
Oracle Data Platform Foundations
Compare Autonomous Transaction Processing and Autonomous Data Warehouse by workload, tuning model, and typical use case
Describe the Autonomous Database lifecycle: provisioning, scaling, auto-scaling, stopping, cloning, and terminating
Explain the built-in autonomous features: automatic indexing, automatic statistics gathering, self-repair, and automatic patching
Differentiate dedicated vs shared Exadata infrastructure for Autonomous Database and state when each is appropriate
Your checkpoint
A two-column comparison sheet for ATP vs ADW covering at least 8 dimensions, plus 10 self-written practice questions on Autonomous Database that you answer correctly without notes
Oracle Data Platform Foundations
Describe Exadata hardware building blocks: database servers, storage servers, InfiniBand or RoCE fabric, and smart scan offload
Explain the difference between Exadata Database Service on Dedicated Infrastructure and on Cloud at Customer
Identify when a customer should choose Base Database Service instead of Exadata or Autonomous Database
Outline the migration paths into Oracle Cloud databases, including Zero Downtime Migration and Data Pump export/import
Your checkpoint
A decision tree that starts with a workload description and ends in a recommended Oracle database service, validated against at least 6 scenarios you write yourself
Oracle Data Platform Foundations
Explain Oracle Object Storage concepts: buckets, storage tiers, lifecycle policies, and pre-authenticated requests
Describe how Object Storage supports database workloads such as backups, Data Pump dumps, and external tables
Summarize Oracle Database backup and recovery options in the cloud, including automatic backups and point-in-time recovery
Identify the security controls for data at rest and in transit across database and storage services
Your checkpoint
A mid-plan checkpoint quiz of 25 original questions spanning weeks 1 to 4, scored at 80 percent or higher before moving on
Oracle Data Platform Foundations
Explain the role of MySQL HeatWave and how it differs from the Oracle Database family in workload and licensing
Describe Oracle GoldenGate use cases for replication and change data capture across the platform
Summarize Oracle Data Integration and Data Catalog capabilities for moving and governing data
Explain how analytics services such as Oracle Analytics Cloud consume data from the platform
Your checkpoint
A data-flow diagram showing ingestion, storage, processing, and analytics layers, each labeled with the Oracle service that fills it
Oracle Data Platform Foundations
Describe Oracle Cloud Infrastructure Identity and Access Management constructs: compartments, policies, groups, and dynamic groups
Explain how IAM policies govern access to database and storage resources and write two sample policy statements
Summarize Oracle Cloud cost management levers for data platform services, including bring-your-own-license and auto-scaling
Identify monitoring and observability touchpoints such as metrics, alarms, and audit logs
Your checkpoint
A one-page governance and cost summary that names at least 6 IAM or cost concepts and explains each in two sentences
Oracle Data Platform Foundations
Re-read your week 1 to 6 notes and convert every weak spot into a flashcard or practice question
Complete a timed 60-question mixed practice set covering the whole domain and log every wrong answer with the reason
Explain each wrong answer aloud in under 60 seconds to confirm real understanding
Revisit any service comparison or decision tree that you could not reproduce from memory
Your checkpoint
A scored 60-question practice run at 85 percent or better, plus a written error log with corrective notes for every miss
Oracle Data Platform Foundations
Recite the full platform map, service comparisons, and decision tree from memory without notes
Take two full-length timed practice exams and compare scores to identify any remaining trend
Review only the error log and flashcards in the final days rather than new material
Confirm exam logistics: format, duration, passing score, and allowed resources
Your checkpoint
Two timed practice exams completed with both scores at or above your target pass margin, and a final one-page cheat sheet written entirely from memory
Milestones
Week 2: You can explain the difference between ATP and ADW and name at least 4 autonomous features without notes
Week 4: You score 80 percent or higher on the 25-question checkpoint covering weeks 1 to 4
Week 6: You can draw the full data-flow diagram and state two IAM policies from memory
Week 8: Two timed practice exams both meet your target pass margin and the cheat sheet is complete