Oracle Autonomous Database Cert Prep: Cloud Specialist (1Z0-931-21)

1. Getting Started with Autonomous Database

• Welcome: Getting started with Autonomous Database
• Getting started with Autonomous Database
• Autonomous Database offerings type
• Autonomous Database license type

2. Oracle Cloud Free Tier Account

• Demo: Oracle Cloud Free Tier sign-up
• Demo: OCI console walk-through
• Demo: Setting up your tenancy
• Demo: MFA and budget setup

3. Fundamentals of Oracle Database

• Database architecture
• Database instance and memory structures
• Multitenant architecture
• Physical and logical structures and database objects
• Backup and recovery concepts
• Flashback
• Security

4. Autonomous Database on Shared Infrastructure

• Welcome: Autonomous Database on shared infrastructure
• Provisioning
• Start and stop ADB
• Scaling
• Auto scaling
• Move ADB to another compartment
• Create an ADB clone
• Managing Users
• Create alarms and events
• Manage ADB backup and restores
• Autonomous Data Guard
• Demo: Provisioning
• Demo: Start and stop ADB
• Demo: Scaling
• Demo: Move ADB to another compartment
• Demo: Create an ADB clone
• Demo: Backup and recovery
• Demo: Create events and alarms

5. Autonomous Database on Dedicated Infrastructure

• Welcome: Autonomous Database on dedicated infrastructure
• Dedicated infrastructure overview
• Describe workflows and functionality
• Provision dedicated resources: Exadata, container database, and VM cluster
• Monitoring dedicated infrastructure
• Creating OCI policies for Autonomous Dedicated
• Manage maintenance scheduling (patching)
• Managing encryption keys

6. Managing and Monitoring Autonomous Database

• Welcome: Managing and monitoring Autonomous Database
• Using REST APIs to manage ADB
• Manage ADB using OCI CLI
• Patching and upgrades
• Setting up ACLs and private end points
• Monitor Autonomous Database performance
• Set up service notifications
• Monitor auto scaling
• Monitor auto indexing
• Using Data Safe
• Compartment quotas
• ADB connectivity
• Managing the Database Wallet
• Database service names, wallet types, and connectivity options
• Connect to ADB using SQL developer and database actions
• Use Marketplace developer image to connect to Autonomous Database
• Configure disaster recovery (Autonomous Data Guard)
• Demo: Connect to ADB
• Demo: Monitor auto scaling
• Demo: Configure disaster recovery (Autonomous Data Guard)

7. Autonomous Database Tools

• Welcome: Autonomous Database tools
• Database actions
• APEX
• Oracle Machine Learning
• Data analysis
• Data transforms
• Business model
• Data insights and catalog
• Demo: SQL developer
• Demo: APEX
• Demo: Oracle Machine Learning

8. Developing on Autonomous Database

• Welcome: Developing on Autonomous Database
• Use Oracle Autonomous JSON database terms and concepts
• Using Autonomous JSON database
• Use Oracle Text
• Spatial on Oracle Autonomous Database
• Using Spatial Studio
• Using Graph in Oracle Autonomous Database overview
• Create and query graph
• Graph studio
• Integrating object storage data with Autonomous Database
• Demo: Use Oracle Autonomous JSON database

9. Migration

• Welcome: Migration
• Migration options and considerations
• Migrating to Autonomous Database