Go Class

This course includes:

  • 1.5 hours on-demand video
  • 35 downloadable resources
  • Full lifetime access
  • Access on mobile and TV

SQLite in R Programming (RSQLite)

Mahesh Babu via Udemy

(12 Reviews)

Overview

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.

Course Content

24 sections - 24 lectures - 01:23:20 total length

People Also Search

Students Also Bought

Flexygo low code

Flexygo low code

Sumérgete en el low-code de la mano de flexygo, y prepárate para las herramientas de desarrollo del futuro.

Python OOP Crash Course

Python OOP Crash Course

Learn to easily integrate all key OOP concepts such as classes, objects, polymorphism, inheritance into your Python code

Programowanie w JavaScript od Zera do Mastera

Programowanie w JavaScript od Zera do Mastera

Javascript od Podstaw + 100 omówionych pytań rekrut

Jenkins For Beginners

Jenkins For Beginners

Believe me You will learn a lot (SEE THE DESCRIPTION BELOW)

Design Patterns com Java - Entendendo Padrões de Projetos

Design Patterns com Java - Entendendo Padrões de Projetos

Aprenda os Padrões de Projetos GoF e Princípios de Programação SOLID em explicações práticas com exemplos reais em Java

Complete iOS 14, Swift 5 and Machine Learning with CoreML

Complete iOS 14, Swift 5 and Machine Learning with CoreML

Build An Amazing iOS 11 app Using CoreML

Instructor

Mahesh Babu

  • 3 Instructor Rating
  • 225 Reviews
  • 6344 Students

I have experience in data science and I am very good at Python programing, Tableau (BI Tool) and R programing. Based on my experience I have created the course by taking real time into consideration.

Also, I have good knowledge of Oracle Applications Techno Functional with experience over 11 years in various modules like AP, AR, GL,iExpenses, iProcurement, PO, OM, INV, Service Contracts, HRMS Work Structures, FixedAssets, E-Business Tax Manager and Workflow. I have worked on various implementation Projects as well as support projects. I have exposure of concepts of Oracle Advance Pricing and have taken many training to people. Also, having good knowledge on Oracle Cloud module like Human Capital Management, Fusion Procurement contracts and Fusion Project Portfolio Management (PPM). I have experience in SCM and Finance modules. Also, I have experience in Oracle Reporting tools like XML and Fusion OTBI.Exposure on RICE (Reports, Interfaces, Conversions, Extensions) components in the areas of Implementation, Up-gradation, and Customization. Having good experience in Bill Presentment Architecture in iReceivables. Oracle Fusion Data loading and also very good knowledge in iStore concepts.