Autonomous JSON Database

Autonomous JSON Database Tutorials

JSON in Autonomous Database

Provision and connect to an Autonomous Database. Retrieve JSON data from a web service, insert it into the database, index it, and query it. Create a relational view based on the structure and type information in JSON documents (implicit, data-guide schema). Generate JSON data based on fields in other JSON data.

JSON in Autonomous Database, Introduction (20 minutes)

Use SQL and PL/SQL with JSON data stored in Oracle Autonomous JSON Database

JSON in Autonomous Database,Advanced (30 minutes)

SODA and JSON Tutorials

Using JSON to Implement a SQL Flex-Field Column (15 minutes)

Add a JSON flex-field column to a table. Use SQL to access individual JSON fields as relational columns.

Autonomous Transaction Processing Tutorials

Workshop 1: Autonomous Database Quickstart

  • Learn about Autonomous Database on Shared Infrastructure and learn how to create an instance in just a few clicks. Then load data into your database, query it, and visualize it.
    • Login to Oracle Cloud
    • Getting Started
    • Working with Free Sample Data Sets
    • Loading Data
    • Querying External Data
    • Visualizing Your Data

Workshop 2: Analyzing your data with Autonomous Database

  • Connect using secure wallets and monitor your Autonomous Database instances. Use Oracle Analytics Desktop (OAD) to visualize data in Autonomous Database. Use Oracle Machine Learning (OML) to try your hand at predictive analytics.
    • Login to Oracle Cloud
    • Getting Started
    • Managing and Monitoring
    • Working with Free Sample Data Sets
    • Loading Data
    • Querying External Data
    • Visualizing Your Data
    • Using Wallets for Secure Connections
    • Scaling and Performance
    • Getting Started with Machine Learning Notebooks
    • Building a Simple Machine Learning Algorithm

Oracle Machine Learning Quick Start