Skip to Main Content
SQL Meets JSON in Oracle Database: Unify Data with Duality Views, JSON Collections & MongoDB API

About This Workshop

Youtube Video

About This Workshop
Torn between SQL and JSON? With Oracle Database, you don’t have to choose. In this hands-on lab, you’ll explore native JSON, the MongoDB-compatible API, and Duality Views—letting you access relational data as JSON. Whether you’re a SQL expert or a document-first developer, you’ll learn to build modern apps with a unified model, combining flexibility and performance.

Workshop Info

1 hour
  • Lab 1:  Provision ADBS
  • Lab 2: Schema flexibility for relational tables - JSON datatype
  • Lab 3: JSON Collections for storing documents
  • Lab 4: JSON Duality Views - JSON meets relational
  • Lab 5: MongoDB Plug-and-Play: Full MongoDB compatibility to work with JSON Collections and Duality Views
  • Autonomous Database 23ai 
  • 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
Powered by Oracle Digital Assistant and Oracle Generative AI