Oracle logo

Oracle Converged Database for Developers - Series

Live Webinar
14 and 15 April, 2021
10:30 a.m. - 01:30 p.m. (CEST)
image

About Oracle's Converged Database

The Oracle Database converges support for multiple data models and workloads into a single database, while supporting popular development tools and techniques like events and REST interfaces. As opposed to using multiple single purpose databases for each data type, using a converged database results in a unified data tier, enabling real-time analytics and machine learning on production data.

You don't need to manage and maintain multiple systems or worry about having to provide unified security across them.

Objectives

In this 2 days workshop, you will gain first-hand experience of using data types beyond relational data - JSON, XML, Spatial and Graph.

Once you complete your setup, the next labs in this workshop cover these individual data types, and the final lab consists of multi-model examples:

Lab : NODE.JS
Lab : JSON
Lab : XML
Lab : Spatial
Lab : Graph
Lab : Cross Data Types
Lab : ORDS as Microservices

Agenda and Sessions description

14 April 10:30 a.m. - 1:30 p.m.
Lab 1: Generate SSH Keys, Lab 2: Prepare Setup, Lab 3: Environment Setup, Lab 4: Initialise Environment, Lab 5: NODE.JS, Lab 6: JSON
During this first session of the series, you will configure and prepare your environment for using different data types and different data models. You'll also use different data models to understand better the converged database concept.

Lab 1: Generate SSH Keys - You will generate the SSH keys to enable secure system administration and file transfers over insecure networks using encryption to secure the connections between endpoints to securely access to the Oracle Cloud Infrastructure compute instances.
Lab 2: Prepare Setup - You will download ORM stack & configure an existing Virtual Cloud Network (VCN).
Lab 3: Environment Setup - You will setup a Resource Manager stack that will generate the Oracle Cloud objects needed. You will use Terraform for that. After you will create a compute instance and a Networking Resource Manager Stack. And finally you will connect it to the compute instance.
Lab 4: Initialise Environment - In this lab you will review and startup all components required to successfully run this workshop. Additionally you will initialise the workshop environment.
Lab 5: NODE.JS - This lab walks you through the steps to start a Docker and Node.js Retail application. You will connect to a Node.js running in a Docker container on an Oracle Cloud Compute instance. While you can connect the Oracle Database instance using any client of your choice, in this lab you will connect using Oracle SQL Developer.
Lab 6: JSON - This lab shows you how to setup a JSON environment, using Oracle SQL Developer, create a JSON schema, insert and update JSON data, using APIs and finally you will see improvements in the simplicity of querying JSON documents using SQL.
15 April 10:30 a.m. - 1:30 p.m.
Lab 7: XML, Lab 8: Spatial, Lab 9: Graph, Lab 10: Cross Data Types, Lab 11: ORDS as Microservices
During this second session of the series, we will continue to use different data models to understand better the converged database concept.

Lab 7: XML - This lab shows you how to setup a XML environment, query XML data in different ways, insert and update XML contents. And finally you will look at various sample queries and functions within XML.
Lab 8: Spatial - This lab walks you through the steps of setting up the environment for Spatial lab.
Lab 9: Graph - This lab walks you through the steps of setting up the environment for graph. You will then get to run queries and publish your graph. Additionally you will use GraphViz and explore visualizing your graph.
Lab 10: Cross Data Types - This lab will show you how to use cross data functions such as JSON with Relational, XML with Relational and JSON with Spatial
Lab 11: ORDS as Microservices - This lab walks you through the steps of creating RESTful Services for JSON, XML and Spatial data using Oracle REST data services. As part of this lab, ORDS is pre-installed and you will walk through the steps of rest enabling schema and its tables. Additionally you will perform activities like retrieving data, inserting data, updating data and deleting data using GET, POST, PUT and DELETE methods respectively.