Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

Oracle R Enterprise

( Duration: 2 Days )

This Oracle R Enterprise training course provides skills 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!

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.

By attending Oracle R Enterprise workshop, delegates will learn 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

  • Attend a training on Oracle Database - Data Mining Techniques or equivalent practical experience
  • Experience with statistics or R programming experience

The Oracle R Enterprise class is ideal for:

  • Data Scientists

COURSE AGENDA

1

Getting Started with ORE

  • Prerequisites for Using ORE
  • Starting R and Loading ORE
  • Basic Database Interaction with ORE
2

Introducing the R Language and Environment

  • Accessing R Help
  • R language basics
  • Debugging with R
3

Producing Graphs in R and ORE

  • R Graph Types
  • R Graphics Packages
  • Overloaded Functions for ORE
4

Using the ORE Transparency Layer

  • Introducing the Transparency Layer
  • Working with Oracle Database
  • ORE Packages, Classes, and Functions
  • Common Data Transformations and Data Type Mapping
  • Object Persistence
  • Ordering Framework
  • In-database Sampling and Random Partitioning
5

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
6

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
7

Using ORE Predictive Analytics

  • 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
8

Using ROracle for Direct Database Access

  • What is ROracle
  • Authentication
  • Table Access Methods
  • Query Execution
  • Rollback

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X