Oracle NoSQL Database for Administrators
Duration : 2 Days (16 Hours)
Oracle NoSQL Database for Administrators Course Overview:
The Oracle NoSQL Database for Administrators course is tailored for administrators seeking to gain expertise in installing, configuring, and managing an Oracle NoSQL Database deployment. Participants will learn about NoSQL technology, provisioning deployments, ensuring security, implementing backup & recovery procedures, and monitoring performance. Ideal for experienced database administrators familiar with relational databases, this course empowers them to expand their skillset and integrate NoSQL technology into their repertoire.
- IT Professionals: Those responsible for installing, configuring, and managing an Oracle NoSQL Database within an enterprise system.
- Database Administrators: DBAs who want to gain a comprehensive understanding of the Oracle NoSQL Database architecture and learn best practices for installation, configuration, and management.
- Database Developers: Professionals involved in developing applications that utilize Oracle NoSQL Database and need to understand its deployment and management.
- System Administrators: IT administrators with Linux/Unix administration experience who are responsible for managing and maintaining the Oracle NoSQL Database environment.
- Distributed Systems Professionals: Those familiar with distributed systems concepts who want to enhance their knowledge of Oracle NoSQL Database and its efficient deployment and monitoring strategies.
Learning Objectives of Oracle NoSQL Database for Administrators:
1. Learn to install and configure Oracle NoSQL Database.
2. Understand the concepts of Command Line Interfaces (CLI) and Java APIs.
3. Design & implement Oracle NoSQL Database using best practices.
4. Administer Oracle NoSQL Database using CLI and APIs.
5. Setup security and access control of Oracle NoSQL Database.
6. Troubleshoot and monitor Oracle NoSQL Database across different workloads.
7. Implement hot-backup and replication for high availability requirements.
8. Understand the concepts of sharding and scale-out the Oracle NoSQL Database.
9. Get insights to develop application with Oracle NoSQL Database.
Module 1: Course Introduction
• Course Objectives
• Course Schedule
• Course Environment
• Accessing the Labs Directory
• Introducing Personas
• Course Supplement
• Additional Resources
Module 2: Oracle NoSQL Database: Overview
• Oracle NoSQL Database
• 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
Module 3: 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
• Performance Requirements: Estimating Cache Size
Module 4: Installing and Configuring Nodes
• Prerequisites Checklist
• Installation Steps
• Creating Directories
• Extracting Software
• Verifying the Installation
• Configuring the Replication Node
• Using the makebootconfig Utility
• Starting Storage Node Agents
Module 5: Configuring and Deploying A KVStore
• Configuration Steps
• Introducing Plans
• States of a Plan
• Starting the Admin CL
• Configuring KVStore
• Creating a Data Center/Zone
• Deploying an Admin Node
• Creating a Storage Pool
Module 6: Modifying a KVStore
• Reasons to modify a cluster
• Increasing a clusters capacity
• Increasing a clusters replication factor
• Steps to modify a cluster
Module 7: 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
Module 8: Troubleshooting Oracle NoSQL Database Installation Issues
• Verifying a KVStore
• Verify Command
• Verification Using Admin Console
• Locating the Installed Files
• Understanding the Installed Files
• Understanding the Log File
• Service States
• HA Port Ranges
Module 9: Fixing Hardware Failures
• Hardware Failures: Overview
• Network Failure
• Recovering from Network Failure
• Detecting Storage Device Failures
• Replacing a Failed Storage Device
• Detecting Server Failures
• Replacing a Failed Storage Node
• Migrating to the New Storage Node
Module 10: Setting Store Parameters
• Introducing KVStore Parameters
• List of Parameters
• Parameter Usage
• Viewing Parameters Using CLI
• Viewing Parameters Using the Admin Console
• Changing Parameters Using CLI
• Changing Parameters Using Admin Console
• Setting Replication Node Policy
Module 11: Optimizing KVStore Performance
• Best Practice: Set Optimal JE Cache Size
• Estimating JE Cache SizeRequirement
• Setting JE Cache Size
• Best Practice: JVM
• Best Practice: Set Optimal Java Heap Size
• Estimating Java Heap Size
• Setting Java Heap Size
• Best Practice: Log Garbage Collection Activity
Module 12: General Monitoring
• Monitoring the KVStore (include SNMP and JMX)
• Viewing the Events: Using Admin Console
• Viewing the Events: Using CLI
• Using SNMP and JMX
Module 13: Backup and Recovery
• Backup Process
• Introducing Snapshots
• Using Snapshots
• Recover Process
• Recovery: Using a Load Program
• Using the Load Program Guidelines
• Recovery: Directly Using Snapshots
• Updating an Existing Deployment
Module 14: Managing AVRO Schema
• Introducing AVRO schema
• JSON format
• Adding a schema
• Changing a schema
• Viewing a schema
• Disabling a schema
• Enabling a schema
Module 15: Upgrading the Software
• Upgrade Process: Overview
• Upgrading from R1 to R2
• Upgrading from R2 to R3
• Using a script
Oracle NoSQL Database for Administrators Course Prerequisites:
This Oracle NoSQL Database for Administrators training is designed for Database Administrators and Technical Consultants who work on the troubleshooting, installation, configuration and maintenance of the NoSQL Database, and the development of big data applications. The prerequisite of taking this course is;
1. Working knowledge of database design and SQL.
2. Understanding of Oracle database architecture, or other database models.
3. Knowledge of data warehousing concepts and ETL techniques.
4. Working knowledge of Unix/Linux commands.
5. Knowledge of big data solutions such as Hadoop is beneficial but not required.
Discover the perfect fit for your learning journey
Choose Learning Modality
This course comes with following benefits:
- Practice Labs.
- Get Trained by Certified Trainers.
- Access to the recordings of your class sessions for 90 days.
- Digital courseware
- Experience 24*7 learner support.
Got more questions? We’re all ears and ready to assist!