Simple Oracle Document Access (SODA)

SODA and JSON Tutorials and Labs

Developing with JSON and SODA in Oracle Database (1 hour 30 minutes)

Provision an Autonomous JSON Database and use it to create an online shop selling used products. Create and query multiple JSON collections (products, shopping carts, orders) using SODA for REST and SQL. Learn how to update JSON data and generate JSON data from relational data. Discover the JSON Schema (structure and type information) implicit in your JSON data, and create a relational view over it.

SQL, JSON, and the MongoDB API: Unify Worlds with Oracle Database 23c Free (1 hour 30 minutes)

Explore Oracle Database features for working with JSON data. Use the same data with relational and document-centric APIs: SQL and Oracle Database API for MongoDB.

You complete the workshop using just a web browser. When developing a real application you can take advantage of the same features using languages such as Java, JavaScript, and Python.