Oracle Autonomous Database Professional

Instructors: Angela Wall

Access provided by Kalinga Institute of Industrial Technology

6,585 already enrolled

4 modules

Gain insight into a topic and learn the fundamentals.

40 reviews

Intermediate level

Some related experience required

9 hours to complete

Flexible schedule

Learn at your own pace

4 modules

Gain insight into a topic and learn the fundamentals.

40 reviews

Intermediate level

Some related experience required

9 hours to complete

Flexible schedule

Learn at your own pace

What you'll learn

Architecture of Oracle Autonomous Database
Manage, maintain and monitor an Autonomous Database
Oracle Machine Learning, APEX, and SQL Developer Web
Autonomous JSON, Oracle Text, Spatial

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

10 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

There are 4 modules in this course

Welcome to the course Oracle Autonomous Database Administration. This course helps DBAs to deploy and administer Autonomous databases, and prepares them for the Oracle Autonomous Database Cloud Specialist Certification.

In this module we introduce you to the core concepts of Autonomous Database and the different ways to provision an ADB

What's included

23 videos4 assignments

23 videos Total 132 minutes

Module Intro 1 minute
Describe Autonomous Database Architecture and Integration 8 minutes
Describe the Different Autonomous Database offerings 10 minutes
Describe the Different Autonomous Database license types 7 minutes
Understanding the OCI Infrastructure 6 minutes
Module Intro 1 minute
Create Autonomous Database Serverless Instances - Auto Scaling 5 minutes
Create Autonomous Database Serverless Instances - Provision ADB 9 minutes
Create Autonomous Database Serverless Instances - Start and Stop ADB 5 minutes
Manage Users 6 minutes
Understand Database Consolidation with Elastic Resource Pools 5 minutes
Use Cloning 2 minutes
Move Autonomous Database 4 minutes
Monitor Autonomous Database Instances - events and alarms 6 minutes
Manage Autonomous Database Instances - backups and restores 9 minutes
Describe Data Guard 6 minutes
Module Intro 0 minutes
Describe ADB Dedicated and ADB Cloud@Customer - Dedicated Infrastructure 15 minutes
Describe ADB Dedicated and ADB Cloud@Customer - Workflows AND Functionality 5 minutes
Provisioning Dedicated Resources 9 minutes
Creating OCI Policies for Autonomous Dedicated 9 minutes
Monitor Dedicated Infrastructure 3 minutes
Manage Maintenance Scheduling (Patching) 4 minutes

4 assignments Total 75 minutes

Graded Assessment 30 minutes
Getting Started with Autonomous Database 15 minutes
Autonomous Database Serverless 15 minutes
Autonomous Database Dedicated 15 minutes

In this module we will show you how to manage and monitor an autonomous database. We will cover concepts of auto scaling, automatic indexing, and show how you can connect to an autonomous database from SQL developer. In this module you will also learn to configure an Autonomous Data Guard for disaster recovery.

What's included

16 videos2 assignments

16 videos Total 91 minutes

Module Intro 1 minute
Manage Autonomous Database Instances: Using REST APIs to manage ADB 4 minutes
Manage Autonomous Database instances: using OCI CLI to Manage ADB 4 minutes
Manage Autonomous Database Instances: Patching, Upgrades, and Services 6 minutes
Use Access Control List (ACL) and Private End Points 8 minutes
Manage Encryption Keys 4 minutes
Monitor ADB Performance 3 minutes
Set up service notifications 4 minutes
Use services in ADB: Auto Indexing 7 minutes
Use services in ADB: Data Safe 8 minutes
Use services in ADB: Compartment Quotas 9 minutes
Use ADB Connectivity - Autonomous Database Connectivity 10 minutes
Connecting to ADB 6 minutes
Use ADB Connectivity - Connect to ADB 6 minutes
Use ADB Connectivity - Encryption, Credentials and Wallet 5 minutes
Configure Disaster Recovery (Autonomous Data Guard) 7 minutes

2 assignments Total 45 minutes

Assessment 2 30 minutes
Managing and Monitoring Autonomous Database 15 minutes

In this module you will learn how to create applications on Autonomous Database using SQL, APEX, and Oracle Machine Learning. You will also learn to make use of Spatial Studio, and Graph Studio. This module also covers how to migrate data to an Autonomous Database

What's included

16 videos4 assignments

16 videos Total 104 minutes

Module Intro 1 minute
Describe Autonomous Database Tools 4 minutes
Use Autonomous Database with Oracle APEX 5 minutes
Use Autonomous Database with Oracle Machine Learning 5 minutes
Module Intro 1 minute
Developing New and Extending Existing Applications with Natural Language Queries with Generative AI 9 minutes
Use Autonomous JSON Database 13 minutes
Use Oracle Text 12 minutes
Incorporate Location-based analysis (Autonomous Spatial) 8 minutes
Use Autonomous Graph - Using Graph 5 minutes
Use Autonomous Graph - Create graph, Query, Analyze, Visualize 8 minutes
Explore Data Lake Analytics with Autonomous Database 6 minutes
Use Data Sharing in Autonomous Database 5 minutes
Module Intro 1 minute
Describe the options and considerations for migrating to Autonomous Database 12 minutes
Migrate to Autonomous Database using Data Pump 9 minutes

4 assignments Total 75 minutes

Graded Assessment 30 minutes
Autonomous Database Tools 15 minutes
Developing on Autonomous Database 15 minutes
Migration 15 minutes

This module prepares you for the Oracle Autonomous Database Cloud Professional Exam by reviewing key exam topics, providing sample questions, and sharing test-taking strategies.