SQLite Tutorial

Android App Analysis and Review: SQLite Tutorial, Developed by LearningPoint. Listed in Education Category. Current Version Is 1.0, Updated On 25/12/2018 . According to users reviews on Google Play: SQLite Tutorial. Achieved Over 5 thousand Installs. SQLite Tutorial Currently Has 19 Reviews, Average Rating 4.4 Stars

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

Read more