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

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. You will work on our movies library throughout the workshop.

This lab is organized into different topics, each topic consists of multiple steps. After completing this workshop a user has a very good understanding of what JSON features are available in Oracle Database and when to use them. You will work against the same data using both SQL and using the Mongo DB API and will experience why 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