title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.
An Introduction to JSON in Oracle Databases
Duration
2
Course
DBOR-972
Available Formats
Classroom Training, Online Training
Course Description
Overview
JSON has become the preferred standard for data interchange and is used in most application APIs today.Learn how to implement JSON within an Oracle Database. Configuration is straight forward, but the ability to manipulate JSON data requires an understanding of various new features in Oracle. We will demonstrate the primary features students will need, together with recommendations when to use each. Students will do hands on labs to reinforce each feature.
Objectives
Prerequisites
-
This is an introduction to JSON, so you do not need any JSON background. But you do need a working knowledge of relational database concepts and Oracle’s implementation of SQL. Knowledge of PL/SQL will only be needed for the last topic: manipulating JSON data in PL/SQL.
Topics
What is JSON and what is it used for?
- How can I store JSON data in the database?
- How can I update JSON data in the database?
- How can I access JSON data that is stored in the database?
- How do I retrieve the entire JSON data structure?
- How do I retrieve just the parts of the JSON data that I need?
- How can I convert JSON data into relational data to store in the database?
- How can I convert relational data in the database to JSON if needed?
- How do I manipulate JSON data in PL/SQL?
Related Courses
-
Introduction to Oracle Database and SQL
DBOR-970- Duration: 3
- Delivery Format: Classroom Training, Online Training
- Price: 2,100.00 USD
-
Advanced SQL Queries for Oracle Databases
DBOR-973- Duration: 3
- Delivery Format: Classroom Training, Online Training
- Price: 2,100.00 USD
Self-Paced Training Info
Learn at your own pace with anytime, anywhere training
- Same in-demand topics as instructor-led public and private classes.
- Standalone learning or supplemental reinforcement.
- e-Learning content varies by course and technology.
- View the Self-Paced version of this outline and what is included in the SPVC course.
- Learn more about e-Learning
Course Added To Shopping Cart
bla
bla
bla
bla
bla
bla
Self-Paced Training Terms & Conditions
??spvc-wbt-warning??
Exam Terms & Conditions
??exam-warning??
??group-training-form-area??
??how-can-we-help-you-area??
??personalized-form-area??
??request-quote-area??
Sorry, there are no classes that meet your criteria.
Please contact us to schedule a class.
STOP! Before You Leave
Save 0% on this course!
Take advantage of our online-only offer & save 0% on any course !
Promo Code skip0 will be applied to your registration
Nothing yet
Purchase Information
??elearning-coursenumber?? ??coursename??
View Cart
title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.