SQLite Studio Tutorial for beginners

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 SQLite Studio. Once you complete this tutorial, you will get basics of SQLite and SQLite Studio.

Concepts covered in this course:

Overview

Installation

CREATE Database

CREATE Table

DROP Table

INSERT data into Table

SELECT data from Table

WHERE Clause

UPDATE Statement

DELETE Statement

LIKE Clause

GLOB Clause

LIMIT Clause

ORDER BY Clause

DISTINCT Keyword

GROUP By Clause

HAVING Clause

Constraints

Working with NULL values

ALTER Statement

VACCUM

INDEX

VIEW

AUTOINCREMENT

TRIGGERS

Subqueries

BETWEEN

UNION

Aggregate Functions

Transaction

I will explain all the basic concepts using SQLite and also Same concept will be explained SQLite Studio with examples.

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