SQLite Tutorial

SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. The source code for SQLite is in the public domain. This app will give you a quick start with SQLite and make you comfortable with SQLite programming.

Features:

- Overview

- Installation

- Commands

- Syntax

- Data Type

- CREATE Database

- ATTACH Database

- DETACH Database

- CREATE Table

- DROP Table

- INSERT Query

- SELECT Query

- Operators

- Expressions

- WHERE Clause

- AND & OR Clauses

- UPDATE Query

- DELETE Query

- LIKE Clause

- GLOB Clause

- LIMIT Clause

- ORDER By Clause

- GROUP By Clause

- HAVING Clause

- DISTINCT Keyword

- PRAGMA

- Constraints

- JOINS

- UNIONS Clause

- NULL Values

- ALIAS Syntax

- Triggers

- Indexes

- INDEXED By Clause

- ALTER Command

- TRUNCATE Command

- Views

- Transactions

- Subqueries

- AUTOINCREMENT

- Injection

- EXPLAIN

- VACUUM

- Date & Time

- Useful Functions

- SQLite - C/C++

- SQLite - Java

- SQLite - PHP

- SQLite - Perl

- SQLite – Python

- Includes video tutorials

- Ability to learn on your own time from anywhere when you can’t access the internet.

- Optimized for most Android supported devices with enhanced graphics and design