Database Access in R

Mining data in R requires access to multiple data stores. In this course, you’ll learn about DataFrame manipulation, accessing common file formats, traditional relational databases, and NoSQL stores like MongoDB and Cassandra. After completing this course, you’ll be able to join, manipulate, and transform disparate data sets from a myriad of data sources to extract meaningful insights.

Retail Price: $1,895.00

Next Date: Request Date

Course Days: 2


Request a Date

Request Custom Course


WHAT YOU'LL LEARN

Join an engaging hands-on learning environment, where you’ll learn:

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

Data Scientists and other technical professionals with R programming experience.

PREREQUISITES

You should have prior experience programming with R.

  • R Programming for Data Scientists and Analysts

COURSE OUTLINE

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, and 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