• No products in the cart.

ratings 

Mining data in R requires access to multiple data stores. Database Access in R is a hands-on, introductory-level course that explores dataframe manipulation, accessing common file formats, traditional Relational Databases, and NOSQL stores like MongoDB and Cassandra.

PRIVATE
Course Access

Unlimited Duration

Last Updated

March 2, 2021

Students Enrolled

Total Reviews

Posted by
Certification

This course is approximately 40% hands-on lab to 60% lecture ratio, combining engaging lecture, demos, group activities and discussions with light machine-based practical programming labs and exercises. In this course you will learn about:

· 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 Curriculum

    • Reading and Writing Tab and CSV files 00:00:00
    • Excel Spreadsheets 00:00:00
    • MS Access Files 00:00:00
    • Working with DataFrames 00:00:00
    • DataFrame tools 00:00:00
    • Merging and Joining DataFrames 00:00:00
    • Database CLIs with R (DBI, R/ODBC, R/JDBC) 00:00:00
    • SQLite 00:00:00
    • dplyr 00:00:00
    • ODBC drivers and the CLI 00:00:00
    • SELECT statements 00:00:00
    • INSERT statements 00:00:00
    • DELETE statements 00:00:00
    • UPDATE statements 00:00:00
    • DDL statements 00:00:00
    • DB Transactions 00:00:00
    • dplyr Features 00:00:00
    • Table verbs 00:00:00
    • Operations 00:00:00
    • Piping 00:00:00
    • RDBMS (SQL-based) 00:00:00
    • Document Databases 00:00:00
    • Key-Value Databases 00:00:00
    • Columnar Databases 00:00:00
    • MongoDB Overview 00:00:00
    • MongoDB and R 00:00:00
    • Mongo Queries 00:00:00
    • Cassandra Overview 00:00:00
    • Accessing Cassandra DataFrames from Cassandra 00:00:00

Course Reviews

Profile Photo
ashar hafeez
0
62

Students

About Instructor

Pak

Course Events

[wplms_eventon_events]

More Courses by Insturctor

© 2021 Ernesto.  All rights reserved.  
X