Oracle Autonomous Database Professional Workshop

Course details

In this course, deep dive into Oracle Cloud Infrastructure (OCI) terminology and focus on four main ideas:
Core Infrastructure
Database
Solutions, Platform and Edge
Governance and Administration

Use lesson slides, corresponding videos and demonstrations, hands-on labs, and exams to build your understanding. Learn how to use the features, workflows, and architecture of an Autonomous Database, as well as how to develop an Autonomous Database. This course helps you prepare for the Oracle Autonomous Database Certified Professional exam.

Concepts

0. Introduction

01 - Module intro

1. Getting Started with Oracle Autonomous Database

02 - Autonomous Database architecture and integration
03 - Different Autonomous Database offerings
04 - Different Autonomous Database offerings and license types
05 - Understanding the OCI infrastructure

2. Autonomous Database Serverless

06 - Module intro
07 - Autonomous Database serverless instances - Autoscaling
08 - Autonomous Database serverless instances - Provision ADB
09 - Autonomous Database serverless instances - Start and stop ADB
10 - Managing users
11 - Database consolidation with elastic resource pools
12 - Using cloning
13 - Moving Autonomous Database
14 - Monitoring Autonomous Database instances - Events and alarms
15 - Managing Autonomous Database backups and restores
16 - Data Guard

3. Autonomous Database Dedicated

17 - Module intro
18 - ADB dedicated and ADB Cloud@Customer - Dedicated infrastructure
19 - ADB dedicated and ADB Cloud@Customer - Workflows and functionality
20 - Provisioning dedicated resources
21 - Creating OCI policies for Autonomous Dedicated
22 - Monitoring dedicated infrastructure
23 - Manage maintenance scheduling (patching)

4. Managing and Monitoring Autonomous Database

24 - Module intro
25 - Autonomous Database instances - Using REST APIs to manage ADB
26 - Autonomous Database instances - Using OCI CLI to manage ADB
27 - Autonomous Database instances - Patching, upgrades, and services
28 - Using access control lists (ACLs) and private endpoints
29 - Managing encryption keys
30 - Monitoring ADB performance
31 - Setting up service notifications
32 - Using services in ADB - Automatic indexing
33 - Using services in ADB - Data Safe
34 - Using services in ADB - Compartment quotas
35 - Using ADB connectivity - Autonomous Database connectivity
36 - Connecting to ADB
37 - Using ADB connectivity - Connect to ADB
38 - Using ADB connectivity - Encryption, credentials, and wallet
39 - Configuring disaster recovery (Autonomous Data Guard)

5. Autonomous Database Tools

40 - Module intro
41 - Autonomous Database tools
42 - Using Autonomous Database with Oracle APEX
43 - Using Autonomous Database with Oracle Machine Learning

6. Developing on Autonomous Database

44 - Module intro
45 - GenAI for applications with natural language queries
46 - Using Autonomous JSON Database
47 - Using Oracle Text
48 - Incorporating location-based analysis - Spatial Studio
49 - Using Graph Studio - Using a graph
50 - Using Graph Studio - Create a graph, query, analyze, and visualize
51 - Exploring data lake analytics with Autonomous Database
52 - Using data sharing in Autonomous Database

7. Migrate to Autonomous

53 - Module intro
54 - Options and considerations for migrating to Autonomous Database
55 - Migrate to Autonomous Database using Data Pump

Conclusion

56 - Prepare for certification, part 1
57 - Prepare for certification, part 2
58 - Prepare for certification, part 3