We’re sorry. We could not find a match for your search.

We suggest you try the following to help find what you're looking for:

  • Check the spelling of your keyword search.
  • Use synonyms for the keyword you typed, for example, try “application” instead of “software.”
  • Start a new search.


Join this lab to learn how to provision an Autonomous JSON database, get an Introduction to JSON collections, SODA for REST and about how to use SQL to work with JSON.

This lab provides insights regarding the true meaning of a Converged Database. We'll start from the JSON data type perspective but quickly introduce the industry standard to combine JSON data with Relational data: the SQL language and its set of new SQL:2016 functions to process JSON documents.

The learning curve is based on true use cases introduced as if you were a developer working for a fictive e-commerce startup.

Estimated lab time: 1 hour


  • configure the DRAGON tool to easily provision your Autonomous Database and a micro-service used to load JSON data
  • learn best practices to load JSON documents using the SODA API for Java
  • use different types of JSON indexes to speed up data retrieval
  • create a Relational view over JSON data joined with Relational data
  • create a compressed materialized view overs JSON data
  • join relational data with JSON data


  • An Oracle Cloud Account. You can sign up for an Oracle Free Tier account here
  • Bring a laptop to engage in activities

Note: If you have a Free Trial account, when your Free Trial expires, your account will be converted to an Always Free account. You will not be able to conduct Free Tier workshops unless the Always Free environment is available.

The Experience Lab registration process

Book an Experience Lab session in 3 easy steps

Choose a session
Choose a session
Fill in your details
Fill in your details
Get confirmation
Get confirmation
Experience the lab
Experience the lab

View the full suite of Experience Labs