Oracle Autonomous Database Professional Workshop

Instructors: Roy Swonger

Sponsored by Abu Dhabi National Oil Company

5,644 already enrolled

4 modules

Gain insight into a topic and learn the fundamentals.

4.6

(39 reviews)

Intermediate level

Some related experience required

7 hours to complete

3 weeks at 2 hours a week

Flexible schedule

Learn at your own pace

4 modules

Gain insight into a topic and learn the fundamentals.

4.6

(39 reviews)

Intermediate level

Some related experience required

7 hours to complete

3 weeks at 2 hours a week

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

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

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

There are 4 modules in this course

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

What's included

22 videos4 assignments

22 videosTotal 111 minutes

Module Intro0 minutesPreview module
Architectural Components and Key Features8 minutes
Describe the Different Autonomous Database offerings9 minutes
Describe the Different Autonomous Database license types6 minutes
Understanding the OCI Infrastructure6 minutes
Module Intro0 minutes
Create Autonomous Database Serverless Instances - Auto Scaling4 minutes
Create Autonomous Database Serverless Instances - Provision ADB8 minutes
Create Autonomous Database Serverless Instances - Start and Stop ADB4 minutes
Manage Users5 minutes
Understand Database Consolidation with Elastic Resource Pools4 minutes
Use Cloning1 minute
Move Autonomous Database3 minutes
Monitor Autonomous Database Instances - events and alarms6 minutes
Manage Autonomous Database Instances - backups and restores6 minutes
Describe Data Guard5 minutes
Describe ADB Dedicated and ADB Cloud@Customer - Dedicated Infrastructure8 minutes
Describe ADB Dedicated and ADB Cloud@Customer - Workflows AND Functionality3 minutes
Provisioning Dedicated Resources6 minutes
Creating OCI Policies for Autonomous Dedicated5 minutes
Monitor Dedicated Infrastructure1 minute
Manage Maintenance Scheduling (Patching)2 minutes

4 assignmentsTotal 55 minutes

Getting Started with Autonomous Database15 minutes
Autonomous Database Serverless10 minutes
Autonomous Database Dedicated15 minutes
Assessment 115 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

15 videos2 assignments

15 videosTotal 83 minutes

Module Intro0 minutesPreview module
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 Services5 minutes
Use Access Control List (ACL) and Private End Points7 minutes
Manage Encryption Keys3 minutes
Monitor ADB Performance2 minutes
Set up service notifications3 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 Connectivity9 minutes
Use ADB Connectivity - Connect to ADB5 minutes
Use ADB Connectivity - Encryption, Credentials and Wallet4 minutes
Configure Disaster Recovery (Autonomous Data Guard)4 minutes

2 assignmentsTotal 30 minutes

Managing and Monitoring Autonomous Database15 minutes
Assessment 215 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 Studion. This module also covers how to migrate data to an Autonomous Database.

What's included

21 videos4 assignments

21 videosTotal 131 minutes

Module Intro0 minutesPreview module
Describe Autonomous Database Tools4 minutes
Use Autonomous Database with Oracle APEX4 minutes
Use Autonomous Database with Oracle SQL Developer Web (Database actions)2 minutes
Use Autonomous Database with Oracle Machine Learning5 minutes
Create Business Model12 minutes
Apply Data Insights7 minutes
Explain Data Analysis4 minutes
Module Intro0 minutes
Developing New and Extending Existing Applications with Natural Language Queries with Generative AI8 minutes
Use Autonomous JSON Database12 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
Use Autonomous Graph - Using Graph Studio1 minute
Explore Data Lake Analytics with Autonomous Database6 minutes
Use Data Sharing in Autonomous Database4 minutes
Module Intro0 minutes
Describe the options and considerations for migrating to Autonomous Database12 minutes
Migrate to Autonomous Database using Data Pump8 minutes

4 assignmentsTotal 45 minutes

Autonomous Database Tools10 minutes
Developing on Autonomous Database10 minutes
Migration10 minutes
Assessment 315 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.

What's included

3 videos

Instructors

Instructor ratings

4.8 (14 ratings)

Roy Swonger

Oracle

1 Course5,644 learners

Offered by

Oracle

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

4.6

39 reviews

5 stars
71.79%
4 stars
23.07%
3 stars
2.56%
2 stars
0%
1 star
2.56%

Showing 3 of 39

Reviewed on Dec 4, 2021

make it alittle more simpler and make the quiz alittle bit more challengeing

Reviewed on May 14, 2022

This course is good but some lectures were way too fast to understand

Reviewed on Dec 27, 2021

I could not create an ADB for some reason. However I last used Oracle DB at version 11 as a senior DBA. This product is spectacular and I really enjoyed the content.

View more reviews