2 días - 12 horas


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!


  1. Start up R, load ORE, and connect to Oracle Database
  2. Apply R Language Basics
  3. Use the ORE Transparency Layer
  4. Use ORE for embedded R execution
  5. Use ORE predictive analytics packages
  6. Interact directly with Oracle Database objects using ROracle

Contenidos del curso

Introduction 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

Información extra

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.


  • Data Scientist
  • Statistician

Related Training

Required Prerequisites

  • Experience with statistics or R programming experience

Suggested Prerequisites

  • Oracle Database 11g: Data Mining Techniques

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.

Información general

Área formativa

Oracle Big Data and Analytics






Garantía juvenil



He leído y acepto la del sitio y las condiciones de tratamiento de mis datos de carácter personal



Fecha Hora Ubicación Precio
No hay convocatoria programada. Por favor, consúltanos sobre próximas fechas y precio para esta formación.

¿Necesitas Ayuda?

Consúltanos si necesitas información de nuestros cursos o masters.


Contacta con Core Networks