Learn - SQLite

Get all the Details about SQLite

✴ SQLite is a software library that provides a relational database management system. The lite in SQLite means light weight in terms of setup, database administration, and required resource.✴

►SQLite has the following noticeable features: self-contained, server less, zero-configuration, transactional.✦

►This App has been prepared for beginners to help them understand the basic-to-advanced concepts related to SQLite Database Engine.☆

【Topics Covered in this App are Listed Below】

⇢ Overview

⇢ Installation

⇢ Commands

⇢ Data Type

⇢ CREATE Database

⇢ ATTACH Database

⇢ DETACH Database

⇢ CREATE Table

⇢ DROP Table

⇢ INSERT Query

⇢ SELECT Query

⇢ Operators

⇢ Expressions

⇢ WHERE Clause

⇢ AND & OR Operators

⇢ UPDATE Query

⇢ DELETE Query

⇢ LIKE Clause

⇢ GLOB Clause

⇢ LIMIT Clause

⇢ ORDER BY Clause

⇢ GROUP BY Clause

⇢ HAVING Clause

⇢ DISTINCT Keyword

⇢ PRAGMA

⇢ Constraints

⇢ JOINS

⇢ UNION Clause

⇢ NULL Values

⇢ ALIAS Syntax

⇢ Triggers

⇢ Indexes

⇢ INDEXED BY Clause

⇢ ALTER TABLE Command

⇢ TRUNCATE TABLE Command

⇢ Views

⇢ Transactions

⇢ Subqueries

⇢ AUTOINCREMENT

⇢ Injection

⇢ EXPLAIN

⇢ VACUUM

⇢ Date & Time

⇢ Useful Functions

⇢ C/C++

⇢ Java

⇢ PHP

⇢ Perl

⇢ Python