Using SQL in R by creating an internal connection in system memory is one of the best ways to work with SQL without a server connection and provides good tools to the data analyst to work with datasets.
__________
Chapters :
0:00 Introduction
1:40 Importing data set
2:14 SQL Connection Setup
4:25 SQL Queries Test
6:08 Saving SQL Output as df
__________
Dataset used in video : https://contextures.com/xlsampledata0...
#rprogramming #sql #sqlite #data #datanalytics #connection