About this Course

Course Code TPD84961GC10
Duration 2 Days

In the Oracle R Enterprise Essentials course you will learn how to access the power of Oracle Database and break through the memory constraints of R by using R and ORE together.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 Use ROracle.Benefits To YouOracle 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.You will learn how to interact with database data using the R language, use Oracle Database for predictive analysis, and leverage the database server machine for executing R scripts from SQL and R both individually and in a data-parallel and task-parallel manner.Live Virtual Class FormatA Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.


  • Experience with statisticsR programming experienceExperience with object oriented programming

Delegates will learn how to

  • 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


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

2 Days


This is a QA approved partner course

Delivery Method

Delivery method

Virtual learning

Recreates a classroom experience online, enabling full interactions with the learning professional leading the course.

Find dates and prices

Sorry, we don't have any public dates scheduled for this course, but it can be run as a closed event for your company.
Please contact us for details on alternative ways we can help you 0113 220 7150 or email us at info@qa.com.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.