MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + .srt | Duration: 24 lectures (1h 23m) | Size: 538.1 MB

After completing this course you will get knowledge of basic concepts RSQLite library in R and you can start writing code on your own.

SQLite in R Programming using RSQLite library

Basic knowledge of Computers

SQLite is an open source, serverless, zero-configuration, self-contained, stand alone, transaction relational database ee designed to be embedded into an application.

This course help you to start with using RSQLite library in R. Once you complete this tutorial, you will get basics of RSQLite library.

Concepts covered in this course:

Overview

Installation

Sample Database Creation

Create a Table

Inserting Data

Selecting Data

Selecting Data Using Where Clause

Order By Clause

LIMIT option

Deleting Rows

Update Data

Working with Joins on Tables

Alter table

Group by Clause

LIKE Operator

Distinct Operator

RSQLite built in methods (dbListTables, dbListFields, dbListObjects etc.,)

I will explain all the basic concepts using RSQLite library in R Programming with examples.

I will also provide document for each concept for your reference.

People who wants to learn database concepts of SQLite in R Programming using RSQLite Library.



DOWNLOAD
uploadgig