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
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
Show More >