Oracle R Enterprise Essentials

Oracle R Enterprise Essentials

This Oracle R Enterprise Essentials training will teach you how to leverage the Oracle Database as a high performance computing platform from the powerful R statistical programming language and environment. Overcome the memory limitations of the open source client R engine. Prepare data, perform statistical analysis, and build predictive models on Big Data data sets that are generally impossible with open source R. Generate graphics and invoke R scripts from SQL for integration with the Oracle stack!

Learn To:

  • Start up R, load ORE, and connect to Oracle Database.
  • Use common constructs of the R language.
  • Use the ORE Transparency Layer.
  • Use ORE for embedded R execution.
  • Use ORE predictive analytics packages.
  • Use ROracle.

Suggested Prerequisite

  • Oracle Database 11g: Data Mining Techniques Ed 1

Required Prerequisite

  • Experience with statistics or R programming experience
  • Data Scientist
  • Data Scientist
  • Introducing Oracle R Enterprise
    • Using R: What, Who, and Why?
    • R User Interfaces
    • Oracle’s Strategy for R
  • Getting Started with ORE
    • Prerequisites for Using ORE
    • Starting R and Loading ORE
    • Basic Database Interaction with ORE
  • Introducing the R Language and Environment
    • Accessing R Help
    • R language basics
    • Debugging with R
  • Producing Graphs in R and ORE
    • R Graph Types
    • R Graphics Packages
    • Overloaded Functions for ORE
  • Using the ORE Transparency Layer - Part 1
    • Introducing the Transparency Layer
    • Working with Oracle Database
    • ORE Packages, Classes, and Functions
    • Common Data Transformations and Data Type Mapping
  • Using the ORE Transparency Layer - Part 2
    • Object Persistence
    • Ordering Framework
    • In-database Sampling and Random Partitioning
    • Case Study Examination
  • ORE Embedded R Execution - R Interface
    • Rationale for Embedded R Execution
    • Embedded R Execution
    • Connecting to Databases from an Embedded R Function
    • Generating Graphs within an Embedded R Function
  • ORE Embedded R Execution - SQL Interface
    • Embedded R Execution
    • Using R Scripts in the Database Repository
    • Generating Output Using rq*Eval Functions
    • Parallel Execution for Embedded R Scripts
  • Using ORE Predictive Analytics - Part 1
    • Using Functions in the OREdm Package
    • Using Functions in the OREmodels Package
  • Using ORE Predictive Analytics - Part 2
    • Scoring data within R models in the database
    • Preparing Time Series Data
    • Exponential Smoothing for Time Series Data Predictions
  • Using ROracle for Direct Database Access
    • What is ROracle?
    • Authentication
    • Table Access Methods
    • Query Execution
    • Rollback
  • Start up R, load ORE, and connect to Oracle Database
  • Apply R Language Basics
  • Use the ORE Transparency Layer
  • Use ORE for embedded R execution
  • Use ORE predictive analytics packages
  • Interact directly with Oracle Database objects using ROracle

Benefits To You

By taking this course, you will get a chance to manipulate database data using the R language. You will develop the knowledge and skills to use Oracle Database for predictive analysis using R. Leverage the database server machine for executing R scripts from SQL and R, both individually and in a data-parallel and task-parallel manner.

Date:

Location: Training On Demand For 90 days, learn any time through on demand digital courses. Search for specific topics and access digestible, modular course content plus hands-on labs.

Attachments:

Language: English

Price:

 Register here

* U cenu nije uračunat PDV