Using Oracle NoSQL Database 1.0 Training & Placements in Chennai SQL STAR

Using Oracle NoSQL Database

This Oracle NoSQL Database training will help you learn to use the Oracle NoSQL Database. You will learn how to install and configure a KVStore and manipulate data in a KVStore.

In this course, you'll learn what an Oracle NoSQL Database is, what the features and benefits are and how to use it to store Big Data. Explore key concepts of the NoSQL Database technology, while learning when to use the Oracle NoSQL Database versus an RDBMS.

Learn To:

• Monitorand optimize Oracle NoSQL Database performance.
• Performbackup, recovery and troubleshooting tasks.
• Create an application using Oracle NoSQL Database APIs.
• Define Big Data and identify when to use the Oracle NoSQL Database.
• Explainthe key features, benefits and components of Oracle NoSQLDatabase.
• Installand configure Oracle NoSQL Database.

Installing & Configuring a KVStore

This course will also teach you how to install and configure a KVStore. You'll learn to optimize the KVStore's performance, trouble shoot errors, create and store records, manipulate data, handle exceptions and implement consistency and durability policies.
Prerequisite
Suggested Prerequisite

• Understanding of Big Data
• Javaprogramming

Required Prerequisite

• Java SE7 Fundamentals
• Introduction to Oracle NoSQL Database

Audience

• Application Developers
• Database Administrators
• JavaDevelopers

Course Objectives

• Define Big Data
• Differentiatea NoSQL Database from the Relational Database Management System
• Identifywhen to use a NoSQL Database
• Identifythe key features of the Oracle NoSQL Database
• Explainthe Oracle NoSQL Database architecture
• Identifythe components of Oracle NoSQL Database
• UseKVLite
• Identifythe schema structure for Oracle NoSQL Database
• Define and design major and minor keys
• Define consistency and durability
• Identifythe Java API's to access the KVStore
• InstallOracle NoSQL Database
• Configurea KVStore using command line interface and admin console
• Explainhow to update an existing deployment
• Identifyhow to override a default consistency and durability policy
• Create and execute a transactional operation

Course Topics
Big Data and NoSQL Database Overview

• NoSQL Database versus RDBMS
• Big Data Evolution
• Defining Big Data
• Oracle Big Data Solution
• HDFS
• Consideration Points BeforeOpting for NoSQL Database
• Introducing NoSQL Database

Oracle NoSQL Database

• Introducing KVLite
• Partitions and Key Value Pairs
• Supported Data Types
• Accessing KVStore
• Defining the Oracle NoSQLDatabase
• Key Features and Benefits
• Components of the Oracle NoSQLDatabase
• How Does the Oracle NoSQLDatabase Work?

Designing a Schema

• Identifying the Major Key
• Schema Structure
• Identifying the Minor Key
• Design Considerations for KeyComponents
• What is a Value Component?
• Types of Value Component
• What is a Key Component?
• How is a Key Stored in theOracle NoSQL Database?

Consistency

• Understanding the Write and ReadProcess
• Time Based Consistency
• Understanding Consistency
• Version Based Consistency
• Predefined Consistency
• Default Consistency
• Applying Consistency

Durability

• Understanding Durability
• Default Durability
• Understanding the Write Process
• Applying Durability
• Acknowledgement Based Durability
• Synchronization Based Durability

Credit Card Application and APIs: Overview

• Credit card approval application
• Analyzing the Data
• APIs: Overview
• Identifying the Key Structure
• Designing the Schema

Administration: Overview

• Balancing a KVStore
• Defining Key Terms (Latency,Throughput, Cache)
• Steps to Deploy a KVStore (Plan,Install, Configure Installation, Configure KVStore)
• KVStore Components: Review
• Replication Nodes, Shards, andPartitions
• Security
• Tasks of the Administrator

Planning the Installation

• Analyze Workload and IdentifyHardware Resources, Install storage nodes, Configure Installation
• Determining ThroughputRequirements
• Determining Store Configuration
• Estimating Record Size
• Estimating Workload
• Analysis: Tasks
• Determining Cache Size

Setting-up the Oracle NoSQL Database Nodes

• Installation Steps
• Using the makebootconfig Utility
• Prerequisites Checklist
• Creating Directories
• Verifying the Installation
• Steps for Configuring theInstallation
• KVHOME and KVROOT
• Extracting Software

Configuring and Deploying the KVStore

• Configuration Tools
• States/Life cycle of a Plan
• Reviewing and Tracking Plans
• Creating a Storage Pool
• Creating a Data Center
• Configuring KVStore
• Introducing Plans
• Introducing the Admin Console

Store Parameters

• Introducing KVStore Parameters
• Parameters List
• Viewing Parameters
• Changing Parameters Using AdminConsole
• Setting Replication NodeParameters
• Setting Admin Parameters
• Setting Storage Node Parameters
• Changing Parameters Using CLI

Optimizing KVStore Performance

• Estimating JE Cache Size
• Optimizing Key Size
• Factors Affecting KVStorePerformance
• Setting JE Cache Size
• Introducing Java Heap Size
• Logging Garbage CollectionActivity
• Introducing JE Cache Size

Backup and Recovery

• Using Snapshots (commands tocreate, remove, list, and remove all)
• Managing Snapshots
• Introducing Snapshots
• Recovering KVStore: Using aSnapshot
• Backup Process
• Methods to Recover KVStore
• Recovering KVStore: Using a LoadProgram
• Updating an Existing Deployment

Trouble shooting

• Verifying a KVStore
• Monitoring a KVStore
• Replacing a Failed Storage Node
• Fixing Incorrect HA Port Ranges

Accessing the KVStore

• KVStoreFactory Class Definition
• Creating a KVStore Handle
• KVStore Handle
• KVStoreConfig Class Definition
• Creating a KVStore Handle:Example
• View KVStore Parameters' DefaultValues
• Using KVStoreFactory Class
• Using KVStoreConfig Class

Creating Key and Value Components

• Creating a Major Key Component
• Creating a Minor Key Component
• Creating a Value Component
• Creating Value Components:Examples
• Creating Value Components:Overview
• Creating a Key Component:Overview
• Structure of a Record: Review
• Creating a Key: Examples

Loading Data into a KVStore

• Methods Available to WriteRecords to KVStore
• Identify the Record Structure ofthe Sample Data
• Running the Sample Load Program
• Using the put() Method
• Creating a Load Program
• Reviewing a Sample Load Program
• The Load Process

Retrieving Data from a KVStore

• Using multiGet()
• get(): Example
• Key Range
• mutiGet(): Example
• Creating a Key Range
• Retrieving Records Methods:Overview
• Key Depth
• Using get()

Manipulating Data in a KVStore

• Methods: Overview
• putIfPresent(): Use Case
• Performing a Create Operation
• Deleting a Single Record:Example
• Deleting a Single Record
• putIfAbsent(): Use Case
• Deleting Multiple Records
• Performing an Update Operation

Handling Exceptions

• Methods that Throw RequestLimitException
• RequestLimit Exception
• Understanding Exceptions
• Handling RequestTimeoutException
• Oracle NoSQL Database Exceptions
• Handling RequestLimit Exception
• RequestTimeout Exception
• Methods that ThrowRequestTimeout Exception

Configuring Consistency

• Viewing the Default Consistency
• Creating Time Based Consistency
• Using Pre-defined Consistencies
• Over-riding the DefaultConsistency
• Changing the Default Consistency
• Creating Version BasedConsistency
• Consistency: Review

Configuring Consistency and Durability

• Viewing the Default Durability
• Handling Exceptions
• Transactional Operation
• Creating a New Durability Policy
• Setting Synchronization-basedDurability
• Executing a TransactionalOperation
• OperationFactory: Methods
• Durability: Review