- App Performance Improved
✴ 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
