Show findcourses.com as: Mobile

Database Access in R

Trivera Technologies LLC
Training overview
Professional Course
2 days

Course description

Database Access in R

Mining data in R requires access to multiple data stores. In this course, we'll cover dataframe manipulation, accessing common file formats, traditional Relational Databases, and NOSQL stores like MongoDB and Cassandra. After completing the course, students will be able to work with data from a myriad of data sources they're likely to encounter in data science, manipulating, transforming, and joining disparate data sets to be able to extract profound insights.

Working in a hands-on learning, environment students will explore:

  • Data Frames and Data Files in R
  • Relational Databases
  • RDBMS with RODBC
  • Using dplyr
  • Working with NOSQL Databases
  • R and MongoDB
  • R and Cassandra and DataFrames from Cassandra

Who should attend?

This is an intermediate level course, geared for data scientists. Incoming students should have prior experience working with R.

Training content

Data Frames and Data Files in R

  • Reading and Writing Tab and CSV files
  • Excel Spreadsheets
  • MS Access Files
  • Working with DataFrames
  • DataFrame tools
  • Merging and Joining DataFrames

Relational Databases Overview

  • Database CLIs with R (DBI, R/ODBC, R/JDBC)
  • SQLite
  • dplyr

RDBMS with RODBC

  • ODBC drivers and the CLI
  • SELECT statements
  • INSERT statements
  • DELETE statements
  • UPDATE statements
  • DDL statements
  • DB Transactions

Using dplyr

  • dplyr Features
  • Table verbs
  • Operations
  • Piping

NOSQL Databases

  • RDBMS (SQL-based)
  • Document Databases
  • Key-Value Databases
  • Columnar Databases

R and MongoDB

  • MongoDB Overview
  • MongoDB and R
  • Mongo Queries

R and Cassandra

  • Cassandra Overview
  • Accessing Cassandra
  • DataFrames from Cassandra

Costs

  • Price: $1,895.00
  • Discounted Price: $1,231.75

Why choose Trivera Technologies LLC?

Over 25 years of technology training expertise.

Robust portfolio of over 1,000 leading edge technology courses.

Guaranteed to run courses and flexible learning options.

About Trivera Technologies LLC

Trivera Technologies

Trivera Technologies is a IT education services & courseware firm that offers a range of wide professional technical education services including: end to end IT training development and delivery, skills-based mentoring programs,new hire training and re-skilling services, courseware licensing and...


Read more and show all training delivered by this supplier

Contact this provider

Fill out your details to find out more about Database Access in R.

  Contact the provider

  Get more information

  Register your interest

Contact info

Trivera Technologies LLC

7862 West Irlo Bronson Highway
STE 626
Kissimmee FL 34747

 Show phone number
www.triveratech.com

Contact provider

Have a question about this course? Fill out this form and the provider will get in touch with you shortly

Training reviews

No reviews available

Need help with your search?

findcourses.com offers a free consultancy service to help compare training for you and your team

Request a free quote

Request a free training quote

You may also like...