Duración

2 días - 12 horas

Descripción

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!

Objetivos

  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.

Audience

  • 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

Fabricante

Oracle

Metodología

Presencial

Certificación

Garantía juvenil

 

¿TIENES DUDAS? PREGÚNTANOS

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