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
Description:
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.
