Table of Contents

• List of Examples
• List of Figures
• List of Tables
• Title and Copyright Information
• 1 Get Started
  • Getting started with Oracle NoSQL Database
    • Start your data store
    • Starting the SQL shell
    • Sample use-cases used in the examples
    • Tables used in the examples
    • Describe tables
    • Sample data to run queries
    • Table Hierarchies
    • About Oracle NoSQL Database SDK drivers
    • Obtaining a NoSQL Handle
• 2 Create
  • Creating a namespace
  • Creating a region
  • Creating a table
    • Using SQL commands
    • Using TableRequest API
  • Create and View Indexes
    • Classification of Indexes
    • Creating Indexes
      • Using SQL commands
      • Using TableRequest API
    • View Index
• 3 Manage
  • Namespace Management
    • Namespace Resolution
    • Manage Namespaces
    • Namespace scoped privileges
    • Granting Authorization Access to Namespaces
  • Managing Tables, Indexes & Regions
    • Alter Table
      • Using SQL command to alter table
      • Using TableRequest API to alter table
    • Drop Table
      • Using SQL command to drop table
      • Using TableRequest API to drop table
    • Drop Index
      • Using SQL command to drop index
      • Using TableRequest API to drop index
    • Manage regions
• 4 Develop
  • Inserting, Modifying, and Deleting Data
    • Insert data
      • Using SQL command to insert data
      • Using Put API to insert data
      • Using MultiWrite API to insert data
    • Upsert Data
      • Using SQL command to upsert data
      • Using API to upsert data
    • Update Data
      • Using SQL command to update data
      • Using API to update data
    • Modify JSON data
      • Using SQL command
      • Using API
    • Delete Data
      • Using SQL command to delete data
      • Using API to delete a single row
      • Using API to delete multiple rows
      • Using Query API to delete data
  • Simple SELECT queries
    • Using SQL commands to fetch data
    • Substituting column names in a query
    • Using Get API to fetch data
    • Using Query API to fetch data
  • SELECT queries on JSON collection tables
  • Using Path expressions
    • Using Internal variables and aliases
    • Working with Arrays
    • Working with nested data type
    • Finding the size of a complex data type
  • Using Left Outer joins with parent-child tables
    • Overview of Left Outer Joins
    • Examples using Left Outer Joins
      • SQL Examples
      • Query API examples
  • Using NESTED TABLES to join parent-child tables
    • Overview of NESTED TABLES
    • Examples using NESTED TABLES
      • SQL Examples
      • Query API examples
  • Tuning and Optimizing SQL queries
    • Using Indexes for query optimization
    • Examples of queries using index
  • Managing GeoJSON data
    • geo_inside
    • geo_intersect
    • geo_distance
    • geo_within_distance
    • geo_near
    • geo_is_geometry
• 5 Reference
  • Operators in SQL
    • Sequence Comparison Operators
    • Logical operators
    • NULL operators
    • Value Comparison Operators
    • BETWEEN Operator
    • IN Operator
    • Regular Expression Conditions
    • EXISTS Operator
    • Is-Of-Type Operator
    • SQL Operators examples using QueryRequest API
  • Sorting, Grouping & Limiting results
    • Ordering results
    • Limit and offset results
    • Grouping results
    • Aggregating results
    • Examples using QueryRequest API
  • Primary Expressions in SQL
    • Parenthesized Expressions
    • Case Expressions
    • Cast Expression
    • Sequence Transform Expressions
    • Extract Expressions
    • SQL Expression examples using QueryRequest API
  • Timestamp Functions
    • Timestamp Arithmetic Functions
    • Timestamp Round Functions
    • Timestamp Format Functions
    • Timestamp Extract Functions
    • Current Time Functions
    • Examples using QueryRequest API
  • Functions on Strings
    • substring function
    • concat function
    • upper and lower functions
    • trim function
    • length function
    • contains function
    • starts_with and ends_with functions
    • index_of function
    • replace function
    • reverse function
    • Examples using QueryRequest API
  • Query execution plan
    • Overview of query plan
    • Query 1: Using primary key index with an index range scan
    • Query 2: Using primary key index with an index predicate
    • Query 3: Using a secondary index with an index range scan
    • Query 4: Using the primary index
    • Query 5: Sort the data using a Covering index
    • Query 6: Using a secondary index with an index predicate
    • Query 7: Group data with fields as part of the index
    • Query 8: Using the secondary index with multiple index scans
    • Query 9: A SINGLE PARTITION query using a primary index
    • Query 10: Group data with fields not part of any index
  • Table Modelling and Design
    • Schema Flexibility in Oracle NoSQL Database
    • Choice of Keys in NoSQL Database
    • Using Indexes in NoSQL Database
    • Transactions in NoSQL database
  • Handling Errors
    • Handling Driver Errors