Oracle logo

Converged Functionality of Oracle Autonomous Database for Developers

Live DevLab
23 September, 2021
10:30 a.m. - 01:30 p.m. (CEST)
image

About Oracle's Converged Database

The Oracle Database converges support for multiple data models and workloads into a single database, while supporting popular development tools and techniques like events and REST interfaces. As opposed to using multiple single purpose databases for each data type, using a converged database results in a unified data tier, enabling real-time analytics and machine learning on production data.

Oracle Autonomous Database is an excellent example of a converged database, as it provides support for Machine Learning, Blockchain, Graph, Spatial, JSON, REST, Events, Editions, and IoT Streaming as part of the core database at no additional cost. It allows you to support many diverse projects using a single platform, significantly reducing complexity and management overhead, while minimizing risk.

You don't need to manage and maintain multiple systems or worry about having to provide unified security across them.

Objectives

We will cover the following labs during this workshop:

  • Lab: Getting Started on the Cloud
  • Lab: Provisioning Autonomous Database
  • Lab: Preparing the data source into Object Storage
  • Lab: JSON
  • Lab: SODA
  • Lab: Spatial
  • Lab: XML
You will also use Oracle SQL Developer Web to help execute the programs associated with the lab.

Agenda and Sessions description

23 September 10:30 a.m. - 1:30 p.m.
Lab 1: Getting Started | Lab 2: Provisioning Autonomous Database | Lab 3: Preparing the data source into Object Storage | Lab 4: JSON and Oracle Autonomous Database | Lab 5: Oracle SODA | Lab 6: Oracle Spatial | Lab 7: Oracle XML and Autonomous Database
Lab 1: Getting Started: Before you get started, you will need an Oracle Cloud account. This 5-minute lab walks you through the steps of getting an Oracle Cloud Free Tier account and signing in..
Lab 2: Provisioning Autonomous Database - This lab walks you through the steps to get started using the Oracle Autonomous Database on Oracle Cloud.
Lab 3: Preparing the data source into Object Storage - This lab prepares the converged data sources required for the remaining labs of the workshop. In this case we will create an Object Storage bucket, upload data to your bucket and generate an Auth Token to allow access from the Autonomous Database to Object Storage.
Lab 4: JSON and Oracle Autonomous Database - This lab will show how JSON data can be stored and manipulated in the Autonomous Database.
Lab 5: Oracle SODA - In this lab you will be introduced to using the Oracle SODA APIs for Python. But you should be aware that SODA is also available for Java, REST, C and Node.js.
Lab 6: Oracle Spatial - This lab walks you through the steps of setting up the environment for Spatial lab and then takes you through. You can connect to the Oracle Database instance using any client of your choice. The instructions for this lab, document using SQL Developer Web and SQL*Plus in Cloud Shell.
Lab 7: Oracle XML and Autonomous Database