Summer-Ready Savings: Find the Training Course You Need at a Price You'll Love


Oracle R Enterprise Essentials Ed 1 (Training On Demand)

Course Details
Code: D92440GC10
Tuition (USD): $1,360.00 $1,292.00 • Self Paced (2 days)
Generate a quote
Course Details
GSA (USD): $1,164.74 • Self Paced (2 days)
This course is available in other formats
Instructor-Led Classroom & Virtual
Oracle R Enterprise Essentials (D84959GC10)
Oracle R Enterprise Essentials (D84961GC10)

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.

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.

More Information

Oracle has adopted R as a language and environment to support statisticians, data analysts, and data scientists in performing statistical data analysis and advanced analytics, as well as generating sophisticated graphics. Oracle R Enterprise (ORE) is a component of the Oracle Database Advanced Analytics Option. ORE makes the open source R statistical programming language and environment ready for the enterprise and big data.

Skills Gained

  • 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


  • Experience with statistics
  • R programming experience

Course Details

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
Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward