Oracle NoSQL Database for Developers

This Oracle NoSQL Database for Developers Ed 1 training will teach you how to use the Oracle NoSQL Database developer APIs for Java. Expert Oracle instructors will help you discover how to access the KVStore from a Java application to store and manipulate data in a KVStore. When you’re finished with this training, you will be able to identify the features and benefits of the Oracle NoSQL Database. Gain a deeper understanding of why and how the Oracle NoSQL Database is used to store data – generally Big Data. Developers, Application developers should attend this course.

Global IT is an authorized Oracle University WDP institution and offers classes at an affordable price. Whether you are pursuing certification or upgrading skills, we provide the same curriculum and materials used by Oracle University.

Course Introduction

• Course Objectives
• Course Schedule
• Course Environment
• Accessing the Labs Directory
• Introducing Persona
• Course Supplement
• Additional Resources

Big Data and NoSQL Overview

• Defining Big Data
• Oracle Big Data Solution
• What is a NoSQL Database
• RDBMS Compared to NoSQL
• HDFS
• HDFS Compared to NoSQL
• Consideration Points Before Opting for NoSQL
• Big Data Examples

Oracle NoSQL Database: Overview

• Introducing Oracle NoSQL Database
• Key Features
• How Does the Oracle NoSQL Database Work?
• Oracle NoSQL Database Components
• Partitions and Key Value Pairs
• Performance and Throughput
• Security Features: Overview
• Schema Overview

Schema Design

• Importance of Schema Design
• Schema Design Options in ONDB
• Key-Value Schema Structure
• Table Field Data Types
• Keys and Indexes for Table Data Model
• Defining Child Tables
• Creating Child Tables Vs Record Fields
• Schema Design Options in ONDB: Summary

Application Specific Requirements

• Understanding the Write and Read Process
• Consistency and Durability: Definition
• Applying Consistency and Durability
• Default Consistency and Durability
• Types of Consistency and Durability Polices
• Consistency and Durability Policies Summary

Creating Tables

• Creating Tables: Overview
• Data Definition Language Commands
• Using Create Table
• Using Check Constraint
• Creating a Table from Java Application
• Introducing TableAPI
• Executing a DDL Command (From app)
• Creating a Table from CLI

Writing Data To Tables

• Writing Data To Tables
• TableAPI Methods for Write Operation
• Writing Rows to Tables: Steps
• Constructing Handles
• Creating Row Object, Adding Fields, and Writing Records
• Write Method Definitions
• Creating the Row Object
• Using the Row Object

Retrieving Table Data

• Retrieving Table Data
• Retrieving Child Tables
• Iterating A Table
• Using MultiRowOptions
• Specifying Ranges
• Retrieving Nested Tables
• Reading Indexes
• Using Versions

Manipulating Data Stored in Key-Value Model

• Structure of a Record: Review
• Creating Key Components
• Creating a Value
• Retrieving Records
• Creating a Key Range and Key Depth
• Writing Key-Value Pair to KVStore
• Deleting Records
• Working with Versions

Configuring Consistency

• Consistency: Review
• Viewing the Default Consistency
• Creating Consistency Policies: Overview
• Using a Pre-defined Consistency
• Creating a Time Based Consistency
• Creating a Version Based Consistency
• Changing a Default Consistency
• Summary

Configuring Durability

• Durability: Review
• Viewing Default Durability
• Creating Durability Policies: Overview
• Setting a Synchronization-based Durability Policy
• Setting an Acknowledgement-based Durability Policy
• Creating a New Durability Policy
• Changing the Default Durability

Creating Transactions

• What is a Transactional Operation?
• Points to Remember
• Process
• TableOperationFactory: Methods
• Executing Operation Syntax

Handling Large Objects

• Introducing Large Objects
• Oracle NoSQL APIs for Large Objects
• Large Objects Storage
• Creating Large Object Keys
• Creating Key for Table API Users
• Storing Large Objects: API Overview
• Retrieve Large Objects: API Overview
• Deleting Large Objects: API Overview

Accessing a Secure Store

• Secure KVStore: Overview
• Security Features
• Obtaining a Handle to Secure Store
• Security Parameters
• Specifying Security Properties
• Security Constants

Handling Exceptions

• Understanding Exceptions
• Oracle NoSQL Database Exceptions
• Handling RequestTimeoutException
• Methods that Throw RequestTimeoutException
• RequestLimitException
• RequestLimitConfig
• FaultException
• Contingency Exception