What you'll learn:
After completing this course you will get knowledge of basic concepts RSQLite library in R and you can start writing code on your own.
Requirements
Basic knowledge of Computers
Description
SQLite is an open source, serverless, zero-configuration, self-contained, stand alone, transaction relational database engine 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.
Who this course is for
People who wants to learn database concepts of SQLite in R Programming using RSQLite Library.
Homepage
https://www.udemy.com/course/sqlite-in-r-programming-rsqlite

Related Downloads :

{related-news}