Oracle Autonomous Database Professional study plan
Oracle Autonomous Database Professional · Give each week a clear focus.
8 weeks · About 6 hours per week
Autonomous Database Fundamentals
Describe the architecture of Autonomous Database, including the separation of compute and storage, and the roles of the control plane and data plane.
Explain the difference between Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP) workloads, and list at least three use cases for each.
Identify the key features of Autonomous Database such as auto-scaling, auto-repair, auto-tuning, and automatic backups, and state how each reduces administrative effort.
Define the shared responsibility model for Autonomous Database and list the security controls managed by Oracle versus the customer.
Your checkpoint
Create a one-page comparison table of ADW vs. ATP that includes workload type, typical use cases, and default configurations, plus a short paragraph explaining the shared responsibility model.
Autonomous Database Fundamentals
Explain the purpose of the different Autonomous Database service levels (e.g., low, medium, high) and how they affect concurrency and resource allocation.
Describe the backup and restore capabilities, including automatic backups, retention periods, and point-in-time recovery.
Outline the process of scaling compute and storage resources, both manually and automatically, and the implications for billing.
Summarize the supported tools and interfaces for connecting to Autonomous Database (SQL Developer, SQLcl, OCI Console, APIs) and their typical use cases.
Your checkpoint
Write a 300-word summary explaining how service levels and auto-scaling interact, and include a diagram of the backup and restore workflow.
Provisioning and Connecting to Autonomous Databases
Provision an Autonomous Database instance using the OCI Console, specifying the workload type, compute and storage, and administrator credentials.
Configure network access by setting up access control lists (ACLs) and private endpoints, and explain when to use each.
Connect to the provisioned database using SQL Developer and SQLcl, using both wallet-based and IAM-based authentication.
Download and configure the client credentials (wallet) and explain the contents of the wallet files.
Your checkpoint
Provision a free-tier Autonomous Database, connect via SQL Developer and SQLcl, and submit screenshots of the connection configuration and a successful query.
Provisioning and Connecting to Autonomous Databases
Create and manage database users, roles, and privileges in Autonomous Database, including the ADMIN user and predefined roles.
Enable and configure Oracle REST Data Services (ORDS) for an Autonomous Database and test a REST endpoint.
Describe the process of scaling an Autonomous Database and the impact on existing connections and performance.
Explain the licensing models (License Included vs. Bring Your Own License) and calculate the cost implications for a given scenario.
Your checkpoint
Create a new database user with specific privileges, enable ORDS, and provide a working REST endpoint URL that returns data from a sample table, along with a cost estimate for scaling the database.
Managing and Monitoring Autonomous Databases
Use the OCI Console to monitor database performance metrics such as CPU utilization, storage usage, and active sessions.
Configure and interpret Automatic Workload Repository (AWR) reports and Automatic Database Diagnostic Monitor (ADDM) findings.
Set up alerts and notifications for critical database events using OCI Monitoring and Notifications.
Describe the process of patching and upgrading Autonomous Database and how it is automated.
Your checkpoint
Generate an AWR report for a workload, identify the top wait events, and create an alert rule that triggers when CPU utilization exceeds 80% for 5 minutes.
Managing and Monitoring Autonomous Databases
Perform a manual backup and restore an Autonomous Database to a previous point in time using the OCI Console or API.
Use Data Safe to assess security risks and implement recommendations for an Autonomous Database.
Monitor and manage storage usage, including identifying large objects and purging unnecessary data.
Describe the process of cloning an Autonomous Database and the use cases for cloning.
Your checkpoint
Create a clone of an existing Autonomous Database, restore it to a point in time before a simulated data corruption, and verify data integrity with a query.
Migrating and Loading Data into Autonomous Databases
Use Oracle Data Pump to export data from an on-premises database and import it into Autonomous Database, including the required directory objects and credentials.
Load data from cloud storage (OCI Object Storage) using the DBMS_CLOUD package, and handle various file formats (CSV, JSON, Parquet).
Configure and use Oracle GoldenGate to replicate data from an on-premises database to Autonomous Database in real time.
Use SQL Developer Data Import wizard to load data from a local file into Autonomous Database.
Your checkpoint
Export a sample schema from a local Oracle Database using Data Pump, import it into Autonomous Database, and load a CSV file from Object Storage using DBMS_CLOUD, then verify row counts.
Migrating and Loading Data into Autonomous Databases & Autonomous Database Fundamentals
Use Oracle Zero Downtime Migration (ZDM) to migrate a database to Autonomous Database and validate the migration.
Compare and contrast migration methods (Data Pump, GoldenGate, ZDM) in terms of downtime, complexity, and use cases.
Review key concepts from Domain 1 (fundamentals) and Domain 4 (migration) to reinforce understanding.
Complete a practice exam covering all domains and review incorrect answers to identify knowledge gaps.
Your checkpoint
Perform a migration of a sample database to Autonomous Database using ZDM, document the steps and outcomes, and score at least 80% on a practice exam covering all four domains.
Milestones
Week 2: Explain the Autonomous Database architecture and shared responsibility model without notes, and describe the backup and restore process.
Week 4: Successfully provision an Autonomous Database, connect using two different methods, create a user, and enable ORDS with a working REST endpoint.
Week 6: Monitor performance using AWR, set up an alert, and perform a point-in-time restore of a cloned database.
Week 8: Migrate a sample database using ZDM, compare migration methods, and achieve at least 80% on a comprehensive practice exam.