The future of IBM Maximo: Work Centers and Inspections Can Transform Your Business


Using Oracle NoSQL Database Workshop Ed 1

  • Tuition USD $3,256 GSA  $2,569.27
  • Reviews star_rate star_rate star_rate star_rate star_half 508 Ratings
  • Course Code D86902GC10
  • Duration 4 days
  • Available Formats Classroom

In the Using Oracle NoSQL Database Workshop, you’ll learn how Oracle NoSQL Database is used by administrators as well as developers. Learn about the features and benefits of the Oracle NoSQL Database, how to optimize the KVStore's performance, how to manage backup and recovery and how to develop applications for Oracle NoSQL Database.

Please Note: This course is made up of two independent Oracle NoSQL courses: Oracle NoSQL Database for Administrators & Oracle NoSQL Database for Developers.

Learn To:

  • Plan installation of Oracle NoSQL Database.
  • Install and configure Oracle NoSQL Database.
  • Deploy Oracle NoSQL Database KVStore.
  • Secure the configuration.
  • Extend a KVStore by increasing the replication factor or capacity of the KVStore.
  • Troubleshoot installation and hardware failures.
  • Monitor and optimize Oracle NoSQL Database performance.
  • Perform backup, recovery, and upgrades.
  • Design a schema for Oracle NoSQL Database.
  • Use Oracle NoSQL Database APIs in an application to create, retrieve, and update data in a KVStore.
  • Encrypt data and create consistency and durability policies according to application requirements.

Benefits To You

Learn why and how Oracle NoSQL Database is used to store data, generally Big Data. Identify the features and benefits of the Oracle NoSQL Database. Understand the key concepts of the NoSQL technology and when to use the Oracle NoSQL Database versus an RDBMS.

Learn to design the schema for a Java application using a table based approach as well as a key value pair approach. Learn to create the code for storing, manipulating, and deleting data stored in a KVStore. You will also learn to handle exceptions and implement security, consistency, and durability policies for the KVStore and an application.

Skills Gained

  • Encrypt data and create consistency and durability policies according to application requirements
  • Plan installation of Oracle NoSQL Database
  • Install and configure Oracle NoSQL Database
  • Deploy Oracle NoSQL Database KVStore
  • Secure the configuration
  • Extend a KVStore by increasing the replication factor or capacity of the KVStore
  • Troubleshoot installation and hardware failures
  • Monitor and optimize Oracle NoSQL Database performance
  • Perform backup
  • recovery
  • and upgrades
  • Use Oracle NoSQL Database APIs in an application to create
  • retrieve
  • and update data in a KVStore
  • Design a schema for Oracle NoSQL Database

Course Details

Oracle NoSQL Database: Overview

  • Course Objectives
  • Key Features
  • Benefits of Using Oracle NoSQL Database
  • Supported Data Types
  • How Does the Oracle NoSQL Database Work
  • Oracle NoSQL Database Components
  • Partitions and Key Value Pairs
  • Performance and Throughput

Planning An Installation

  • KVStore Analysis: Tasks
  • Understanding Storage Capacity and Throughput Capacity
  • Using InitialCapacityPlanning Spreadsheet
  • Application Requirements
  • Hardware Requirements
  • Performance Requirements: Estimating Workload
  • Performance Requirements: Estimating Throughput
  • Configuration Requirements

Deploying a KVStore

  • Creating Directories
  • Extracting Software
  • Verifying the Installation
  • Configuring the Replication Nodes
  • Using the makebootconfig Utility
  • Starting the Admin CLI
  • Configuring KVStore
  • Creating a Data Center/Zone

Modifying a KVStore

  • Reasons to modify a cluster
  • Increasing a clusters capacity
  • Increasing a clusters replication factor
  • Steps to modify a cluster

Securing the Configuration

  • Security Overview
  • Performing a secure installation using makebootconfig
  • Secure an existing installation using securityconfig
  • Security.xml Parameters
  • Encrypting Data
  • Configuring Authentication
  • Default Security Policies
  • Security Guidelines

Disaster Recovery

  • Fixing Hardware Failures
  • Verifying a KVStore
  • Verify Command
  • Hardware Failures: Overview
  • Network Failure
  • Recovering from Network Failure
  • Detecting Storage Device Failures
  • Replacing a Failed Storage Device

Monitoring a KVStore

  • Introducing KVStore Parameters
  • Changing Parameters Using CLI
  • Changing Parameters Using Admin Console
  • Setting Replication Node Policy
  • Best Practice: Set Optimal JE Cache Size
  • Best Practice: JVM
  • Best Practice: Set Optimal Java Heap Size
  • General Monitoring

Managing a KVStore

  • Backup Process
  • Using Snapshots
  • Recovery Process
  • Using a Load Program
  • Upgrading the Software

Schema Design

  • Importance of Schema Design
  • Schema Design Options in ONDB
  • Key-Value Data Model
  • Table Data Model: Overview
  • Designing Parent Tables
  • Table Field Data Types
  • Keys and Indexes for Table Data Model
  • Defining Child Tables

Application Specific Requirements

  • Understanding the Write and Read Process
  • Consistency Policy: Definition
  • Applying Consistency
  • Default Consistency
  • Types of Consistency Polices
  • Predefined Consistency Policies
  • Time-based Consistency Policy
  • Version-based Consistency Policy

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
  • Creating a Table from CLI

Writing Data To Tables

  • Using the TableAPI
  • TableAPI Methods for Write Operations
  • 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

  • Reading a Table: Overview
  • Retrieving Table Data
  • Retrieving Single Row
  • Retrieving Multiple Rows
  • Retrieving Child Tables
  • Iterating A Table
  • Using MultiRowOptions
  • Specifying Ranges

Manipulating Data Stored in Key-Value Model

  • Structure of a Record: Review
  • Creating a Key Component: Overview
  • Creating Key Components
  • Creating a Value Component: Overview
  • Creating a Value
  • Retrieving Records: Overview
  • Writing Key-Value Pair to KVStore
  • Deleting Records

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

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
  • ContingencyException

How do I enroll?

A comprehensive listing of ExitCertified courses can be found here. You can register directly for the required course/location when you select "register". If you have any questions or prefer to speak with an ExitCertified education consultant directly, please submit your query here. A representative will contact you shortly.

How do I pay for a class?

You can pay at the time of registration using credit card (Mastercard/Visa/American Express) cheque or PO.

What if I have training credits?

ExitCertified honors all savings programs from the partners we work with. ExitCertified also offers training credits across multiple partners through our FLEX Account.

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.


Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

Its really nice to have the snacks available everyday. The staff is courteous and professional.

The course material was laid out logically. There are a lot of aws services and concepts to cover in the three days but overall was a good learning experience.

Very knowledgeable, and did a good job staying on pace. Was able to answer all questions posed.

Great Class and Chris was a very knowledgeable instructor. Hoping it prepped me well enough for upcoming exam!

Good content, worth taking if you are starting new to HDFS, it helps build your foundation

0 options available

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links above. We can also contact you when the course is scheduled in your area.

Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward