Oracle Autonomous Database Professional

Instructors: Angela Wall

Access provided by Echo Refugee Library

6,632 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 videosTotal 132 minutes

Module Intro1 minute
Describe Autonomous Database Architecture and Integration8 minutes
Describe the Different Autonomous Database offerings10 minutes
Describe the Different Autonomous Database license types7 minutes
Understanding the OCI Infrastructure6 minutes
Module Intro1 minute
Create Autonomous Database Serverless Instances - Auto Scaling5 minutes
Create Autonomous Database Serverless Instances - Provision ADB9 minutes
Create Autonomous Database Serverless Instances - Start and Stop ADB5 minutes
Manage Users6 minutes
Understand Database Consolidation with Elastic Resource Pools5 minutes
Use Cloning2 minutes
Move Autonomous Database4 minutes
Monitor Autonomous Database Instances - events and alarms6 minutes
Manage Autonomous Database Instances - backups and restores9 minutes
Describe Data Guard6 minutes
Module Intro0 minutes
Describe ADB Dedicated and ADB Cloud@Customer - Dedicated Infrastructure15 minutes
Describe ADB Dedicated and ADB Cloud@Customer - Workflows AND Functionality5 minutes
Provisioning Dedicated Resources9 minutes
Creating OCI Policies for Autonomous Dedicated9 minutes
Monitor Dedicated Infrastructure3 minutes
Manage Maintenance Scheduling (Patching)4 minutes

4 assignmentsTotal 75 minutes

Getting Started with Autonomous Database15 minutes
Autonomous Database Serverless15 minutes
Autonomous Database Dedicated15 minutes
Graded Assessment30 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 videosTotal 91 minutes

Module Intro1 minute
Manage Autonomous Database Instances: Using REST APIs to manage ADB4 minutes
Manage Autonomous Database instances: using OCI CLI to Manage ADB4 minutes
Manage Autonomous Database Instances: Patching, Upgrades, and Services6 minutes
Use Access Control List (ACL) and Private End Points8 minutes
Manage Encryption Keys4 minutes
Monitor ADB Performance3 minutes
Set up service notifications4 minutes
Use services in ADB: Auto Indexing7 minutes
Use services in ADB: Data Safe8 minutes
Use services in ADB: Compartment Quotas9 minutes
Use ADB Connectivity - Autonomous Database Connectivity10 minutes
Connecting to ADB6 minutes
Use ADB Connectivity - Connect to ADB6 minutes
Use ADB Connectivity - Encryption, Credentials and Wallet5 minutes
Configure Disaster Recovery (Autonomous Data Guard)7 minutes

2 assignmentsTotal 45 minutes

Managing and Monitoring Autonomous Database15 minutes
Assessment 230 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 videosTotal 104 minutes

Module Intro1 minute
Describe Autonomous Database Tools4 minutes
Use Autonomous Database with Oracle APEX5 minutes
Use Autonomous Database with Oracle Machine Learning5 minutes
Module Intro1 minute
Developing New and Extending Existing Applications with Natural Language Queries with Generative AI9 minutes
Use Autonomous JSON Database13 minutes
Use Oracle Text12 minutes
Incorporate Location-based analysis (Autonomous Spatial)8 minutes
Use Autonomous Graph - Using Graph5 minutes
Use Autonomous Graph - Create graph, Query, Analyze, Visualize8 minutes
Explore Data Lake Analytics with Autonomous Database6 minutes
Use Data Sharing in Autonomous Database5 minutes
Module Intro1 minute
Describe the options and considerations for migrating to Autonomous Database12 minutes
Migrate to Autonomous Database using Data Pump9 minutes

4 assignmentsTotal 75 minutes

Autonomous Database Tools15 minutes
Developing on Autonomous Database15 minutes
Migration15 minutes
Graded Assessment 30 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.