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
Laatste Versie
1.0.3Geüpload door
Hein Soe Aung
Android vereist
Android 5.0+
Categorie
Gratis Onderwijs APPInhoudsbeoordeling
Everyone
Melden
Rapporteer als ongepastLast updated on Oct 1, 2018
Minor bug fixes and improvements. Install or update to the newest version to check it out!
APKPure - Een multi-platform appstore die zich voornamelijk richt op Android en uitgebreide app-gerelateerde content biedt. Ontdek de app die je wilt, eenvoudiger, sneller en veiliger, met snelle en efficiënte downloads en installaties.
