Skip to Main Content
SQL, JSON, and MongoDB API: Unify worlds with Oracle Database 23ai

About This Workshop

Youtube Video

About This Workshop
In this workshop, you will experience Oracle's JSON capabilities using both relational and document-store APIs, namely the Oracle Database API for MongDB. The workshop loosely follows the Moviestreams theme, a series of workshops that demonstrate Oracle converged database capabilities. Throughout the workshop, you will work on our movies library.

This lab is organized into different topics, each involving multiple steps. After completing this workshop, a user will have a very good understanding of what JSON features are available in the Oracle Database and when to use them. You will work against the same data using both SQL and the Mongo DB API and will experience why the Oracle database is better suited for JSON Development than MongoDB, etc.

You can complete this entire workshop using your web browser. There is no need to install any extra software on your local machine. When writing a real application, you would call many of the functionalities from a programming language like Java, JavaScript(nodeJS), or Python.

Workshop Info

1 hour, 30 minutes
  • Store, query, and process JSON documents in collections using MongoDB API and SQL/JSON
  • Use SQL to query, generate, and process JSON data
  • Configure the Mongo API to query or manipulate data in the Oracle Database
  • Learn the newest SQL Enhancements to work with JSON data
  • An Oracle Database 23ai Free Developer Release or one running in a LiveLabs environment
  • Familiarity with Oracle Database is desirable, but not required
  • Familiarity with Mongo API is desirable, but not required
  • Some understanding of database terms is helpful

Other Workshops you might like

Ask Oracle
Helping you on LiveLabs