We may earn an affiliate commission when you visit our partners.
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.
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
Register for this course and see more details by visiting:
OpenCourser.com/course/g850ug/oracle
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
- 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
Good to know
Good to know
Know what's good ,
what to watch for , 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
Save Oracle Autonomous Database Administration Workshop to your list so you can find it easily later:
Save
Save
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Refresh SQL basics
Show steps
Review the fundamental concepts of SQL to ensure a strong understanding before diving into the course.
Show steps
Show steps
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
Show steps
Organize and review all course materials, including notes, assignments, and resources, to enhance your understanding and retention.
Browse courses on
Study Guide
Show steps
Show steps
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
Show steps
Reinforce your SQL skills through regular practice exercises to improve your proficiency in retrieving and manipulating data.
Browse courses on
SQL
Show steps
Show steps
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
Show steps
Gain hands-on experience with APEX by building a simple web application to interact with your Autonomous Database.
Browse courses on
APEX
Show steps
Show steps
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
Show steps
Collaborate with classmates to enhance your understanding through discussions, knowledge sharing, and problem-solving.
Show steps
Show steps
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
Show steps
Explore more advanced techniques for optimizing queries to improve performance on Autonomous Database.
Browse courses on
Query Optimization
Show steps
Show steps
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
Show steps
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
Show steps
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
Show steps
Create a comprehensive disaster recovery plan to protect your Autonomous Database from unexpected events.
Browse courses on
Disaster Recovery
Show steps
Show steps
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
Show steps
Engage in a coding challenge focused on Autonomous Database to test your skills and gain practical experience.
Show steps
Show steps
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:
Data Scientist
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.
Software Engineer
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.
Data Analyst
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.
Database Administrator
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.
Information Security 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.
Product 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.
Data Engineer
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.
Cloud Architect
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.
Business Intelligence 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.
DevOps Engineer
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.
Computer Systems Analyst
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.
Database Architect
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.
Technical Program Manager
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.
Data Warehouse 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.
Data Governance Analyst
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.
For more career information including salaries, visit:
OpenCourser.com/course/g850ug/oracle
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.
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.
Provides a practical introduction to machine learning using Python, which is valuable for understanding Oracle Machine Learning, a key feature of Autonomous Database.
This cookbook offers practical recipes and examples for building web applications using Oracle APEX, which is deployed with Autonomous Database.
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.
This guide provides a foundation for understanding database security concepts and practices, which are essential for managing Autonomous Databases securely.
Serves as a beginner-friendly introduction to SQL for Oracle Database, providing a good foundation for working with Autonomous Databases.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/g850ug/oracle
Share
Similar courses
Here are nine courses similar to
Oracle Autonomous Database Administration Workshop.
Warehousing Data with Oracle Autonomous Data Warehouse Cloud
OpenCourser.com/course/n6tkl4/warehousing
Warehousing Data with Oracle Autonomous Data Warehouse...
Most relevant
Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Design Considerations for PL/SQL Code
OpenCourser.com/course/9188s9/oracle
Oracle Database Program with PL/SQL Exam Number: 1Z0-149 ...
Most relevant
Oracle Autonomous Database Administration
OpenCourser.com/course/vi3vfb/oracle
Oracle Autonomous Database Administration
Most relevant
Learning Oracle 12c - A Beginners Oracle Training Video
OpenCourser.com/course/0kf5wb/learning
Learning Oracle 12c - A Beginners Oracle Training Video
Most relevant
Oracle Autonomous Database Administration
OpenCourser.com/course/mpmu98/oracle
Oracle Autonomous Database Administration
Most relevant
Building APEX Applications with Different Data Formats
OpenCourser.com/course/yagfhx/building
Building APEX Applications with Different Data Formats
Most relevant
Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Writing SQL in PL/SQL
OpenCourser.com/course/caexo1/oracle
Oracle Database Program with PL/SQL Exam Number: 1Z0-149 ...
Most relevant
The Complete PL/SQL Bootcamp : "Beginner to Advanced PL/SQL"
OpenCourser.com/course/mkokzo/the
The Complete PL/SQL Bootcamp : "Beginner to Advanced...
Most relevant
The Complete Oracle SQL Bootcamp (2024)
OpenCourser.com/course/bi3zvm/the
The Complete Oracle SQL Bootcamp (2024)
Most relevant
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
Good to know
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
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 - 2024 OpenCourser