OpenCourser brand icon
Sign in
We may earn an affiliate commission when you visit our partners.
Course image
Course image
edX logo

Oracle Autonomous Database Administration Workshop

Kay Malcolm, Sean Stacey, Kamryn Vinson, Maria Colgan, Angela Wall, Henry Byorum, Patrick Wheeler, Killian Lynch, Kiana McDaniel, Mark Hornick, Sangeetha Kuppuswamy, Thea Lazarova, Bill Millar, and Michelle Malcher

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

This module will show you how to manage and monitor an autonomous database. This module 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.

Read more

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

This module will show you how to manage and monitor an autonomous database. This module 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.

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 you'll learn

  • Learn the technical architecture of Oracle Autonomous Database
  • Learn the tasks involved in creating an Autonomous Database on shared and dedicated Exadata infrastructure
  • Manage, maintain and monitor an Autonomous Database
  • Learn about Oracle Machine Learning, APEX, and SQL Developer Web, which gets deployed with Autonomous Database
  • Learn to use Autonomous JSON, Oracle Text, Spatial, and Graph
  • Identify Migration Options and Considerations
Enroll now

What's inside

Learning objectives

  • Learn the technical architecture of oracle autonomous database
  • Learn the tasks involved in creating an autonomous database on shared and dedicated exadata infrastructure
  • Manage, maintain and monitor an autonomous database
  • Learn about oracle machine learning, apex, and sql developer web, which gets deployed with autonomous database
  • Learn to use autonomous json, oracle text, spatial, and graph
  • Identify migration options and considerations

Traffic lights

Read about what's good
what should give you pause
and possible dealbreakers
Focuses on the architecture and purposes of Oracle Autonomous Database, including managing, maintaining, and monitoring it
Instructors are recognized for their work in Oracle Database technologies and applications
Provides instruction on multiple tools associated with Oracle Autonomous Database, including APEX, Machine Learning, SQL Developer Web, and Spatial
Covers important considerations for migrating to Oracle Autonomous Database
Part of a larger series of courses, which may indicate comprehensiveness
Assumes familiarity with Oracle Autonomous Database
Students may need access to Oracle Cloud infrastructure to complete the course

Save this course

Create your own learning path. Save this course to your list so you can find it easily later.
Save

Reviews summary

Practical oracle adb administration

According to students, the Oracle Autonomous Database Administration Workshop is a largely positive experience, offering comprehensive coverage of ADB. Learners particularly highlight the hands-on labs and practical demonstrations as highly valuable for applying concepts immediately. The course delves into key features like auto scaling, automatic indexing, Data Guard, and APEX/OML integration, making it current and relevant for professionals. However, some learners note that the course assumes prior Oracle knowledge, potentially posing a challenge for beginners. There were also occasional reports of intermittent lab setup issues, though recent feedback remains strong.
Provides a wide-ranging and relevant understanding of ADB.
"This workshop is incredibly well-structured and covers a vast amount of material on Oracle Autonomous Database."
"Excellent course! The modules on APEX and Oracle Machine Learning integration were a pleasant surprise and very well explained."
"A good overview of ADB. I found the sections on auto scaling and automatic indexing very insightful."
Offers invaluable practical experience through hands-on labs.
"The hands-on labs were particularly useful, allowing me to apply concepts immediately."
"The practical exercises reinforced the theoretical knowledge."
"The hands-on experience provided by the labs was invaluable. It truly is a workshop."
Specific topics like data migration could benefit from more detail.
"Some parts felt a bit rushed, especially the migration options, which could use more detailed examples."
"While the course covered important aspects of ADB, I felt some sections were not detailed enough. For example, the migration part was too brief."
"I wished for more in-depth coverage on certain advanced topics beyond the initial overview."
Some learners encountered technical difficulties with lab setups.
"I struggled with some of the lab setups. There were a few technical glitches mentioned by others..."
"Also, faced issues with lab environments not being stable."
"Some exercises were difficult to complete due to intermittent technical problems."
Best suited for learners with existing Oracle experience.
"I found this course assumed too much prior knowledge."
"It's definitely for professionals already familiar with Oracle concepts."
"I struggled to follow without extensive experience; it jumped into advanced topics too quickly."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Oracle Autonomous Database Administration Workshop with these activities:
Refresh SQL basics
Review the fundamental concepts of SQL to ensure a strong understanding before diving into the course.
Show steps
  • Review online tutorials and documentation
  • Complete practice exercises and quizzes
  • Set up a practice database and experiment with SQL commands
Create a comprehensive study guide
Organize and review all course materials, including notes, assignments, and resources, to enhance your understanding and retention.
Browse courses on Study Guide
Show steps
  • Gather all relevant course materials
  • Review and consolidate notes from lectures and readings
  • Summarize key concepts and create flashcards
  • Organize the study guide using a logical structure
SQL Coding Exercises
Reinforce your SQL skills through regular practice exercises to improve your proficiency in retrieving and manipulating data.
Browse courses on SQL
Show steps
  • Solve SQL puzzles and coding challenges.
  • Practice writing queries for various data retrieval scenarios.
  • Participate in online SQL coding contests.
Six other activities
Expand to see all activities and additional details
Show all nine activities
Build a Simple Web Application with APEX
Gain hands-on experience with APEX by building a simple web application to interact with your Autonomous Database.
Browse courses on APEX
Show steps
  • Familiarize yourself with APEX concepts.
  • Design and create a simple data model.
  • Develop and deploy the web application.
  • Test and evaluate the application.
Host a study group on Autonomous Database
Collaborate with classmates to enhance your understanding through discussions, knowledge sharing, and problem-solving.
Show steps
  • Invite classmates to join the study group
  • Establish meeting times and decide on topics
  • Facilitate discussions and encourage active participation
  • Review materials together and clarify concepts
Advanced Query Optimization
Explore more advanced techniques for optimizing queries to improve performance on Autonomous Database.
Browse courses on Query Optimization
Show steps
  • Review Oracle documentation and blogs on query optimization.
  • Identify and analyze slow-running queries.
  • Apply advanced techniques such as index selection, join elimination, and materialized views.
  • Monitor and test the performance of optimized queries.
Design an infographic explaining Autonomous Database concepts
Create a visually engaging infographic to reinforce your understanding of Autonomous Database concepts and share them with others.
Browse courses on Infographic Design
Show steps
  • Gather information and identify key concepts
  • Choose a design tool and template
  • Design the infographic using visuals, text, and data
  • Share the infographic online or present it to your peers
Develop an Autonomous Data Guard Disaster Recovery Plan
Create a comprehensive disaster recovery plan to protect your Autonomous Database from unexpected events.
Browse courses on Disaster Recovery
Show steps
  • Review Autonomous Data Guard concepts.
  • Design and implement an Autonomous Data Guard configuration.
  • Test and validate the disaster recovery plan.
  • Document and communicate the plan to stakeholders.
Participate in the Oracle Autonomous Database Hackathon
Engage in a coding challenge focused on Autonomous Database to test your skills and gain practical experience.
Show steps
  • Form a team or participate individually
  • Brainstorm and develop a solution that leverages Autonomous Database features
  • Submit your project and present it to the judges
  • Reflect on the experience and identify areas for improvement

Career center

Learners who complete Oracle Autonomous Database Administration Workshop will develop knowledge and skills that may be useful to these careers:
Database Administrator
Database Administrators are responsible for many different activities, including setting up databases, maintaining hardware and software, managing user access and security, and developing and implementing backup and recovery plans. The field of database administration is expected to grow by 10% over the next ten years, as demand for data continues to increase. This course may be useful for those who are interested in a career as a Database Administrator, as it provides a foundation in the core concepts of Oracle Autonomous Database.
See salaries and explore the career path for Database Administrator
Data Analyst
Data Analysts use their skills in data mining, statistics, and programming to extract meaningful insights from data. They work with businesses to help them make better decisions by providing them with information about their customers, products, and operations. The field of data analytics is expected to grow by 20% over the next ten years, as businesses increasingly rely on data to make informed decisions. This course may be useful for those who are interested in a career as a Data Analyst, as it provides a foundation in the core concepts of Oracle Autonomous Database.
See salaries and explore the career path for Data Analyst
Data Scientist
Data Scientists use their skills in mathematics, statistics, and programming to build models that can predict future events. They work with businesses to help them make better decisions by providing them with insights into their data. The field of data science is expected to grow by 28% over the next ten years, as businesses increasingly rely on data to make informed decisions. This course may be useful for those who are interested in a career as a Data Scientist, as it provides a foundation in the core concepts of Oracle Autonomous Database.
See salaries and explore the career path for Data Scientist
Software Engineer
Software Engineers design, develop, and maintain software systems. They work with businesses to help them solve their business problems by providing them with software solutions. The field of software engineering is expected to grow by 22% over the next ten years, as businesses increasingly rely on software to automate their operations. This course may be useful for those who are interested in a career as a Software Engineer, as it provides a foundation in the core concepts of Oracle Autonomous Database.
See salaries and explore the career path for Software Engineer
Computer Systems Analyst
Computer Systems Analysts design, develop, and maintain computer systems. They work with businesses to help them improve their efficiency and productivity by providing them with software solutions. The field of computer systems analysis is expected to grow by 10% over the next ten years, as businesses increasingly rely on computer systems to manage their operations. This course may be useful for those who are interested in a career as a Computer Systems Analyst, as it provides a foundation in the core concepts of Oracle Autonomous Database.
See salaries and explore the career path for Computer Systems Analyst
Information Security Analyst
Information Security Analysts protect computer systems and networks from unauthorized access, use, disclosure, disruption, modification, or destruction. They work with businesses to help them protect their data and systems from cyberattacks. The field of information security is expected to grow by 31% over the next ten years, as businesses increasingly rely on computer systems to manage their operations. This course may be useful for those who are interested in a career as an Information Security Analyst, as it provides a foundation in the core concepts of Oracle Autonomous Database.
See salaries and explore the career path for Information Security Analyst
Database Architect
Database Architects design, develop, and maintain database systems. They work with businesses to help them manage their data effectively and efficiently. The field of database architecture is expected to grow by 10% over the next ten years, as businesses increasingly rely on data to make informed decisions. This course may be useful for those who are interested in a career as a Database Architect, as it provides a foundation in the core concepts of Oracle Autonomous Database.
See salaries and explore the career path for Database Architect
Data Warehouse Architect
Data Warehouse Architects design, develop, and maintain data warehouses. They work with businesses to help them store and analyze their data effectively and efficiently. The field of data warehouse architecture is expected to grow by 10% over the next ten years, as businesses increasingly rely on data to make informed decisions. This course may be useful for those who are interested in a career as a Data Warehouse Architect, as it provides a foundation in the core concepts of Oracle Autonomous Database.
See salaries and explore the career path for Data Warehouse Architect
Data Governance Analyst
Data Governance Analysts develop and implement policies and procedures to ensure that data is managed in a consistent and reliable manner. They work with businesses to help them improve their data quality and compliance. The field of data governance is expected to grow by 10% over the next ten years, as businesses increasingly rely on data to make informed decisions. This course may be useful for those who are interested in a career as a Data Governance Analyst, as it provides a foundation in the core concepts of Oracle Autonomous Database.
See salaries and explore the career path for Data Governance Analyst
Business Intelligence Analyst
Business Intelligence Analysts use their skills in data analysis and visualization to help businesses make better decisions. They work with businesses to help them understand their data and identify trends and patterns. The field of business intelligence is expected to grow by 10% over the next ten years, as businesses increasingly rely on data to make informed decisions. This course may be useful for those who are interested in a career as a Business Intelligence Analyst, as it provides a foundation in the core concepts of Oracle Autonomous Database.
See salaries and explore the career path for Business Intelligence Analyst
Data Engineer
Data Engineers design, develop, and maintain data pipelines. They work with businesses to help them move data between different systems and applications. The field of data engineering is expected to grow by 10% over the next ten years, as businesses increasingly rely on data to make informed decisions. This course may be useful for those who are interested in a career as a Data Engineer, as it provides a foundation in the core concepts of Oracle Autonomous Database.
See salaries and explore the career path for Data Engineer
Cloud Architect
Cloud Architects design, develop, and maintain cloud-based systems. They work with businesses to help them move their applications and data to the cloud. The field of cloud architecture is expected to grow by 10% over the next ten years, as businesses increasingly rely on cloud-based services.
See salaries and explore the career path for Cloud Architect
DevOps Engineer
DevOps Engineers work with developers and operations teams to ensure that software is developed and deployed quickly and efficiently. The field of DevOps is expected to grow by 10% over the next ten years, as businesses increasingly rely on software to automate their operations.
See salaries and explore the career path for DevOps Engineer
Technical Program Manager
Technical Program Managers work with product managers and engineering teams to ensure that software is developed and deployed on time and within budget. The field of technical program management is expected to grow by 10% over the next ten years, as businesses increasingly rely on software to automate their operations.
See salaries and explore the career path for Technical Program Manager
Product Manager
Product Managers work with customers and engineers to develop and launch new products and features. The field of product management is expected to grow by 10% over the next ten years, as businesses increasingly rely on software to automate their operations.
See salaries and explore the career path for Product Manager

Reading list

We've selected six books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Oracle Autonomous Database Administration Workshop.
Cover image
Oracle Database 12c Install, Configure & Maintain...
Save
While this handbook focuses on Oracle Database 12c, it provides a solid foundation for understanding database administration concepts and practices, which are essential for managing Autonomous Databases.
Oracle Database 12c Install, Configure & Maintain...
Paperback
Check
Oracle Database 12c Install, Configure & Maintain...
Kindle Edition
Check
Machine Learning with Python for Everyone
Save
Provides a practical introduction to machine learning using Python, which is valuable for understanding Oracle Machine Learning, a key feature of Autonomous Database.
Machine Learning with Python for Everyone
Paperback
Check
Machine Learning with Python for Everyone
Kindle Edition
Check
Cover image
Oracle Application Express for Mobile Web...
Save
This cookbook offers practical recipes and examples for building web applications using Oracle APEX, which is deployed with Autonomous Database.
Oracle Application Express for Mobile Web...
Paperback
$$
Oracle Application Express for Mobile Web...
Kindle Edition
$$
Oracle Database Transactions and Locking Revealed
Save
Provides a comprehensive overview of Oracle Database architecture and concepts, including the underlying technologies and components that make up Autonomous Database. Serves as a foundational reference for understanding the technical aspects of the platform.
Oracle Database Transactions and Locking Revealed
Paperback
Check
Oracle Database Transactions and Locking Revealed
Kindle Edition
Check
Cover image
Mastering Oracle PL/SQL
Save
This guide provides a foundation for understanding database security concepts and practices, which are essential for managing Autonomous Databases securely.
Mastering Oracle PL/SQL
Paperback
Check
Mastering Oracle PL/SQL
Kindle Edition
Check
Cover image
SQL Run (Sixth Edition)
Save
Serves as a beginner-friendly introduction to SQL for Oracle Database, providing a good foundation for working with Autonomous Databases.
SQL Run (Sixth Edition)
Paperback
Check
SQL Run (Sixth Edition)
Kindle Edition
Check

Share

Help others find this course page by sharing it with your friends and followers:
Facebook
LinkedIn
Reddit
X
Link
Email

Similar courses

Here are four courses similar to Oracle Autonomous Database Administration Workshop.
Oracle Autonomous Database Administration
Most relevant
Oracle Cloud Data Management Foundations Workshop
Most relevant
Oracle Autonomous Database Administration
Most relevant
Oracle Cloud Infrastructure Architect Professional
Most relevant

edX Buyer Protection & Guarantee

Verified partner policies & purchase protections

World-Class University Partner
Free Trial & Audit

Free Audit Track Available

Free audit track available for most courses, giving open access to video lectures, course readings, and assignments at no charge.

Return & Refund Policy

14-Day Full Refund Window

14-day full refund available up to 14 days after course start or 14 days after payment (whichever comes second, up to 6 months max), provided verified certificate has not yet been earned.

Buyer Protections

Verified Academic & Industry Partner

University-backed credentials authored by elite institutions like Harvard, MIT, and Oxford, with tamper-proof certificate verification.

Key Purchase Protections
Free audit track for open learning access
14-day money-back guarantee on verified certificates
Prestigious university credentials (Harvard, MIT)
Automatic unenrollment refund process via dashboard
OpenCourser Verified Partner Policy details last reviewed: 2026-10-22
Course image
Effort
2 to 3 hours per week for 4 weeks
Level
Introductory
Via
edX
Institution
Oracle
Instructors
Kay Malcolm
Sean Stacey
Kamryn Vinson
Maria Colgan
Angela Wall
Henry Byorum
Patrick Wheeler
Killian Lynch
Kiana McDaniel
Mark Hornick
Sangeetha Kuppuswamy
Thea Lazarova
Bill Millar
Michelle Malcher
Language
English
Transcript
English
Traffic lights
Read about what's good
what should give you pause
and possible dealbreakers
Focuses on the architecture and purposes of Oracle Autonomous Database, including managing, maintaining, and monitoring it
Instructors are recognized for their work in Oracle Database technologies and applications
Provides instruction on multiple tools associated with Oracle Autonomous Database, including APEX, Machine Learning, SQL Developer Web, and Spatial
Covers important considerations for migrating to Oracle Autonomous Database
Part of a larger series of courses, which may indicate comprehensiveness
Assumes familiarity with Oracle Autonomous Database
Students may need access to Oracle Cloud infrastructure to complete the course
Share this
Share to help others discover this course.
Facebook LinkedIn X Reddit Link Email
Begin learning today
Enroll now to gain full access to Oracle Autonomous Database Administration Workshop.
Enroll now
Save for later
Add this course to your list. Find it anytime.
Save
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2025 OpenCourser