Szkolenia Oracle

Cel szkolenia szkolenie zdalne - dlearning

kod: OD-ELS-OREE | wersja: Ed 1

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. 



  • 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

Plan szkolenia Rozwiń listę

  1. Introducing Oracle R Enterprise
    • Using R: What, Who, and Why?
    • R User Interfaces
    • Oracle’s Strategy for R
  2. Getting Started with ORE
    • Prerequisites for Using ORE
    • Starting R and Loading ORE
    • Basic Database Interaction with ORE
  3. Introducing the R Language and Environment
    • Accessing R Help
    • R language basics
    • Debugging with R
  4. Producing Graphs in R and ORE
    • R Graph Types
    • R Graphics Packages
    • Overloaded Functions for ORE
  5. 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
  6. Using the ORE Transparency Layer - Part 2
    • Object Persistence
    • Ordering Framework
    • In-database Sampling and Random Partitioning
    • Case Study Examination
  7. 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
  8. 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
  9. Using ORE Predictive Analytics - Part 1
    • Using Functions in the OREdm Package
    • Using Functions in the OREmodels Package
  10. 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
  11. Using ROracle for Direct Database Access
    • What is ROracle?
    • Authentication
    • Table Access Methods
    • Query Execution
    • Rollback
Pobierz konspekt szkolenia w formacie PDF

Dodatkowe informacje

Wymagania wstępne

Suggested Prerequisite

  • Oracle Database 11g: Data Mining Techniques Ed 1

Required Prerequisite

  • Experience with statistics or R programming experience
Poziom trudności
Czas trwania 2 dni

Uczestnicy szkoleń otrzymają zaświadczenia o ukończeniu kursu sygnowane przez firmę Oracle.


Uczestnicy szkoleń otrzymają zaświadczenia o ukończeniu kursu sygnowane przez firmę Oracle.

Pozostałe szkolenia Oracle | Oracle Database

Szkolenia powiązane tematycznie

Bazy danych

Formularz kontaktowy

Prosimy o wypełnienie poniższego formularza, jeśli chcą Państwo uzyskać więcej informacji o powyższym szkoleniu.

* pola oznaczone (*) są wymagane

Informacje o przetwarzaniu danych przez Compendium – Centrum Edukacyjne Spółka z o.o.


Najbliższe szkolenia Oracle

Harmonogram szkoleń Oracle