Database Access in R | dplyR, NoSQL, MongoDB, Cassandra & More

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.

Retail Price: $1,895.00

Next Date: Request Date

Course Days: 2


Request a Date

Request Custom Course


Course Objectives

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

 

Course Prerequisites

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


Course Agenda

Please note that this list of topics is based on our standard course offering, evolved from typical industry uses and trends. We’ll work with you to tune this course and level of coverage to target the skills you need most. Topics, agenda and labs are subject to change, and may adjust during live delivery based on audience needs and skill-level.

 

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


Sorry! It looks like we haven’t updated our dates for the class you selected yet. There’s a quick way to find out. Contact us at 502.265.3057 or email info@training4it.com


Request a Date