Using R with Databases
The intent of this course is to teach you how to unlock the power and magic of R to analyze data in relational databases. It will show you how to connect to relational databases, access and query the database, update and modify the data, analyze it and perform simple visualizations.
About This Course
Do you want to leverage the power of R to unlock the value of data in relational databases?
Are you a SQL professional and looking to get skilled in data science?
Are the limits of R programming language preventing you from analyzing very large data sets?
If you answered yes to any of these questions, this course is for you. It will introduce you to the benefits of using R with databases. Teach you how to connect to databases from R. Show you how to create database objects, populate the database, and issue SQL queries to retrieve and modify your data from R. The course will also delve into advanced topics of using stored procedures and utilizing in-database analytics with R.
Course Syllabus
Module 1 – R and Relational Databases
Module 2 – Connecting to Relational Databases using RJDBC and RODBC
Module 3 – Database Design and Querying Data
Module 4 – Modifying Data and Using Stored Procedures
Module 5 – In-Database Analytics with R
You May Like
Cómo calcular tu inversión
En esta capacitación aprenderás las competencias necesarias para calcular la inversión inicial para emprender tu negocio. Serás capaz de programar, organizar, dirigir y coordinar...
Autoencoders and Regularization – Learn and Implement
In this course, you'll explore how Autoencoders compress, denoise, and derive valuable features from data. You'll also delve into regularization to curb overfitting and...
Learn Recurrent Neural Networks Hands-On
In the real world, data often comes in sequences: text, speech, time-series data, and more. RNNs are the key to understanding and working with...
Convolutional Neural Networks with PyTorch
In this course you will gain practical skills to tackle real-world image analysis and computer vision challenges using PyTorch. Uncover the power of Convolutional...
Serverless Computing using Cloud Functions – Developer I
This course is designed to teach you serverless computing essentials which include how to develop serverless applications composed of loosely-coupled, microservice-like functions. You will...
Course Features
- Lectures 0
- Quizzes 0
- Duration
- Skill level Principiante
- Language English
- Students 0
- Assessments Yes