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
- RDBMS (SQL-based) 00:00:00
- Document Databases 00:00:00
- Key-Value Databases 00:00:00
- Columnar Databases 00:00:00
- Cassandra Overview 00:00:00
- Accessing Cassandra DataFrames from Cassandra 00:00:00
Course Reviews

ashar hafeez
0
62
Students
About Instructor
Pak
Course Events
[wplms_eventon_events]
More Courses by Insturctor
{"title":"","show_title":"0","post_type":"course","taxonomy":"","term":"0","post_ids":"","course_style":"rated","featured_style":"generic","masonry":"","grid_columns":"clear1 col-md-12","column_width":"268","gutter":"30","grid_number":"2","infinite":"","pagination":"","grid_excerpt_length":"100","grid_link":"1","grid_search":"0","course_type":"","css_class":"","container_css":"","custom_css":""}